This is an archive version of the document. To get the most up-to-date information, see the current version.

Set-VEORIRDatabase

Short Description

Changes switchover settings of an instant recovery session for Oracle database.

Applies to

Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Set-VEORIRDatabase [-Database] <VEORIRDatabase> [-SwitchOverOptions] <VEORIRSwitchOverOptions> [<CommonParameters>]

Detailed Description

This cmdlet allows you to change the switchover option for a specified Oracle database.

Set-VEORIRDatabase Important!

You can not modify the switchover option that starts the switchover immediately after database files are copied and synchronized.

Parameters

Parameter

Description

Type

Required

Position

Accept Pipeline Input

Database

Specifies a published Oracle database within an instant recovery session.

Accepts the VEORIRDatabase object. To get this object, run the Get-VEORIRDatabase cmdlet.

True

0

True (ByValue)

SwitchOverOptions

Specified a switchover option for the necessary Oracle database.

Accepts the VEORIRSwitchOverOptions object. To create this object, run the New-VEORIRSwitchOverOptions cmdlet.

True

1

True (ByValue)

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.

Example

Examples 1. Setting Scheduled Switchover of Oracle Database

This example shows how to set the scheduled switchover for the orcl1.tech.local database. The cmdlet will perform the switchover at 13:00:00 on 2020-11-24.

$time = Get-Date -Date "2020-12-4 13:00:00"

$TimeUtc = $time.ToUniversalTime()

$ScheduledSwitch = New-VEORIRSwitchOverOptions -Scheduled -SwitchingTimeUtc $TimeUtc

$IRDatabase = Get-VEORIRDatabase -DatabaseName "orcl1.tech.local"

Set-VEORIRDatabase -Database $IRDatabase -SwitchOverOptions $ScheduledSwitch

Perform the following steps:

  1. Run the Get-Date cmdlet and specify the date and time when the switchover must be performed. Save the result to the $time variable.
  2. Use the ToUniversalTime() method to convert the date and time to the UTC format.
  3. Run the New-VEORIRSwitchOverOptions cmdlet.  Specify the Scheduled parameter and specify the SwitchingTimeUtc parameter value. Save the result to the $ScheduledSwitch variable.
  4. Run the Get-VEORIRDatabase cmdlet. Specify the DatabaseName parameter value. Save the result to the $IRDatabase variable.
  5. Run the Set-VEORIRDatabase cmdlet. Specify the following options:
  • Set the $IRDatabase as the Database parameter value.
  • Specify the $ScheduledSwitch as the SwitchOverOptions parameter value.

Related Commands