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.
No comments:
Post a Comment