Convert Physical Standby to Active Dataguard

Convert Physical Standby to Active Dataguard : In this article we will discuss about How To Enable Active Dataguard In Physical Standby Database. Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time.

Benefits of using Active Dataguard :

• Absolutely the best protection for Oracle Database editions.
• Highest performance data recovery protection without compromises.
• Zero data loss data recovery protection across any distance without impacting performance.
• Comprehensive protection against planned and unplanned outages.
• 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.

Important Note : You need to take additional license from oracle for using Active Databguard.

Create Physical Standby Database Using RMAN Backup and Restore

Steps to Convert Physical Standby to Active Dataguard :

1. Cancel the media recovery on Physical Standby.
2. Open the Physical Standby Database.
3. Start media recovery with real-time log apply.
4. Check the database status.

Let’s we have a Physical Standby Database which is in mount state.

Firstly, Cancel the media recovery on Physical Standby.

SQL> select process,status,sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
DGRD      ALLOCATED             0
ARCH      CLOSING              69
DGRD      ALLOCATED             0
ARCH      CLOSING              67
ARCH      CLOSING              71
ARCH      CLOSING              70
MRP0      APPLYING_LOG         72   =====>>>>  MRP is running
RFS       IDLE                  0
RFS       IDLE                  0
RFS       IDLE                  0
RFS       IDLE                 72
RFS       IDLE                  0

12 rows selected.

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

NAME      DATABASE_ROLE    OPEN_MODE
--------- ---------------- --------------------
ORCL      PHYSICAL STANDBY MOUNTED

SQL>
SQL> alter database recover managed standby database cancel;

Database altered.

SQL>

Then, Open the Physical Standby Database :

SQL> alter database open;

Database altered.

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

NAME      DATABASE_ROLE    OPEN_MODE
--------- ---------------- --------------------
ORCL      PHYSICAL STANDBY READ ONLY

SQL>

After that, Start media recovery with real-time log apply :

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

Database altered.

SQL>

Lastly, Check the Database status :

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

NAME      DATABASE_ROLE    OPEN_MODE
--------- ---------------- --------------------
ORCL      PHYSICAL STANDBY READ ONLY WITH APPLY

SQL>
SQL> select process,status,sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
DGRD      ALLOCATED             0
ARCH      CLOSING              69
DGRD      ALLOCATED             0
ARCH      CLOSING              67
ARCH      CLOSING              71
ARCH      CLOSING              70
MRP0      APPLYING_LOG         72
RFS       IDLE                  0
RFS       IDLE                  0
RFS       IDLE                  0
RFS       IDLE                 72
RFS       IDLE                  0

12 rows selected.

SQL>

I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com.
Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You can write to mail me through : orakldba@gmail.com.