Category: Standby

Query 1: ARCHIVER can be (STOPPED | STARTED | FAILED) FAILED means that the archiver failed to archive a log last time, but will try…

Query 1: protection_level should match the protection_mode after the next log switch select name,database_role role,log_mode, protection_mode,protection_level from v$database; NAME         ROLE         LOG_MODE           PROTECTION_MODE                 PROTECTION_LEVEL TEST          PRIMARY   …

Database Switchover A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss…

Cancel/Stop Managed Standby Recovery While connected to the standby database follow following steps: ALTER DATABASE SET STANDBY DATABASE UNPROTECTED; RECOVER MANAGED STANDBY DATABASE CANCEL; ALTER…

You can use the Recovery Manager DUPLICATE TARGET DATABASE FOR STANDBY command to create a standby database. RMAN automates the following steps of the creation…

This document contains a guide on setting up standby databases for maximum protection, using command line mode, and avoiding using the GUI. To do this…

Step 1 Create a initSID.ora (Example: initTEST.ora) file in $ORACLE_HOME/dbs/ directory. Example: $ORACLE_HOME/dbs/initTEST.ora Put following entry in initTEST.ora file ############################################################## background_dump_dest=<put BDUMP log destination> core_dump_dest=<put…