{"id":6689,"date":"2019-03-17T18:30:16","date_gmt":"2019-03-17T18:30:16","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6689"},"modified":"2019-11-25T08:01:35","modified_gmt":"2019-11-25T08:01:35","slug":"oracle-dataguard-monitoring-scripts-4","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-dataguard-monitoring-scripts-4\/","title":{"rendered":"Oracle Dataguard Monitoring Scripts -4"},"content":{"rendered":"<p>Hi,<\/p>\n<p>Dataguard should be monitored everytime by Oracle DBA.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6165\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/dataguard.gif\" alt=\"\" width=\"480\" height=\"360\" \/><\/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>&nbsp;<\/p>\n<p>https:\/\/ittutorial.org\/2018\/03\/02\/oracle-dataguard-monitoring-scripts-3\/<\/p>\n<p>&nbsp;<\/p>\n<p>To see all parameters of Oracle dataguard, you can execute following query.<\/p>\n<p>&nbsp;<\/p>\n<pre>set linesize 500 pages 0\r\ncol value for a80\r\ncol name for a50\r\n\r\nselect name, value from v$parameter\r\nwhere name in ('db_name','db_unique_name','log_archive_config',    \r\n'log_archive_dest_1','log_archive_dest_2','log_archive_dest_3',\r\n               'log_archive_dest_state_1','log_archive_dest_state_2','log_archive_dest_state_3', 'remote_login_passwordfile',\r\n               'log_archive_format','log_archive_max_processes','fal_server','fal_client','db_file_name_convert',\r\n              'log_file_name_convert', 'standby_file_management') order by 1;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>To see applied archivelogs in dataguard, execute following script.<\/p>\n<pre>\u00a0select thread#,sequence#,first_time,next_time,applied from gv$archived_log where applied='YES';<\/pre>\n<p>&nbsp;<\/p>\n\n<p>Below script provides information about max sequence of dataguard<\/p>\n<pre>select thread#,max(sequence#) from gv$archived_log group by thread#;<\/pre>\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, Dataguard should be monitored everytime by Oracle DBA. &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":6165,"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-6689","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\/03\/dataguard.gif","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6689","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=6689"}],"version-history":[{"count":4,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6689\/revisions"}],"predecessor-version":[{"id":12687,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6689\/revisions\/12687"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/6165"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}