How to Configure Active Dataguard using SQL*Plus

Prerequisites:-

Need to Setup Dataguard  -  CLICK HERE



1) Connect Standby Database using SQL*Plus

$ sqlplus / as sysdba

2) Verify Standby Database Mode

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

NAME      DB_UNIQUE_NAME                 OPEN_MODE
--------- ------------------------------ --------------------
DGT01     dgt01_stdby                    MOUNTED

3) Stop MRP Process

SQL> alter database recover managed standby database cancel;

Database altered.

4) Open Standby database on Read Only Mode

SQL> alter database open read only;

Database altered.

5) Enable MRP process

SQL> Alter database recover managed standby database using current logfile disconnect;

6) Verify Standby Database Mode

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

NAME      DB_UNIQUE_NAME                 OPEN_MODE
--------- ------------------------------ --------------------
DGT01     dgt01_stdby                    READ ONLY