/
switchover  

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)

C:\Program Files\Dbvisit\standbymp\bin>dbvcli.exe -d link switchover Connecting to the Control Center at SQLDR1:4433 ✓ Checking available actions for this configuration ✓ Configuration link (SQLPROD1 -> SQLDR1) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ RESTORING │ │ ││ │ └───────────────┘└───────────────┘ Optional User Scripts 1/2 There are no scripts defined for host SQLDR1 Optional User Scripts 2/2 There are no scripts defined for host SQLPROD1 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-02 21:19:04 2024-11-02 21:19:04 Preparing for switchover 2024-11-02 21:19:04 Checking configuration settings 2024-11-02 21:19:04 Disabling Automated Standby Update 2024-11-02 21:19:04 done 2024-11-02 21:19:04 Converting primary database 2024-11-02 21:19:05 Synchronizing standby 2024-11-02 21:19:05 Sending final log backup to standby 2024-11-02 21:19:12 Deleting outdated backup file: c:\backup\3-link-l-0-48-0000000039000000365000001-0000000039000000378800001.bak 2024-11-02 21:19:05 Restoring final log backup on standby database 2024-11-02 21:19:05 Restoring log backup from file(s): c:\backup\3-link-l-0-48-0000000039000000365000001-0000000039000000378800001.bak. 2024-11-02 21:19:06 done 2024-11-02 21:19:06 Deleting outdated backup file: c:\backup\3-link-l-0-48-0000000039000000365000001-0000000039000000378800001.bak 2024-11-02 21:19:06 Applying logs received while in Standby Mode because Automated Standby Update is enabled 2024-11-02 21:19:06 Activating standby database 2024-11-02 21:19:07 Switching primary and standby roles 2024-11-02 21:19:07 Primary database host is now SQLDR1 2024-11-02 21:19:07 Standby database host is now SQLPROD1 2024-11-02 21:19:07 Waiting for Agents to respond to role switch 2024-11-02 21:19:07 Synchronizing new standby 2024-11-02 21:19:07 Creating log backup from new primary database 2024-11-02 21:19:07 Sending log backup to new standby 2024-11-02 21:19:09 Deleting outdated backup file: c:\backup\2-link-l-0-48-0000000039000000378800001-0000000039000000380200001.bak 2024-11-02 21:19:09 Restoring log backup on new standby database 2024-11-02 21:19:17 Restoring log backup from file(s): c:\backup\2-link-l-0-48-0000000039000000378800001-0000000039000000380200001.bak. 2024-11-02 21:19:17 done 2024-11-02 21:19:17 Deleting outdated backup file: c:\backup\2-link-l-0-48-0000000039000000378800001-0000000039000000380200001.bak 2024-11-02 21:19:17 Applying logs received while in Standby Mode because Automated Standby Update is enabled 2024-11-02 21:19:09 Finishing switchover 2024-11-02 21:19:09 Applying Automated Standby Update settings 2024-11-02 21:19:09 done 2024-11-02 21:19:09 Enabling Automated Standby Update 2024-11-02 21:19:09 done 2024-11-02 21:19:09 Observer was not enabled prior to task; leaving it disabled. 2024-11-02 21:19:10 SQL Server switch to read-only schedules was not enabled prior to task; leaving it disabled. 2024-11-02 21:19:10 Task succeeded

 

Related content