Oracle 11.2.0.2 Active Standby Database Startup/Shutdown/Status Monitoring

Following scripts are executed on standby Node

Shutdown

SQLPLUS / AS SYSDBA

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SHUTDOWN IMMEDIATE

EXIT

Startup

SQLPLUS / AS SYSDBA

STARTUP MOUNT;

ALTER DATABASE OPEN READ ONLY;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Status

SELECT  PROCESS, STATUS,SEQUENCE#,BLOCK#,BLOCKS, DELAY_MINS FROM V$MANAGED_STANDBY

Archive Log Difference

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

--SOME TIME ITS NOT THE ACTUAL DIFFERENCE SO CHECK DIRECTLY FROM --PRODUCTION WHICH IS THE LATEST ARCHIVE LOG

Max Sequence Number on Primary Site

SELECT MAX(SEQUENCE#) LOG_ARCHIVED FROM V$ARCHIVED_LOG@FROM_PROD

--HERE FROM_PROD IS DATABASE LINK TO PRIMARY SITE.