{"id":14864,"date":"2020-01-28T12:10:58","date_gmt":"2020-01-28T12:10:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=14864"},"modified":"2020-01-30T08:41:51","modified_gmt":"2020-01-30T08:41:51","slug":"oracle-data-guard-recovery-mode","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/","title":{"rendered":"Oracle Data Guard Recovery Mode"},"content":{"rendered":"

Check Data Guard Recovery Mode<\/h3>\n

You can find database_mode, recovery mode and protection mode of your Data Guard as follows.<\/p>\n

SQL> select DATABASE_MODE, RECOVERY_MODE, PROTECTION_MODE from v$archive_dest_status;\n\nDATABASE_MODE   RECOVERY_MODE           PROTECTION_MODE\n--------------- ----------------------- --------------------\nMOUNTED-STANDBY MANAGED                 MAXIMUM PERFORMANCE\n<\/pre>\n
Data Guard Recovery Modes<\/h3>\n
\n\n\n\n\n\n\n\n
IDLE<\/td>\nShows that Recovery is not enabled.<\/td>\n<\/tr>\n
MANAGED<\/td>\nShows that ARCHIVED Recovery is enabled.<\/td>\n<\/tr>\n
MANAGED REAL TIME APPLY<\/td>\nShows that Real-Time Recovery is enabled.<\/td>\n<\/tr>\n
LOGICAL REAL TIME APPLY<\/td>\nShows that Real-Time Recovery is enabled in Logical Standby.<\/td>\n<\/tr>\n
LOGICAL APPLY<\/td>\nShows that ARCHIVED Recovery is enabled in Logical Standby.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SQL> desc v$archive_dest_status\n Name                                      Null?    Type\n ----------------------------------------- -------- ----------------------------\n DEST_ID                                            NUMBER\n DEST_NAME                                          VARCHAR2(256)\n STATUS                                             VARCHAR2(9)\n TYPE                                               VARCHAR2(14)\n DATABASE_MODE                                      VARCHAR2(15)\n RECOVERY_MODE                                      VARCHAR2(23)\n PROTECTION_MODE                                    VARCHAR2(20)\n DESTINATION                                        VARCHAR2(256)\n STANDBY_LOGFILE_COUNT                              NUMBER\n STANDBY_LOGFILE_ACTIVE                             NUMBER\n ARCHIVED_THREAD#                                   NUMBER\n ARCHIVED_SEQ#                                      NUMBER\n APPLIED_THREAD#                                    NUMBER\n APPLIED_SEQ#                                       NUMBER\n ERROR                                              VARCHAR2(256)\n SRL                                                VARCHAR2(3)\n DB_UNIQUE_NAME                                     VARCHAR2(30)\n SYNCHRONIZATION_STATUS                             VARCHAR2(22)\n SYNCHRONIZED                                       VARCHAR2(3)\n GAP_STATUS                                         VARCHAR2(24)\n<\/pre>\n<\/div>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Check Data Guard Recovery Mode You can find database_mode, recovery mode and protection mode of your Data Guard as follows. SQL> select DATABASE_MODE, RECOVERY_MODE, PROTECTION_MODE from v$archive_dest_status; DATABASE_MODE RECOVERY_MODE PROTECTION_MODE ————— ———————– ——————– MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE Data Guard Recovery Modes IDLE Shows that Recovery is not enabled. MANAGED Shows that ARCHIVED Recovery is enabled. …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":484,"featured_media":14866,"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,"footnotes":""},"categories":[4],"tags":[8103,8108,8107,8105,8106,8109,8110,8111,8112,8104],"class_list":["post-14864","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-data-guard-recovery-mode-idle","tag-data-guard-recovery-mode-logical-apply","tag-data-guard-recovery-mode-logical-real-time-apply","tag-data-guard-recovery-mode-managed","tag-data-guard-recovery-mode-managed-real-time-apply","tag-data-guard-recovery-modes","tag-logical-apply","tag-logical-real-time-apply","tag-managed-real-time-apply","tag-oracle-data-guard-recovery-mode-idle"],"aioseo_notices":[],"yoast_head":"\nOracle Data Guard Recovery Mode - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Check Data Guard Recovery Mode\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Guard Recovery Mode - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Check Data Guard Recovery Mode\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-28T12:10:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-30T08:41:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png\" \/>\n\t<meta property=\"og:image:width\" content=\"580\" \/>\n\t<meta property=\"og:image:height\" content=\"301\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Oracle Data Guard Recovery Mode\",\"datePublished\":\"2020-01-28T12:10:58+00:00\",\"dateModified\":\"2020-01-30T08:41:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\"},\"wordCount\":78,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png\",\"keywords\":[\"data guard recovery mode idle\",\"data guard recovery mode logical apply\",\"data guard recovery mode logical real time apply\",\"data guard recovery mode managed\",\"data guard recovery mode managed real time apply\",\"Data Guard Recovery Modes\",\"LOGICAL APPLY\",\"LOGICAL REAL TIME APPLY\",\"MANAGED REAL TIME APPLY\",\"oracle data guard recovery mode idle\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\",\"name\":\"Oracle Data Guard Recovery Mode - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png\",\"datePublished\":\"2020-01-28T12:10:58+00:00\",\"dateModified\":\"2020-01-30T08:41:51+00:00\",\"description\":\"Check Data Guard Recovery Mode\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png\",\"width\":580,\"height\":301},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Guard Recovery Mode\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Data Guard Recovery Mode - Database Tutorials","description":"Check Data Guard Recovery Mode","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Data Guard Recovery Mode - Database Tutorials","og_description":"Check Data Guard Recovery Mode","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-28T12:10:58+00:00","article_modified_time":"2020-01-30T08:41:51+00:00","og_image":[{"width":580,"height":301,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Oracle Data Guard Recovery Mode","datePublished":"2020-01-28T12:10:58+00:00","dateModified":"2020-01-30T08:41:51+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/"},"wordCount":78,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png","keywords":["data guard recovery mode idle","data guard recovery mode logical apply","data guard recovery mode logical real time apply","data guard recovery mode managed","data guard recovery mode managed real time apply","Data Guard Recovery Modes","LOGICAL APPLY","LOGICAL REAL TIME APPLY","MANAGED REAL TIME APPLY","oracle data guard recovery mode idle"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/","name":"Oracle Data Guard Recovery Mode - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png","datePublished":"2020-01-28T12:10:58+00:00","dateModified":"2020-01-30T08:41:51+00:00","description":"Check Data Guard Recovery Mode","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-19.png","width":580,"height":301},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/28\/oracle-data-guard-recovery-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Guard Recovery Mode"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14864"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14866"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}