Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time.

Below are the benefit of using active dataguard.

  • Reporting queries can be offloaded to standby database.
  • Physical block corruptions are repaired automatically either at primary or physical standby database.
  • RMAN backups can be initiated from standby , instead  of primary which will reduce cpu load from primary.
  • NOTE - To use active dataguard, you need additional license from oracle

    Let-s say we have a physical standby database which is in mount state. Implement below steps to enable active dataguard database.

     

    1. Cancel the media recovery on physical standby.

    SQL> alter database recover managed standby database cancel;
    
    

    2. Open the database[PHYSICAL STANDBY]

    SQL> alter database open;
    
    Database altered.
    

    3. Start media recovery with real-time log apply[PHYSICAL STANDBY]

    SQL> alter database recover managed standby database using current logfile disconnect from session;
    
    Database altered.
    
    

    4. Check the database status:[PHYSICAL STANDBY]

    SQL> select name,open_mode from v$database;
    
    NAME      OPEN_MODE
    --------- --------------------
    PRODDB   READ ONLY WITH APPLY
    
    
    
    SQL> select process,status,sequence# from v$managed_standby;
    
    PROCESS   STATUS        SEQUENCE#
    --------- ------------ ----------
    ARCH      CONNECTED             0
    ARCH      CONNECTED             0
    ARCH      CONNECTED             0
    ARCH      CONNECTED             0
    ARCH      CONNECTED             0
    RFS       IDLE                  0
    RFS       RECEIVING           510
    RFS       IDLE                  0
    RFS       IDLE               4178
    MRP0      APPLYING_LOG        510 --->>>>  MRP PROCESS 
    
    

    Now active dataguard has been enabled.

    dataguard DATAGUARD


    Related Topics

    Useful DGMGRL commands in oracle dataguard
    How to use expdp to export data from physical standby database
    How to enable active dataguard in physical standby database
    Standby redologs in oracle dataguard
    Flashback primary database in dataguard environment
    How to recreate physical standby controlfile
    How to disable enable log shipping in standby using dgmgrl
    How to setup dataguard broker configuration (DG broker) in 12c
    How to add a tempfile in primary database in dataguard

    You May Also Like

    OUTBOUND_DBLINK_PROTOCOLS in oracle 12.2
    orapwd tool for password file in oracle
    Shell script to monitor lag in standby datbase using dgmgrl
    How to find cpu and memory information of oracle database server
    Blackout targets in OEM 12c cloud control
    Hive installation with mysql database
    SAMPLE parameter in EXPDP to export subset of data
    PDB Lockdown Profiles in Oracle 12.2
    Apply database proactive bundle patch in RAC using manual process
    ORA-01536: space quota exceeded for tablespace

    From This Website

    Defgen utility in Oracle goldengate
    How to run expdp in pluggable database(PDB)
    Tablespace monitoring shell script
    Shell script to monitor lag in standby datbase using dgmgrl
    OGG-00665 OCI Error describe for query
    ORA-30034: Undo tablespace cannot be specified as temporary tablespace
    How to setup dataguard broker configuration (DG broker) in 12c
    sec_case_sensitive_logon parameter in oracle
    ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
    Useful flashback related commands