{"id":6170,"date":"2018-03-02T10:17:51","date_gmt":"2018-03-02T10:17:51","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6170"},"modified":"2019-07-01T14:51:30","modified_gmt":"2019-07-01T14:51:30","slug":"oracle-dataguard-monitoring-scripts-3","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-dataguard-monitoring-scripts-3\/","title":{"rendered":"Oracle Dataguard Monitoring Scripts -3"},"content":{"rendered":"<p>Hi,<\/p>\n<p>If you want to maintain Dataguard for disaster recovery you need to keep up Dataguard running state and Synchronized.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3529\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/01\/dataguard4.gif\" alt=\"\" width=\"547\" height=\"343\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>&nbsp;<\/p>\n<p>You can read other Oracle Dataguard monitoring scripts like following.<\/p>\n<p>&nbsp;<\/p>\n<p>https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-1\/<\/p>\n<p>https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-2\/<\/p>\n<p>https:\/\/ittutorial.org\/2019\/03\/17\/oracle-dataguard-monitoring-scripts-4\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>To see the status of the switchover and the role of database which is in Standby or Primary state, execute following script.<\/p>\n<pre>select switchover_status,database_role from v$database;<\/pre>\n<p>&nbsp;<\/p>\n<p>To see archive gap in dataguard, execute following script.<\/p>\n<pre>SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;<\/pre>\n<p>&nbsp;<\/p>\n\n<p>Below script provides information about approximate completion time of the recovery process<\/p>\n<pre>select to_char(start_time,'DD-MON-RR HH24:MI:SS') start_time,item,round(sofar\/1024,2) \"MB\/Sec\" from v$recovery_progress \r\nwhere (item='Active Apply Rate' or item='Average Apply Rate');<\/pre>\n<p>&nbsp;<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Hi, If you want to maintain Dataguard for disaster recovery you need to keep up Dataguard running state and Synchronized. &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":4520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5084,1994,2110],"tags":[2139,2140,1031,2141,2138,2112,2114,2099,2146,2149,2144,2143,2145,2142,2148,2113,2147],"class_list":["post-6170","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-dataguard","category-oracle","category-oracle-dba-scripts","tag-dataguard-monitoring-script","tag-dataguard-script","tag-mehmet-salih-deveci","tag-oracle-dataguard-monitoring-script","tag-oracle-dataguard-monitoring-scripts","tag-oracle-dba-scripts","tag-oracle-monitoring-scripts","tag-oracle-scripts","tag-oracle-varchived_log","tag-oracle-varchive_gap","tag-oracle-vbgprocess","tag-oracle-vdatabase","tag-oracle-vdataguard_stats","tag-oracle-vmanaged_standby","tag-oracle-vrecovery_progress","tag-useful-oracle-scripts","tag-vrecovery_progress"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/01\/active-dataguard-32-638.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6170"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6170\/revisions"}],"predecessor-version":[{"id":7754,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6170\/revisions\/7754"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/4520"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}