Dataguard 維護操作-01-- MRP process

beatony發表於2011-11-17

Can you please give us the update as to how far we are in the DR synch process.

Also, if you could please send the status every four hours replying to all on this email, it would be greatly appreciated.

++++++++++++++++++++++++++++++++++++

1. check the alert.log on the standby database side.

2. then, check the archivelog 122539 on the Parmary database;

select SEQUENCE#, to_char(FIRST_TIME, 'YYYY-MM-DD HH24:MI:SS') FROM v$loghist where SEQUENCE# = 122530;
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

set linesize 150
col HOST_NAME for a10

SQL> select a.HOST_NAME,a.instance_name,b.open_mode,b.database_role from v$instance a, v$database b;

HOST_NAME INSTANCE_NAME DATABASE_ROLE

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

svdw3d05 O02FLX3A PHYSICAL STANDBY

SQL> alter database recover managed standby database using current logfile disconnect; [ start up the MRP process ]

Database altered.

SQL> select process,pid,client_process,thread#,sequence#,status from v$managed_standby;

PROCESS PID CLIENT_P THREAD# SEQUENCE# STATUS

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

ARCH 13131 ARCH 0 0 CONNECTED

ARCH 13221 ARCH 0 0 CONNECTED

MRP0 8966 N/A 3 129649 APPLYING_LOG

 

SQL> 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;

Thread Last Sequence Received Last Sequence Applied Difference

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

1 78180 78180 0

2 86787 86787 0

3 129652 129649 3

4 58600 58599 1

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22578826/viewspace-711525/,如需轉載,請註明出處,否則將追究法律責任。

相關文章