Set-VEORIRDatabase
Short Description
Changes switchover settings of an instant recovery session for an Oracle database.
Applies to
Veeam Backup & Replication
Product Edition: Enterprise, Enterprise Plus, Veeam Universal License
Syntax
Set-VEORIRDatabase [-Database] <VEORIRDatabase> [-SwitchOverOptions <VEORIRSchedule>] [<CommonParameters>] |
Detailed Description
This cmdlet allows you to change the switchover option for a specified Oracle database.
|
You can only modify the switchover settings until the moment switchover is automatically triggered (if the Auto or Scheduled switchover options are selected). |
Parameters
Parameter | Description | Type | Required | Position | Accept Pipeline Input |
|---|---|---|---|---|---|
Database | Specifies an Oracle database published 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 CommonParameters section of Microsoft Docs.
Example
Setting Scheduled Switchover of Oracle Database
This example shows how to set the scheduled switchover for the orcl database. The cmdlet will perform the switchover at 13:00:00 on 2023-11-24.
$time = Get-Date -Date "2023-12-4 13:00:00" $TimeUtc = $time.ToUniversalTime() $ScheduledSwitch = New-VEORIRSwitchOverOptions -Scheduled -SwitchingTimeUtc $TimeUtc $IRDatabase = Get-VEORIRDatabase -DatabaseName "orcl" Set-VEORIRDatabase -Database $IRDatabase -SwitchOverOptions $ScheduledSwitch |
Perform the following steps:
- Run the Get-Date cmdlet and specify the date and time when the switchover must be performed. Save the result to the $time variable.
- Use the ToUniversalTime() method to convert the date and time to the UTC format.
- Run the New-VEORIRSwitchOverOptions cmdlet. Provide the Scheduled parameter. Set the $TimeUtc variable as the SwitchingTimeUtc parameter value. Save the result to the $ScheduledSwitch variable.
- Run the Get-VEORIRDatabase cmdlet. Specify the DatabaseName parameter value. Save the result to the $IRDatabase variable.
- Run the Set-VEORIRDatabase cmdlet. Specify the following options:
- Set the $IRDatabase variable as the Database parameter value.
- Specify the $ScheduledSwitch variable as the SwitchOverOptions parameter value.
Related Commands