{"id":399,"date":"2008-10-25T18:39:28","date_gmt":"2008-10-25T16:39:28","guid":{"rendered":"http:\/\/www.ora-solutions.net\/web\/?p=399"},"modified":"2009-01-06T14:44:29","modified_gmt":"2009-01-06T12:44:29","slug":"ora-00322-ora-00312-at-dataguard-standby","status":"publish","type":"post","link":"https:\/\/www.ora-solutions.net\/web\/2008\/10\/25\/ora-00322-ora-00312-at-dataguard-standby\/","title":{"rendered":"ORA-00322, ORA-00312 at DataGuard Standby"},"content":{"rendered":"<p>From time to time I have encountered the following errors on the physical dataguard standby database while in recovery mode: <\/p>\n<blockquote><p><code>Errors in file \/oracle\/STBDB1\/oratrace\/bdump\/stbdb1_mrp0_26719.trc:<br \/>\nORA-00322: log 5 of thread 1 is not current copy<br \/>\nORA-00312: online log 5 thread 1: '\/oracle\/STBDB1\/origlogB\/standby_g5_m1.log'<br \/>\nSun Oct 16 13:04:08 2008<br \/>\nErrors in file \/oracle\/STBDB1\/oratrace\/bdump\/stbdb1_mrp0_26719.trc:<br \/>\nORA-00322: log 5 of thread 1 is not current copy<br \/>\nORA-00312: online log 5 thread 1: '\/oracle\/STBDB1\/origlogB\/standby_g5_m1.log'<\/code><\/p><\/blockquote>\n<p>The problem corrects itself after a couple of minutes, so there is no real problem, but if you have alert log monitoring active, this will trigger a call for investigation. Oracle is tracking this error with <strong>Bug 5238386 &#8211; ORA-322 possible reading standby redo log header.<\/strong> There is a one-off patch available for 10.2.0.3 and the patch is included in patchset 10.2.0.4.<\/p>\n<p>There is a workaround to clear the referenced redo log but I don\u00b4t see any point in doing that, because the error can occurr again as long as the patch is not installed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>From time to time I have encountered the following errors on the physical dataguard standby database while in recovery mode: Errors in file \/oracle\/STBDB1\/oratrace\/bdump\/stbdb1_mrp0_26719.trc: ORA-00322: log 5 of thread 1 is not current copy ORA-00312: online log 5 thread 1: &#8216;\/oracle\/STBDB1\/origlogB\/standby_g5_m1.log&#8217; Sun Oct 16 13:04:08 2008 Errors in file \/oracle\/STBDB1\/oratrace\/bdump\/stbdb1_mrp0_26719.trc: ORA-00322: log 5 of thread [&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":[13,14,47,16,5],"tags":[],"class_list":["post-399","post","type-post","status-publish","format-standard","hentry","category-10g","category-11g","category-bugs","category-data-guard","category-oracle-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/399","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=399"}],"version-history":[{"count":4,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/399\/revisions"}],"predecessor-version":[{"id":546,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/posts\/399\/revisions\/546"}],"wp:attachment":[{"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/media?parent=399"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/categories?post=399"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ora-solutions.net\/web\/wp-json\/wp\/v2\/tags?post=399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}