Graceful Switchover can be used with Oracle RAC and works identical to graceful switchover with single instance databases. However the following applies:
1. Graceful Switchover can only occur between ONE primary node and the standby server. The instance on the other primary node(s) will be automatically shutdown during graceful switchover.
For example: With the following configurations:
| Primary | Standby |
|---|---|
| ServerA – RAC instance | ServerC – Single instance standby database |
| ServerB – RAC instance |
Graceful Switchover will convert any RAC database to single instance database by setting cluster_database database parameter to FALSE. Upon completion of graceful switchover, this parameter can be set to TRUE again to convert the single instance back into a RAC database.If Graceful Switchover is started on ServerA and ServerC, then ServerA and ServerC will be reversed. The RAC instance on ServerB will be automatically shutdown and will no longer be a part of the configuration until Graceful Switchover is initiated again to bring the configuration back to the original configuration.
- The switchover process may take longer with a RAC and ASM database than with a regular file system database. The reason for this is the extra time taken to extract Oracle files out of ASM.
- If the standby database uses multiple nodes RAC configuration, all standby instances except for the one that is involved in Graceful Switchover, should be manually shut down prior to proceeding with switchover.
Graceful Switchover with RAC example
With the following configuration:
| Primary | Standby |
|---|---|
| ServerA – RAC instance dbvrac1 | ServerC – Single instance standby database dbvrac |
| ServerB – RAC instance dbvrac2 |
Graceful Switchover is initiated on both ServerA and ServerC with command:
dbv_oraStartStop switchover dbvrac1
The following will occur:
1. RAC database dbvrac2 on ServerB will be shutdown.
2. RAC database dbvrac1 will be converted to a single instance standby database.
3. Single instance standby database on ServerC will be converted to a single instance primary database with 2 threads:
| Standby | Primary |
|---|---|
| ServerA – Single instance standby database dbvrac1 | ServerC – Single instance primary database dbvrac |
| ServerB – RAC instance shutdown |
If Graceful Switchover is initiated again to bring it back to the original configuration the following will occur:
1. Single instance standby database dbvrac1 on ServerA will be converted to a single instance primary database with 2 threads.
2. Single instance primary database dbvracon ServerC will be converted to a single instance standby database with 2 threads:
| Primary | Standby |
|---|---|
| ServerA – Single instance primary database dbvrac1 | ServerC – Single instance standby database dbvrac |
| ServerB – RAC instance shutdown |
To convert from a single instance primary database back to a RAC database:
1. On ServerA, set database parameter cluster_database=TRUE in database dbvrac1.
2. Restart instance dbvrac1 on ServerA.
3. Start dbvrac2 instance on ServerB.
4. Dbvisit Standby can be initiated again as normal on ServerA and ServerC:
dbvisit dbvrac1
5. On other nodes that were not part of the graceful switchover (in this case ServerB), Dbvisit Standby must be resynchronised with the standby database by running command:
dbvisit -R dbvrac2
The command only needs to run once. After this command, Dbvisit Standby can be run as normal:
dbvisit dbvrac2