![\"\"](\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/dataguard.gif\")
<\/p>\nHi,<\/p>\n
You should always monitor dataguard status if it is running or not syncronized or not.<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n\n
<\/p>\n
You can read other Oracle Dataguard monitoring scripts like following.<\/p>\n
<\/p>\n
https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-1\/<\/p>\n
https:\/\/ittutorial.org\/2019\/03\/17\/oracle-dataguard-monitoring-scripts-4\/<\/p>\n
https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-3\/<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
Your dataguard is running but is there any lag ? You can learn below script.<\/p>\n
set lines 1000\r\nselect name,value from v$dataguard_stats;<\/pre>\n<\/p>\n
If you want to know which archive sequence number comes from the Primary database lastly and which is last applied in Standby, you can learn the following script.<\/p>\n
SELECT ARCH.THREAD# \"Thread\", ARCH.SEQUENCE# \"Last in Sequence\", APPL.SEQUENCE# \"Last Applied Sequence\", (ARCH.SEQUENCE# - APPL.SEQUENCE#) \"Difference\"\r\nFROM\r\n(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,\r\n(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\r\nWHERE\r\nARCH.THREAD# = APPL.THREAD#\r\nORDER BY 1;<\/pre>\n<\/p>\n\n
<\/p>\n
What is the MRP process waiting for status ? You can check with below script.<\/p>\n
select a.event, a.wait_time, a.seconds_in_wait from gv$session_wait a, gv$session b where a.sid=b.sid and \r\nb.sid=(select SID from v$session where PADDR=(select PADDR from v$bgprocess where NAME='MRP0'));<\/pre>\n<\/p>\n\n
<\/p>\n
<\/p>\n
Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h5>\n