{"id":91,"date":"2006-11-26T11:35:00","date_gmt":"2006-11-26T15:35:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=91"},"modified":"2007-10-05T17:31:25","modified_gmt":"2007-10-05T21:31:25","slug":"oracle-dataguard-for-business-continuity","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/","title":{"rendered":"Oracle Dataguard for Business Continuity"},"content":{"rendered":"

<\/a>
\nToday I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware (Using AS Guard). There are two types of standby databases Physical Standby Database<\/strong> <\/em>& Logical Standby database<\/em><\/strong>. Since oracle applications currently support only physical standby database , I am going to cover only physical standby databases.<\/p>\n

Overview of Dataguard & Dataguard Broker<\/strong>
\nDataguard consist of one primary database & one or more standby database where primary & standby databases are connected by sqlnet (How to configure this check in coming posts<\/em><\/span>). These primary & standby database can be monitored by command line (sql) as well from GUI (Graphical User Interface<\/span>) Tool called as Dataguard broker.<\/p>\n

Important Services in Dataguard configuration<\/strong>
\nTwo very important services in dataguard configuration are Redo Transport Service<\/strong> & Log Apply Services<\/strong>. In order to keep standby database in synch with primary database ; redo transport service<\/strong><\/em> transfer(Pull\/Push<\/span>) redo logs from primary to standby database & Log apply service<\/strong><\/em> applies that redo logs to standby database.<\/p>\n

Switchover & Failover<\/strong>
\nThese are basically two kind of roles in dataguard Failover<\/strong> & Switchover; <\/strong>In <\/strong>Switchover <\/em>Primary database becomes standby database & one of (If there are more than one standby) <\/span>standby database becomes primary database for ex. during server maintenance. Failover is used in scenarion in which your primary database is not available and you want to convert role of one of standby database to primary database for ex. during primary database failure.<\/span>
\n<\/span>
\nData Protection Mode <\/strong>
\nStandby database in dataguard configuration can be configured in any of three protection mode which can be changed later as well depending on your requirement . These protection modes are Maximum Protection Mode<\/strong> , Maximum Availability Mode<\/strong> & Maximum Performance Mode. <\/strong><\/p>\n

Maximum Protection Mode <\/strong>
\nIn maximum protection mode as name suggest no data loss will occur if primary database fails. This is achieved by oracle by ensuring that redo data must be written to both local online redo log location & standby redo log location before transaction commits. This standby redo log will ensure full data protection. For full protection mode atleast one standby database should have standby redo log and LGWR, SYNC, and AFFIRM<\/strong> attribute should be used with LOG_ARCHIVE_DEST_n parameter. (I am going to discuss about these parameters in next post<\/span>)
\nHere your primary database will shutdown if it is unable to write redo records to atleast one standby location.<\/span><\/strong><\/em>
\n<\/span><\/em><\/strong>
\nMaximum Availability Mode<\/strong>
\nThis is similar to Maximum protection mode except that it will not shutdown primary database if primary database is not able to write standby redo logs to atleast one standby location but in that case Maximum Availability will act in Maximum Performance Mode until fault is corrected and all gaps in redo logs are resolved. Once all gaps are resolved primary database will automatically goes into Maximum Availability Mode.<\/p>\n

Maximum Performance Mode<\/strong>
\nThis is default mode in which redo stream is written asynchronously with respect to the commitment of the transactions that create the redo data. You can use LGWR<\/strong> and ASYNC<\/strong> attribute or ARCH<\/strong> attribute in LOG_ARCHIVE_DEST_n<\/strong><\/p>\n

You can check your database mode as<\/p>\n

SQL> select PROTECTION_LEVEL from v$database;
\nPROTECTION_LEVEL
\n—————————-
\nMAXIMUM PERFORMANCE<\/p>\n

How to change protection modes..<\/span><\/strong>
\nHow many standby database Instance you can configure …<\/span><\/strong>
\nexplanation on Log apply, log transport service , FAL Server\/Client ….<\/span><\/strong>
\nStep by step configuration of standby database using dataguard ..<\/span><\/strong><\/p>\n

Coming soon…<\/strong><\/span>
\n<\/span><\/strong>
\nReferences<\/strong>
\nhttp:\/\/download-uk.oracle.com\/docs\/cd\/B19306_01\/server.102\/b14239\/toc.htm<\/a><\/p>\n

http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"

Today I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[84,85],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-dataguard","tag-dr"],"yoast_head":"\nOracle Dataguard for Business Continuity -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Dataguard for Business Continuity -\" \/>\n<meta property=\"og:description\" content=\"Today I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-11-26T15:35:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-10-05T21:31:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/\",\"name\":\"Oracle Dataguard for Business Continuity -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg\",\"datePublished\":\"2006-11-26T15:35:00+00:00\",\"dateModified\":\"2007-10-05T21:31:25+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage\",\"url\":\"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg\",\"contentUrl\":\"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Dataguard for Business Continuity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Dataguard for Business Continuity -","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:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Dataguard for Business Continuity -","og_description":"Today I am going to cover Dataguard which is used for business continuity for Oracle Applications 11i including fusion middleware […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/","article_published_time":"2006-11-26T15:35:00+00:00","article_modified_time":"2007-10-05T21:31:25+00:00","og_image":[{"url":"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/","name":"Oracle Dataguard for Business Continuity -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage"},"thumbnailUrl":"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg","datePublished":"2006-11-26T15:35:00+00:00","dateModified":"2007-10-05T21:31:25+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#primaryimage","url":"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg","contentUrl":"http:\/\/photos1.blogger.com\/x\/blogger\/825\/3473\/320\/513328\/dataguard1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/26\/oracle-dataguard-for-business-continuity\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Dataguard for Business Continuity"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}