{"id":133,"date":"2015-08-25T16:29:19","date_gmt":"2015-08-25T16:29:19","guid":{"rendered":"https:\/\/dbadave.co.uk\/?p=133"},"modified":"2016-02-12T22:01:52","modified_gmt":"2016-02-12T22:01:52","slug":"ora-00600-kcratr_nab_less_than_odr-after-power-failure","status":"publish","type":"post","link":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/","title":{"rendered":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure"},"content":{"rendered":"

A client of mine suffered a power failure the other day and when the power was eventually restored they hit a problem when they tried to restart one of their databases. The opening of the database failed with the following error:<\/p>\n

ORA-600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], <\/em>[896], [328], [369], [], [], [], [], [], [], []<\/em><\/p>\n

I looked in the database alert log to see if there was any more information but there was nothing of any use, so I went on to the official Oracle support site, Metalink.<\/p>\n

ORA-00600 [kcratr_nab_less_than_odr]<\/h2>\n

The ORA-00600 tool on Metalink<\/a> had nothing listed for these error arguments but after a little\u00a0digging around, I found a bug that refers to this exact error. The bug number is 10100975 if you are interested. And I should say by the way that the ORA-00600 tool is a great utility and has helped me out a lot in the past and saved me a lot of time and stress.<\/p>\n

According to the Metalink document about the bug there is no workaround and the only solution is to do a point-in-time recovery of the database. I did a bit more investigation though, and it seems that the error is caused by corruption of the control files. So\u00a0this is what I did to fix the problem:<\/p>\n

1. Mounted the database.<\/p>\n

2. Found the name of the current redo log file:<\/p>\n

select a.member from v$logfile a ,v$log b where a.group#=b.group# and b.status=’CURRENT’;<\/em><\/p>\n

3. Shutdown aborted the database.<\/p>\n

4. Made a backup copy of the control file.<\/p>\n

5. Startup mounted the database.<\/p>\n

6. Recovered the database:<\/p>\n

recover database using backup controlfile until cancel;<\/em><\/p>\n

7. When prompted for the log file for recovery, I entered the full path and name of the redo log file that was returned in the query in step 2 above.<\/p>\n

8. Once the log was applied and I got the message that the media recovery was complete, I opened the database resetting the redo logs:<\/p>\n

alter database open resetlogs;<\/em><\/p>\n

This worked fine for me and there were no subsequent problems with the database, so hopefully if you ever hit the same problem this solution will work for you too.<\/p>\n","protected":false},"excerpt":{"rendered":"

A client of mine suffered a power failure the other day and when the power was eventually restored they hit a problem when they tried to restart one of their databases. The opening of the database failed with the following error: ORA-600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [896], [328], [369], [], [], [], [], … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"yoast_head":"\nORA-00600 [kcratr_nab_less_than_odr] After Power Failure<\/title>\n<meta name=\"description\" content=\"A client recently had an "ORA-00600 [kcratr_nab_less_than_odr]" error when trying to restart a database after a power failure. Here's how I fixed it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure\" \/>\n<meta property=\"og:description\" content=\"A client recently had an "ORA-00600 [kcratr_nab_less_than_odr]" error when trying to restart a database after a power failure. Here's how I fixed it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Dave - Oracle Training\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-25T16:29:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-12T22:01:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"770\" \/>\n\t<meta property=\"og:image:height\" content=\"340\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\"},\"headline\":\"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure\",\"datePublished\":\"2015-08-25T16:29:19+00:00\",\"dateModified\":\"2016-02-12T22:01:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\"},\"wordCount\":369,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg\",\"articleSection\":[\"Oracle Errors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\",\"url\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\",\"name\":\"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure\",\"isPartOf\":{\"@id\":\"https:\/\/dbadave.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg\",\"datePublished\":\"2015-08-25T16:29:19+00:00\",\"dateModified\":\"2016-02-12T22:01:52+00:00\",\"description\":\"A client recently had an \\\"ORA-00600 [kcratr_nab_less_than_odr]\\\" error when trying to restart a database after a power failure. Here's how I fixed it.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg\",\"width\":770,\"height\":340,\"caption\":\"Oracle ORA-00600 Database Won't Open Error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbadave.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbadave.co.uk\/#website\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"name\":\"DBA Dave - Oracle Training\",\"description\":\"Expert DBA Tips & Advice\",\"publisher\":{\"@id\":\"https:\/\/dbadave.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbadave.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbadave.co.uk\/#organization\",\"name\":\"DBA Dave\",\"url\":\"https:\/\/dbadave.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"contentUrl\":\"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png\",\"width\":170,\"height\":50,\"caption\":\"DBA Dave\"},\"image\":{\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/dbadave.co.uk\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure","description":"A client recently had an \"ORA-00600 [kcratr_nab_less_than_odr]\" error when trying to restart a database after a power failure. Here's how I fixed it.","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:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/","og_locale":"en_US","og_type":"article","og_title":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure","og_description":"A client recently had an \"ORA-00600 [kcratr_nab_less_than_odr]\" error when trying to restart a database after a power failure. Here's how I fixed it.","og_url":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/","og_site_name":"DBA Dave - Oracle Training","article_published_time":"2015-08-25T16:29:19+00:00","article_modified_time":"2016-02-12T22:01:52+00:00","og_image":[{"width":770,"height":340,"url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg","type":"image\/jpeg"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#article","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/"},"author":{"name":"admin","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40"},"headline":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure","datePublished":"2015-08-25T16:29:19+00:00","dateModified":"2016-02-12T22:01:52+00:00","mainEntityOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/"},"wordCount":369,"commentCount":4,"publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg","articleSection":["Oracle Errors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/","url":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/","name":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure","isPartOf":{"@id":"https:\/\/dbadave.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage"},"image":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage"},"thumbnailUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg","datePublished":"2015-08-25T16:29:19+00:00","dateModified":"2016-02-12T22:01:52+00:00","description":"A client recently had an \"ORA-00600 [kcratr_nab_less_than_odr]\" error when trying to restart a database after a power failure. Here's how I fixed it.","breadcrumb":{"@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#primaryimage","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2015\/08\/ora-00600-database-open-1.jpg","width":770,"height":340,"caption":"Oracle ORA-00600 Database Won't Open Error"},{"@type":"BreadcrumbList","@id":"https:\/\/dbadave.co.uk\/ora-00600-kcratr_nab_less_than_odr-after-power-failure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbadave.co.uk\/"},{"@type":"ListItem","position":2,"name":"ORA-00600 [kcratr_nab_less_than_odr] After Power Failure"}]},{"@type":"WebSite","@id":"https:\/\/dbadave.co.uk\/#website","url":"https:\/\/dbadave.co.uk\/","name":"DBA Dave - Oracle Training","description":"Expert DBA Tips & Advice","publisher":{"@id":"https:\/\/dbadave.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbadave.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbadave.co.uk\/#organization","name":"DBA Dave","url":"https:\/\/dbadave.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","contentUrl":"https:\/\/dbadave.co.uk\/wp-content\/uploads\/2016\/02\/dba-dave-logo.png","width":170,"height":50,"caption":"DBA Dave"},"image":{"@id":"https:\/\/dbadave.co.uk\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/c51b3c9b3e2e2e9bbd141a719c024c40","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbadave.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d6ad3f291a149878281854f13654bf0?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/dbadave.co.uk\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/133"}],"collection":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":13,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/posts\/133\/revisions\/370"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media\/368"}],"wp:attachment":[{"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbadave.co.uk\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}