When an error occurs during Graceful Switchover on either the primary or the standby server, processing will stop on both the primary and standby servers. Dbvisit Standby will display the rollback or roll forward action required depending at which checkpoint the processing stopped, but they are also listed below for reference. Only the action associated with the checkpoint needs to be performed, not the actions for the subsequent checkpoints.For example:If Graceful Switchover failed at checkpoint 8 on the primary and standby server, then only the checkpoint action for checkpoint 8 needs to be performed on both the primary and the standby server.
| Server | Checkpoint | Rollback or roll forward action |
|---|---|---|
| Primary | 1 | Database is still primary database. No rollback needs to be performed. Primary database is not affected. |
| Standby | 1 | Database is still standby database. No rollback needs to be performed. Standby database is not affected. |
| Primary | 2 | Database is still primary database. No rollback needs to be performed. Primary database is not affected. |
| Standby | 2 | Database is still standby database. No rollback needs to be performed. Standby database is not affected. |
| Primary | 3 | Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode: |
dbv_oraStartStop restart <DDC> | ||
| Standby | 3 | Database is still standby database. No rollback needs to be performed. Standby database is not affected. |
| Primary | 4 | Database is still primary database. Primary database is in restricted mode. Rollback action: Please restart primary database in normal mode: |
dbv_oraStartStop restart <DDC> | ||
| Standby | 4 | Database is still standby database. Standby database has been shutdown or started NOMOUNT. |
| Rollback action: Please restart standby database: | ||
dbv_oraStartStop restart <DDC> | ||
| Primary | 5 | Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode: |
dbv_oraStartStop restart <DDC> | ||
| Standby | 5 | Database is still standby database. Standby database has been shutdown or started NOMOUNT. |
| Rollback action: Please restart standby database: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 6 | Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode: |
dbv_oraStartStop restart <DDC> | ||
| Standby | 6 | Database is still standby database. Standby database has been shutdown or started NOMOUNT. |
| Rollback action: Please restart standby database: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 7 | Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode: |
dbv_oraStartStop restart <DDC> | ||
| Standby | 7 | Database is still standby database. Standby database has been shutdown or started NOMOUNT. |
| Rollback action: Please restart standby database: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 8 | Database is still primary database. Primary database is not open. |
| Rollback action: Please restart primary database in normal mode: | ||
dbv_oraStartStop restart <DDC> | ||
| Standby | 8 | Database is still standby database. Convertion of Database <ORACLE_SID> has to the Primary Database has not been completed. This database has to be rolled back to a standby database. |
| Rollback action: | ||
| 1) Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command: | ||
RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’; | ||
| 3) Retart standby database with command: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 9 | Database is still primary database. Primary database is not open. |
| Rollback action: Please start primary database: | ||
dbv_oraStartStop start <DDC> | ||
| Alternatively this database may be rolled forward to a standby database. | ||
| Roll forward action: | ||
| 1. Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2. Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command: | ||
RESTORE STANDBY CONTROLFILE FROM <filename> | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Start standby database with command: | ||
dbv_oraStartStop start <DDC> | ||
| Standby | 9 | Database has been converted to the primary database. |
| Roll forward action: | ||
1. SQL> recover database; | ||
2. SQL> alter system archive log all; | ||
3. SQL> alter database open; | ||
| 4. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 5. Drop and recreate database tempfile [location of tempfile script will be shown] if needed. | ||
| Alternatively this database may be rolled back to a standby database. | ||
| Rollback action: | ||
| 1) Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command: | ||
RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’; | ||
| 3) Retart standby database with command: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 10 | Database is still primary database. Primary database is not open. |
| Rollback action: Please start primary database: | ||
dbv_oraStartStop start <DDC> | ||
| Alternatively this database may be rolled forward to a standby database. | ||
| Roll forward action: | ||
| 1. Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2. Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command: | ||
RESTORE STANDBY CONTROLFILE FROM <filename> | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Start standby database with command: | ||
dbv_oraStartStop start <DDC> | ||
| Standby | 10 | Database has been converted to the primary database. |
| Roll forward action: | ||
1. SQL> alter system archive log all; | ||
2. SQL> alter database open; | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Drop and recreate database tempfile [location of tempfile script will be shown] if needed. | ||
| Alternatively this database may be rolled back to a standby database. | ||
| Rollback action: | ||
| 1) Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command: | ||
RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’; | ||
| 3) Retart standby database with command: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 11 | Database is still primary database. Primary database is not open. |
| Rollback action: Please start primary database: | ||
dbv_oraStartStop start <DDC> | ||
| Alternatively this database may be rolled forward to a standby database. | ||
| Roll forward action: | ||
| 1. Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2. Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command: | ||
RESTORE STANDBY CONTROLFILE FROM <filename> | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Start standby database with command: | ||
dbv_oraStartStop start <DDC> | ||
| Standby | 11 | Database has been converted to the primary database. |
| Roll forward action: | ||
1. SQL> alter system archive log all; | ||
2. SQL> alter database open; | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Drop and recreate database tempfile [location of tempfile script will be shown] if needed. | ||
| Alternatively this database may be rolled back to a standby database. | ||
| Rollback action: | ||
| 1) Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command: | ||
RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’; | ||
| 3) Retart standby database with command: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 12 | Database is still primary database. Primary database is not open. |
| Rollback action: Please start primary database: | ||
dbv_oraStartStop start <DDC> | ||
| Alternatively this database may be rolled forward to a standby database. | ||
| Roll forward action: | ||
| 1. Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2. Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command: | ||
RESTORE STANDBY CONTROLFILE FROM <filename> | ||
| 3. Update DDC file dbv_<DDC>.env and reverse settings with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 4. Start standby database with command: | ||
dbv_oraStartStop start <DDC> | ||
| Standby | 12 | Database has been converted to the primary database. |
| Roll forward action: | ||
| 1. Update DDC file dbv_<DDC>.env with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 2. Add database tempfile [location of tempfile script will be shown] if needed. | ||
| 3. Archives may need to be compressed/uncompressed (not essential). | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Alternatively this database may be rolled back to a standby database. | ||
| Rollback action: | ||
| 1) Shutdown database with command: | ||
dbv_oraStartStop stop <DDC> | ||
| 2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command: | ||
RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’; | ||
| 3) Retart standby database with command: | ||
dbv_oraStartStop restart <DDC> | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 13 | Database has been converted to standby database. |
| Roll forward action: | ||
| 1. Update DDC file dbv_<DDC>.env with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 2. Start standby database with command: | ||
dbv_oraStartStop start <DDC> | ||
| Standby | 13 | Database has been converted to the primary database. |
| Roll forward action: | ||
| 4. Update DDC file dbv_<DDC>.env with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 5. Add database tempfile [location of tempfile script will be shown] if needed. | ||
| 6. Archives may need to be compressed/uncompressed (not essential). | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
7. SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 14 | Database has been converted to standby database. |
| Roll forward action: | ||
| 1. Update DDC file dbv_<DDC>.env with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| Standby | 14 | Database has been converted to the primary database. |
| Roll forward action: | ||
| 1. Update DDC file dbv_<DDC>.env with command: | ||
dbv_oraStartStop update_ddc_file <DDC> | ||
| 2. Add database tempfile [location of tempfile script will be shown] if needed. | ||
| 3. Archives may need to be compressed/uncompressed (not essential). | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 15 | Database has been converted to standby database. |
| Roll forward action: | ||
| 1. Archives may need to be compressed/uncompressed (not essential). | ||
| Standby | 15 | Database has been converted to the primary database. |
| Roll forward action: | ||
| 1. Add database tempfile [location of tempfile script will be shown] if needed. | ||
| 2. Archives may need to be compressed/uncompressed (not essential). | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 16 | Database has been converted to standby database. |
| Roll forward action: | ||
| 1. Archives may need to be compressed/uncompressed (not essential). | ||
| Standby | 16 | Database has been converted to the primary database. |
| Roll forward action: | ||
| 1. Archives may need to be compressed/uncompressed (not essential). | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 17 | Database has been converted to standby database. |
| Roll forward action: | ||
| No further roll forward action required. | ||
| Standby | 17 | Database has been converted to the primary database. |
| Roll forward action: | ||
| No further roll forward action required. | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; | ||
| Primary | 18 | Database has been converted to standby database. |
| Roll forward action: | ||
| No further roll forward action required. | ||
| Standby | 18 | Database has been converted to the primary database. |
| Roll forward action: | ||
| No further roll forward action required. | ||
| Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command: | ||
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both; |
1. The above steps are indicative only and may vary from version to version.
2. For Oracle 8. "SQL>" should be "SVRMGR>"
3. If using Dbvisit Standby to keep the new standby database in synch, please run Dbvisit Standby once manually with the -R option to synchronise on the new primary database.
Example: dbvisit -R <DDC>