Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
dbv_oraStartStop switchover <DDC> [unique_key]
This command must be issued on both the primary and the standby server.

Image ModifiedHome > 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.

Image ModifiedHome > 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.

...

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
 dbv_oraStartStop status dbvisitp 
=============================================================
Dbvisit Standby Database Technology
dbv_oraStartStop started on dbvisit31
=============================================================
Standby Database dbvisitp on dbvisit31 is up.
=============================================================
dbv_oraStartStop ended on dbvisit31
=============================================================
Where dbvisitp is the name of the database, dbvisit31 is the primary server, dbvisit32 is the standby server.

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:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
dbv_oraStartStop switchover dbvisitp 6678
Where dbvisitp is the name of the database, dbvisit31 is the primary server, dbvisit32 is the standby server.

2. On the standbyserver:

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
dbv_oraStartStop switchover dbvisitp 6678
Where dbvisitp is the name of the database, dbvisit31 is the primary server, dbvisit32 is the standby server.