{"id":1072,"date":"2011-05-26T15:21:32","date_gmt":"2011-05-26T13:21:32","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=1072"},"modified":"2011-05-26T15:21:32","modified_gmt":"2011-05-26T13:21:32","slug":"data-guard-11-2-0-2-update","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2011\/05\/26\/data-guard-11-2-0-2-update\/","title":{"rendered":"Data Guard 11.2.0.2 &#8211; update"},"content":{"rendered":"<p>In March, Oracle MAA has published a white paper for implementing Data Guard on Exadata platforms. (<a title=\"http:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/maa-wp-dr-dbm-130065.pdf\" href=\"http:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/maa-wp-dr-dbm-130065.pdf\">http:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/maa-wp-dr-dbm-130065.pdf<\/a>)<\/p>\n<p>Although the paper is focused on Exadata, some information can be applied to non-Exadata systems as well:<\/p>\n<ul>\n<li><strong>Corruption Protection:<\/strong>\n<ul>\n<li style=\"text-align: left;\"> Primary:\n<ul>\n<li style=\"text-align: left;\">DB_BLOCK_CHECKSUM=FULL,<\/li>\n<li style=\"text-align: left;\">DB_BLOCK_CHECKING=FULL,<\/li>\n<li style=\"text-align: left;\">DB_LOST_WRITE_PROTECT=TYPICAL<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"text-align: left;\"> (Physical) Standby:\n<ul>\n<li style=\"text-align: left;\">DB_BLOCK_CHECKSUM=FULL,<\/li>\n<li style=\"text-align: left;\">DB_BLOCK_CHECKING=OFF,<\/li>\n<li style=\"text-align: left;\">DB_LOST_WRITE_PROTECT=TYPICAL<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><strong>Network Tuning:<\/strong><br \/>\nTCP Send\/Receive Buffers: 3 x Bandwith Delay Product or 10 MB, whichever is greater<\/li>\n<li><strong>Redo Transport Modes:<\/strong>\n<ul>\n<li>SYNC is recommended if round-trip-time is less than 5 ms.\u00a0 Impact of SYNC Mode on primary performance has been improved because local online redo log write and redo shipping is not done sequentially anymore but in parallel.<\/li>\n<li>ASYNC: Transport Lag is reduced because Redo is not read from online redo log from disk but from log buffer if possible. init.ora log_buffer might need to be increased for this to yield the maximum benefit.<\/li>\n<\/ul>\n<\/li>\n<li><strong>LOGGING\/NOLOGGING: <\/strong>Normally, in Data Guard you set database-wide &#8220;ALTER DATABASE FORCE LOGGING&#8221;. In Data Warehouse environments, it might be advisable to set it to NOLOGGING and decide on a tablespace-basis whether the tablespace should allow or disallow NOLOGGING operations. E.g. a tablespace containing only transient, recreatable\u00a0 or non-critical data might benefit from being set to NOLOGGING for certain bulk operations. (CTAS, Direct Path Inserts, index rebuilds, etc.)<\/li>\n<li><strong>STANDBY-FIRST Patches:<\/strong> Some patches (PSU, CPU, PSE) will be flagged in the patch README with &#8220;Standby-First&#8221;. This means that they can be applied on a physical standby before being applied on the primary. For regular patches, this was not supported.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In March, Oracle MAA has published a white paper for implementing Data Guard on Exadata platforms. (http:\/\/www.oracle.com\/technetwork\/database\/features\/availability\/maa-wp-dr-dbm-130065.pdf) Although the paper is focused on Exadata, some information can be applied to non-Exadata systems as well: Corruption Protection: Primary: DB_BLOCK_CHECKSUM=FULL, DB_BLOCK_CHECKING=FULL, DB_LOST_WRITE_PROTECT=TYPICAL (Physical) Standby: DB_BLOCK_CHECKSUM=FULL, DB_BLOCK_CHECKING=OFF, DB_LOST_WRITE_PROTECT=TYPICAL Network Tuning: TCP Send\/Receive Buffers: 3 x Bandwith Delay Product [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,5],"tags":[],"class_list":["post-1072","post","type-post","status-publish","format-standard","hentry","category-data-guard","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/comments?post=1072"}],"version-history":[{"count":9,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1072\/revisions"}],"predecessor-version":[{"id":1081,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/1072\/revisions\/1081"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=1072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=1072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=1072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}