...
| Server | Checkpoint | Rollback or roll forward actionRollforward 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; |
...