switchover

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read
dbvcli switchover {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Swap the roles of the primary and standby databases

Option

Type

Description

Option

Type

Description

--user-script

key=val

optional script or scripts to execute after switchover on primary or standby host (key must be primary or standby host; value must be an existing user script)

--allow-closed-pdbs

Y or N

required, allow switchover with closed PDBs (mandatory when using --no-prompt)

[oracle@nzoel19c2 bin]$ ./dbvcli -d orclcdb switchover Connecting to the Control Center at localhost:4433 ✓ Checking available actions for this configuration ✓ Configuration orclcdb (nzoel19c2.oraclekiwi.co.nz -> nzoel19c1.oraclekiwi.co.nz) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ RECOVERING │ │ ││ │ └───────────────┘└───────────────┘ Gathering information required for switchover ✓ Optional User Scripts 1/2 There are no scripts defined for host nzoel19c1.oraclekiwi.co.nz Optional User Scripts 2/2 There are no scripts defined for host nzoel19c2.oraclekiwi.co.nz Confirmation This configuration is ready for switchover. Select Yes to proceed with swapping the roles of the primary and standby databases, or No to cancel the operation. Confirm Switchover: (•) Yes ( ) No 2024-11-14 14:12:39 2024-11-14 14:12:39 Preparing for switchover 2024-11-14 14:12:39 Disabling Observer 2024-11-14 14:12:39 done 2024-11-14 14:12:39 Disabling Automated Standby Update 2024-11-14 14:12:39 done 2024-11-14 14:12:40 Starting Switchover between nzoel19c2.oraclekiwi.co.nz and nzoel19c1.oraclekiwi.co.nz 2024-11-14 14:12:40 Pre processing ... 2024-11-14 14:12:40 done 2024-11-14 14:12:40 Processing primary ... 2024-11-14 14:15:03 done 2024-11-14 14:15:03 Processing standby ... 2024-11-14 14:15:20 done 2024-11-14 14:15:20 Converting standby ... 2024-11-14 14:17:31 done 2024-11-14 14:17:31 Converting primary ... 2024-11-14 14:17:45 done 2024-11-14 14:17:45 Completing ... 2024-11-14 14:18:05 done 2024-11-14 14:18:05 Synchronizing ... 2024-11-14 14:18:15 done 2024-11-14 14:18:15 Post processing ... 2024-11-14 14:18:15 done 2024-11-14 14:18:15 Graceful switchover completed. 2024-11-14 14:18:15 Primary Database Server: nzoel19c1.oraclekiwi.co.nz 2024-11-14 14:18:15 Standby Database Server: nzoel19c2.oraclekiwi.co.nz 2024-11-14 14:18:15 Dbvisit Standby can be run as per normal: 2024-11-14 14:18:15 dbvctl -d orclcdb 2024-11-14 14:18:15 As part of the Switchover process, the primary and standby controlfiles have been exchanged. 2024-11-14 14:18:15 Unless you are using RMAN catalog database, you may need to cross-check all backups and review RMAN settings using the SHOW ALL command on the new Primary/Standby databases. Confirm the path set for the SNAPSHOT CONTROLFILE NAME TO setting is valid on both sides. 2024-11-14 14:18:15 Finishing switchover 2024-11-14 14:18:15 Switching primary and standby roles 2024-11-14 14:18:15 Primary database host is now nzoel19c1.oraclekiwi.co.nz 2024-11-14 14:18:15 Standby database host is now nzoel19c2.oraclekiwi.co.nz 2024-11-14 14:18:15 Waiting for Agents to respond to role switch 2024-11-14 14:18:15 Applying Automated Standby Update settings 2024-11-14 14:18:15 done 2024-11-14 14:18:15 Enabling Automated Standby Update 2024-11-14 14:18:15 done 2024-11-14 14:18:15 Enabling Observer 2024-11-14 14:18:15 done 2024-11-14 14:18:15 Task succeeded