How to start physical standby database in Readonly state in Active dataguard

How to start physical standby database in Readonly state in Active dataguard

Steps

1. Check the status of physical standby

select name,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------

ORCL      Mounted

Make sure the primary and standby are in sync before performing the next action plan.

2. Cancel the media recovery on Standby database: In case of RAC it should be done from node where MRP is running.

alter database recover managed standby database cancel;

3. Open the database in READONLY MODE:

Note: Database should already in Mount state. 

ALTER DATABASE OPEN READ ONLY;

4. Start media recovery with real-time log apply on Standby Database:

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

5. Verify the Standby database status:

select name,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

ORCL      READ ONLY WITH APPLY

If you like please follow and comment