oracledba.help

Data Guard

Data Guard Administration

Specs used in examples:

 Hostname  Role     DB_NAME  DB_UNIQUE_NAME  ORACLE_SID (Env Var)
 --------  -------  -------  ---------------  --------------------
 lnx01     Primary  oradb    oradb            oradb
 lnx02     Standby  oradb    oradb_sb         oradb_sb

For RAC examples lnx03 is used for the SB host while lnx01 & lnx02 are the nodes.

Common Creation Tasks

  1. Prerequisites
  2. Primary Database Changes
  3. Network Changes
  4. RMAN Backup and File Copy
  5. Standby Database Changes: OMF | ASM
  6. Configure Broker
  7. Enable Flashback Database

Common Gotchas

Can't tell you how many hours it took me to compile these! Hopefully this saves you time.

  • Because of 12.x encryption changes, copy the password file from Primary rather than recreating it on the Standby.
  • If a SYSDBA account password is changed (SYS) you have to recopy the password file to the Standby. It is not replicated.
  • Network configuration names in 12c are case sensitive:
    • Consider using: alter system set sec_case_sensitive_logon=false scope=both;
    • Consider using lower case for all listener and tnsnames.ora entries.
    • Consider creating the password file on Primary using ignorecase:
      Ex: orapwd file=$ORACLE_HOME/dbs/orapwMyDB password=mypw entries=10 force=y ignorecase=y
    • Check case and ownership of password file: $ORACLE_HOME/dbs/orapw*
  • The PROFILE for SYS\SYSDBA may need to be less restrictive.
    • Ex 1: ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    • Ex 2: ALTER PROFILE default LIMIT PASSWORD_REUSE_TIME UNLIMITED;
  • For RAC & Oracle-Restart the listener.ora static service entries must be the DATABASE ORACLE_HOME. Not GRID_HOME.
    Ex: (ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1)

If Flashback is not enabled, you will have to manually recreate your Primary as a Standby in a failover event to reinstate it.


References