{"id":6162,"date":"2018-03-02T08:55:42","date_gmt":"2018-03-02T08:55:42","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6162"},"modified":"2019-11-25T08:45:17","modified_gmt":"2019-11-25T08:45:17","slug":"oracle-dataguard-monitoring-scripts-1","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-dataguard-monitoring-scripts-1\/","title":{"rendered":"Oracle Dataguard Monitoring Scripts -1"},"content":{"rendered":"<p>Hi,<\/p>\n<p>You should always monitor dataguard status if it is running or not syncronized or not. I will share with you the most used dataguard or standby monitor scripts.<\/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>If you don&#8217;t know What is Oracle dataguard or want to know more detail, you can read following article.<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"i5m1noloAM\"><p><a href=\"https:\/\/ittutorial.org\/oracle-dataguard-installation-rman-duplicate-step-by-step-2\/\">Oracle DataGuard Step by Step Installation with RMAN Duplicate Method -2<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle DataGuard Step by Step Installation with RMAN Duplicate Method -2&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-dataguard-installation-rman-duplicate-step-by-step-2\/embed\/#?secret=k2DoZKt88m#?secret=i5m1noloAM\" data-secret=\"i5m1noloAM\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>If you want to learn which of database is Standby and which of database is Primary, you can execute below query.<\/p>\n<p>&nbsp;<\/p>\n<pre>SELECT database_role, open_mode FROM v$database;<\/pre>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>You can display the status of background processes in a standby database with below script.<\/p>\n<pre>select process, client_process,thread#,sequence#,status from v$managed_standby;<\/pre>\n<p>&nbsp;<\/p>\n<p>You can just want to see MRP process status then you can execute below script.<\/p>\n<pre>select process, client_process,thread#,sequence#,status from v$managed_standby where process like '%MRP%';<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\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-2\/<\/p>\n<p>https:\/\/ittutorial.org\/2019\/03\/17\/oracle-dataguard-monitoring-scripts-4\/<\/p>\n<p>https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-3\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;&nbsp;<\/p>\n<h5><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/\">https:\/\/ittutorial.org\/oracle-database-19c-tutorials-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, You should always monitor dataguard status if it is running or not syncronized or not. I will share with you the most used dataguard or standby monitor scripts.<\/p>\n","protected":false},"author":1,"featured_media":3529,"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,2143,2142,2113],"class_list":["post-6162","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-vdatabase","tag-oracle-vmanaged_standby","tag-useful-oracle-scripts"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2014\/01\/dataguard4.gif","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6162","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=6162"}],"version-history":[{"count":6,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6162\/revisions"}],"predecessor-version":[{"id":12729,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6162\/revisions\/12729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3529"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}