Steps to keep the standby database in read only mode

Steps to keep the standby database in read only mode

1, Cancel the recovery

alter database recover managed standby database cancel;

2. Start the database in read only mode

alter database open read only;

3. Keep the database is in recovery mode.

alter database recover managed standby database USING CURRENT LOGFILE disconnect from session;

4. Check for MRP is started

ps -ef|grep mrp

SELECT PROCESS,   STATUS, THREAD#,  SEQUENCE#,    BLOCK#,   BLOCKS, DELAY_MINS from v$managed_standby;

5. Make sure the standby is sync with Primary

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received",APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" 

FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME) IN (SELECT THREAD#,MAX(FIRST_TIME)

FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN

(SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL 

WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;