{"id":722,"date":"2013-03-18T17:49:23","date_gmt":"2013-03-18T14:49:23","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=722"},"modified":"2013-03-18T17:53:19","modified_gmt":"2013-03-18T14:53:19","slug":"limits-of-oracle-data-guard","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/limits-of-oracle-data-guard\/","title":{"rendered":"Limits of Oracle Data Guard"},"content":{"rendered":"<p><strong>Important situations of Oracle Data Guard<\/strong><\/p>\n<ul>\n<li>Nologging or unrecoverable operations are not applied to standby \u2013 so be cautious in using those options. Alarming data block corruption error messages are reported if a user attempts to access any nologging or unrecoverable data blocks.<\/li>\n<li>\u2018Drop tablespace\u2019, \u2018drop datafile\u2019, \u2018rename datafile\u2019, and add\/drop online redo log files operations need done on both nodes manually.<\/li>\n<li>Initialization parameter changes need done on both nodes manually.<\/li>\n<li>For databases upgrades, the software in the new ORACLE_HOME must be separately installed on both nodes. The database part of the upgrade is carried out only on the primary database.<br \/>\nOften Data Guard replication is suspended for a significant period of time during and following the primary database upgrade. That is done with\u00a0<em>DGMGRL&gt; edit database \u2018mydb_sby\u2019 set state=\u2019APPLY-OFF\u2019 ;<\/em>. The standby server is only upgraded, and replication resumed, once the primary upgrade has been determined to be a success.<\/li>\n<li>For patches, the software\/binaries in the ORACLE_HOME must be separately patched on both nodes. \u00a0The database part of the patch (if any) is carried out only on the primary database.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Important situations of Oracle Data Guard Nologging or unrecoverable operations are not applied to standby \u2013 so be cautious in using those options. Alarming data block corruption error messages are reported if a user attempts to access any nologging or unrecoverable data blocks. \u2018Drop tablespace\u2019, \u2018drop datafile\u2019, \u2018rename datafile\u2019, and add\/drop online redo log files&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,20],"tags":[14,32,36],"class_list":["post-722","post","type-post","status-publish","format-standard","hentry","category-administration","category-oracle-backup-and-recovery","tag-database-administration","tag-oracle-administration","tag-oracle-data-guard"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-bE","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=722"}],"version-history":[{"count":5,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/722\/revisions"}],"predecessor-version":[{"id":726,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/722\/revisions\/726"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=722"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}