{"id":506,"date":"2012-02-01T06:10:52","date_gmt":"2012-02-01T05:10:52","guid":{"rendered":"https:\/\/oracle-in-zen.de\/?p=506"},"modified":"2018-06-01T16:47:45","modified_gmt":"2018-06-01T15:47:45","slug":"ora-600-krr_assemble_cv_12-in-11g-standby-db","status":"publish","type":"post","link":"https:\/\/oracle-in-zen.de\/?p=506","title":{"rendered":"ORA-600 [krr_assemble_cv_12] 11g Standby DB"},"content":{"rendered":"<p>Der Fehler kann in einer Oracle Standby Umgebung auftreten. In der physikalischen Standby-Datenbank kommt es zu folgendem Ereignis:<\/p>\n<p><!--more--><\/p>\n<p>Auszug alert.log Standby DB:<\/p>\n<pre> Errors in file D:\\ORACLE\\diag\\rdbms\\ecrs\\ecrs\\trace\\orcl_pr03_4064.trc (incident=14706):\r\n ORA-00600: internal error code, arguments: [krr_assemble_cv_12], [5536], [3072]<\/pre>\n<p>Das Media Recovery, in der Standby DB, wird durch das Problem unterbrochen und es werden keine Archive Logs mehr appliziert. Im alert.log der Prim\u00e4r DB ist\u00a0folgender Eintrag zu finden:<\/p>\n<p>Auszug alert.log Prim\u00e4r DB:<\/p>\n<pre>Thu Feb 01 18:48:24 2012\r\nLNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)\r\nLNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned\r\nError 3113 for archive log file 6 to &#039;orclstby&#039;\r\nErrors in file D:\\ORACLE\\diag\\rdbms\\orcl\\orcl\\trace\\orcl_nsa2_6160.trc:\r\nORA-03113: end-of-file on communication channel\r\nLNS: Failed to archive log 6 thread 1 sequence 108533 (3113)<\/pre>\n<p>Auszug Data Guard Log:<\/p>\n<pre>DMON: HEALTH CHECK ERROR: ORA-16766: Redo Apply is stopped\r\nOperation HEALTH_CHECK canceled during phase 1, error = ORA-16766<\/pre>\n<p>&nbsp;<\/p>\n<p>Die Oracle Note\u00a010258124.8 beschreibt einen Bug, der genau diese Symptome zeigt. Betroffen sind die Releases 11.1.0.7 &#8211; 11.2.0.2. Als Workaround wird das Neustarten des Media Recovery Prozesses genannt bzw. shutdown\/ startup der Standby-Datenbank. Dataguard sollte diese Situation meistern und den Recovery Prozess wieder aufsetzten.<\/p>\n<p class=\"brush: xml; gutter: false\">Danach funktioniert der Redo-Apply wieder und die Umgebung ist in Ordnung. Bis zum n\u00e4chsten\u00a0ORA-600 [krr_assemble_cv_12].<\/p>\n<p class=\"brush: xml; gutter: false\">Nach Note 10258124.8 ist der Bug in\u00a011.2.0.3 (bzw. 12.1 Future Release) gefixt. Diese konnte ich allerdings noch nicht pr\u00fcfen.<\/p>\n<p>&nbsp;<\/p>\n<p>Oracle Notes im Artikel<br \/>\n10258124.8<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Der Fehler kann in einer Oracle Standby Umgebung auftreten. In der physikalischen Standby-Datenbank kommt es zu folgendem Ereignis:<\/p>\n","protected":false},"author":1,"featured_media":597,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"zakra_page_container_layout":"customizer","zakra_page_sidebar_layout":"customizer","zakra_remove_content_margin":false,"zakra_sidebar":"customizer","zakra_transparent_header":"customizer","zakra_logo":0,"zakra_main_header_style":"default","zakra_menu_item_color":"","zakra_menu_item_hover_color":"","zakra_menu_item_active_color":"","zakra_menu_active_style":"","zakra_page_header":true,"footnotes":""},"categories":[11,36],"tags":[12,32,39,37,38],"class_list":["post-506","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-2","category-ora","tag-11g","tag-alert","tag-dataguard","tag-ora-2","tag-standby"],"_links":{"self":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=506"}],"version-history":[{"count":42,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/506\/revisions"}],"predecessor-version":[{"id":1316,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/posts\/506\/revisions\/1316"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=\/wp\/v2\/media\/597"}],"wp:attachment":[{"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-in-zen.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}