How to Enable Active Dataguard In Physical Standby Database

How to Enable Active Dataguard In Physical Standby Database

In Active dataguard 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

1. Check the database status PHYSICAL STANDBY.

SQL> select name, open_mode, database_role, INSTANCE_NAME from v$database,v$instance;

NAME      OPEN_MODE            DATABASE_ROLE    INSTANCE_NAME
--------- -------------------- ---------------- ----------------
ORCLNEW   MOUNTED              PHYSICAL STANDBY ORCLNEWQ

2. Cancel the media recovery on PHYSICAL STANDBY.

SQL> alter database recover managed standby database cancel;

3. Open the database PHYSICAL STANDBY.

SQL> alter database open;

4. 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.

5. Check the database status PHYSICAL STANDBY

SQL> select name, open_mode, database_role, INSTANCE_NAME from v$database,v$instance;

NAME      OPEN_MODE            DATABASE_ROLE    INSTANCE_NAME
--------- -------------------- ---------------- ----------------
ORCLNEW   READ ONLY WITH APPLY PHYSICAL STANDBY ORCLNEWQ