Performing a Graceful Switchover

Owned by Jaimes Booth (Unlicensed)
Last updated: Dec 19, 2013
1 min read

One of the key options provided by Dbvisit Standby is the option to perform a Graceful Switchover (GS). This process should be executed in a controlled manner with both primary and standby databases functional and up to date. When performing a GS there is no data loss as this is done in a controlled manner. The GS commands should be executed on both the primary and standby server, and a unique number is specified as an additional check. This number does not get used for anything else. The command used to start the GS process is:

./dbv_oraStartStop switchover <DDC> <UniqueNumber>

This command can be executed in any order, but is normally first on the primary then the standby, for example:

Primary:

oracle@dbvlin501[/usr/dbvisit/standby]: ./dbv_oraStartStop proddb 123

 

Standby:

oracle@dbvlin502[/usr/dbvisit/standby]: ./dbv_oraStartStop proddb 123

 

The output of these commands are long, and only the commands themselves are shown in this section. The GS process can take a number of minutes depending on the size and amount of redo logs.

Â