Dataguard 維護操作-01-- MRP process
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DataGuard 日常維護命令整理
- dataguard 常規運維操作運維
- Dataguard日常維護及故障解決
- dataguard環境中的密碼維護密碼
- AIX常用維護操作AI
- Oracle DataGuard 常用維護命令參考手冊Oracle
- 9I DATAGUARD實施和維護總結
- redo logfile的維護操作
- dataguard系列之六------備用資料庫的維護資料庫
- ORACLE 9I DATAGUARD實施和維護總結Oracle
- 9I DATAGUARD原理,實施和維護總結
- Mysql optimize、Analyze、check、repair維護操作MySqlAI
- Logical Standby的維護操作_SKIP
- 【Dataguard】DataGuard運維注意事項運維
- Oracle DataGuard 常用維護命令參考手冊 [轉載記錄]Oracle
- 資料庫維護常用操作命令1-表操作資料庫
- Oracle RAC系列之:ASM基本操作維護OracleASM
- oracle dg 維護常用操作和調優Oracle
- Oracle data guard常用維護操作命令(轉)Oracle
- 物理DATAGUARD庫上的KSVCREATE: PROCESS(M000)
- 【DataGuard】Oracle DataGuard 資料保護模式切換Oracle模式
- 資料庫維護常用操作4--表空間操作資料庫
- DATAGUARD、broker安裝維護檔案(個人筆記比較齊全)筆記
- dataguard中MRP無法啟動的問題分析和解決
- opensuse linux操作維護學習筆記Linux筆記
- Oracle 11gR2 RAC 常用維護操作Oracle
- DataGuard 日常操作-02
- dataguard三種保護模式模式
- DataGuard切換保護模式模式
- Oracle11g RAC常用操作 (維護及管理)Oracle
- Oracle RAC系列之:ASM基本操作維護(經典)OracleASM
- Oracle 10g RAC 常用維護操作 說明Oracle 10g
- 【DataGuard】Oracle Dataguard三種保護模式特點總結Oracle模式
- set an MRP type for MRP in the material master (MRP 1 view).ASTView
- 資料庫維護常用操作命令1--約束資料庫
- 資料庫維護常用操作命令2--約束資料庫
- Oracle 11gR2 RAC 常用維護操作 說明Oracle
- 操作 WebSphere Process Server 環境概述WebServer