1.Standby database process status: You can run following query on standby database to see what MRP and RFS processes are doing, which block of which archivelog sequences are being shipped or being applied.
创新互联建站专注于崆峒网站建设服务及定制，我们拥有丰富的企业做网站经验。 热诚为您提供崆峒营销型网站建设，崆峒网站制作、崆峒网页设计、崆峒网站官网定制、
成都微信小程序服务，打造崆峒网络公司原创品牌,更为您提供
崆峒网站排名全网营销落地服务。
SQL> select process, status, thread#, sequence#, block#, blocks from v$managed_standby ;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ------------ ---------- ---------- ---------- ----------
ARCH CLOSING1 301 75776 1432
ARCH CLOSING1 299 77824 1825
ARCH CONNECTED0 0 0 0
ARCH CLOSING1 300 75776 1422
RFS IDLE0 0 0 0
RFS IDLE0 0 0 0
RFS IDLE1 302 72377 1
MRP0 WAIT_FOR_LOG1 302 0 0
8 rows selected.
2.Last applied log: Run this query on the standby database to see the last applied archivelog sequence number for each thread.
SQL> SELECT thread#, max(SEQUENCE#) FROM V$ARCHIVED_LOG where APPLIED='YES' group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 301
3.Archivelog difference: Run this on primary database. (not for real time apply)
SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL> SELECT a.thread#, b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-a.applied_seq ARC_DIFF FROM (SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time) last_app_timestamp FROM gv$archived_log WHERE applied = 'YES' GROUP BY thread#) a, (SELECT thread#, MAX (sequence#) last_seq FROM gv$archived_log GROUP BY thread#) b WHERE a.thread# = b.thread#;
THREAD# LAST_SEQ APPLIED_SEQ LAST_APP_TIMESTAMP ARC_DIFF
---------- ---------- ----------- -------------------- ----------
1 301 301 08-OCT-2015 01:06:460
4.Apply/transport lags: v$dataguard_stats view will show the general synchronization status of standby database.
SQL> select * from v$dataguard_stats;
NAME VALUE UNIT TIME_COMPUTED DATUM_TIME
------------------------- -------------------- ------------------------------ ------------------------------ ------------------------------
transport lag +00 00:00:00 day(2) to second(0) interval 10/08/2015 09:21:40 10/08/2015 09:21:39
apply lag +00 08:14:59 day(2) to second(0) interval 10/08/2015 09:21:40 10/08/2015 09:21:39
apply finish time +00 00:00:02.091 day(2) to second(3) interval 10/08/2015 09:21:40
estimated startup time 19 second 10/08/2015 09:21:40
5.
SQL> select * from v$recovery_progress;
START_TIM TYPE ITEM UNITSSOFARTOTAL TIMESTAMP COMMENTS
--------- ------------------------------ ------------------------- --------------- ---------- ------- --------- --------------------
23-SEP-15 Media Recovery Log Files Files 229 0
23-SEP-15 Media Recovery Active Apply Rate KB/sec16045 0
23-SEP-15 Media Recovery Average Apply Rate KB/sec 6 0
23-SEP-15 Media Recovery Maximum Apply Rate KB/sec17761 0
23-SEP-15 Media Recovery Redo Applied Megabytes 7891 0
23-SEP-15 Media Recovery Last Applied Redo SCN+Time 0 0 08-OCT-15 SCN: 3957818
23-SEP-15 Media Recovery Active Time Seconds 871 0
23-SEP-15 Media Recovery Apply Time per Log Seconds 3 0
23-SEP-15 Media Recovery Checkpoint Time per Log Seconds 0 0
23-SEP-15 Media Recovery Elapsed Time Seconds 1248075 0
23-SEP-15 Media Recovery Standby Apply Lag Seconds14784 0
11 rows selected.
另外有需要云服务器可以了解下创新互联scvps.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
本文题目：DG相关查询-创新互联
当前路径：
http://cdkjz.cn/article/dchgoj.html
