switchover
Vijayganesh Sivaprakasam
Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read
Loading data...
dbvcli switchover {-d|--name} CONFIGURATION_NAME [--OPTIONS]Swap the roles of the primary and standby databases
Option | Type | Description |
|---|
Option | Type | Description |
|---|---|---|
| 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