oracledba.help

<- DataGuard

Prerequisites

  1. OS Baseline Set
  2. Database Baseline Set (12c\19c)
  3. Required Directories Created on SB
  4. ORACLE_SID Set
  5. Ensure the Oracle Patches are Up-to-Date
  1. OS Baseline
    • Ensure OS kernels are the same on Primary and SB systems. OS> uname -a
    • Ensure OS Prepped for Oracle 🠊
  2. Database Baseline
    • If RAC or Oracle-Restart used the GI has been installed. 🠊
    • Primary and SB have same version of Oracle database product installed. 🠊
    • Primary has a fully operational Oracle database.
    • Primary has LOG_MODE set to ARCHIVELOG.
      SQLPlus> SELECT log_mode FROM v$database;
  3. Required Directories Created on SB: OMF | ASM
  4. Ensure the Oracle Patches are Up-to-Date on both Primary and SB. 🠊
  5. Ensure the oracle user's .bashrc has the ORACLE_SID set. 
System   ORACLE_SID            Comments
-------  -------------------   -------------------------------------------------------
Primary  ORACLE_SID=oradb      db_name or instance name if RAC (oradb1, oradb2 etc.)
Standby  ORACLE_SID=oradb_sb   db_unique_name