Starting Graceful Switchover
The Graceful Switchover procedure must be activated on both the primary and the standby server.
Transition overview:
[Primary server] primary database > standby database
[Standby server] standby database > primary database
The command to initiate Graceful Switchover is:
Home > Run > Run Interactive > Primary Server tab > select Database from drop-down menu > select Graceful Switchover from Run Action drop-down menu > Run
Enter a unique key such as 4456, this must be the same key as entered on the standby tab.
Home > Run > Run Interactive > Standby Server tab > select Database from drop-down menu > select Graceful Switchover from Run Action drop-down menu > Run
Enter a unique key such as 4456, this must be the same key as entered on the primary tab.
The rest of the examples show command line interface (CLI), however the output is identical to the web-based (GUI) version.
Example:
Note that both the primary and the standby database will be shutdown and restarted during the switchover.
1. On the primary server start the Graceful Switchover procedure.
2. On the standby server start the Graceful Switchover procedure.Where dbvisitp is the name of the database
3. Enter a unique key on the primary server. This unique key can be any number that has not previously been used for Graceful Switchover. Dbvisit Standby will notify if a previously used key is used.
4. Enter the same unique key on the standbyserver. This ensures that both processes are linked to each other.
The switchover process has now started. For more information about the messages and process during the switchover, please see the Graceful Switchover errors and recovery section below.
5. At the end of the switchover the primary database has transitioned to a standby database:
6. At the end of the switchover the standby database has transitioned to a primary database:
7. Graceful Switchoverhas been completed. The primary database is now on the standby server, and the standby database is now on the primary server.
8. To confirm that the old standby database is now the new primary database, the following command maybe run:
9. To confirm that the old primary database is now the new standby database, the following command maybe run:
Batch mode
To run the Graceful Switchover in batch mode without having to enter the unique key interactively, the unique key can be specified on the command line. The unique key can be any number that uniquely identifies the Graceful Switchover processing and that has not been used before. The same key must be used on the primary and the standby server.
To run in batch mode:
1. On the primaryserver:
2. On the standbyserver: