Internal Error Code Arguments Kcratr_scan_lastbwr
Robert Jackson | 4 Comments The Problem I had refreshed one of our dev databases but the database we were refreshing it from was still open at the time when the disks were flushed at the SAN level and there must have been transactions still in process. One of the steps is to enable archivelog mode and it failed with the following error: alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode Before getting the exact sequence of commands to run I first tried opening the database and got an ORA00600 error: SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], [] The Cause This is documented on Metalink note "ORA-600 [kcratr_scan_lastbwr] [ID 1267231.1]" and the workaround suggested below The Solution To recover from this use the following sequence of commands: SQL> alter database recover database; Database altered. SQL> alter database open; Database altered. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT PFILE='D:\oracle\cloneDB\initTEST.ora ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2262048 bytes Variable Size 557845472 bytes Database Buffers 503316480 bytes Redo Buffers 5513216 bytes Database mounted. SQL> alter database archivelog; Database altered. And there you have it, the answer to all your problems….Well, maybe just this little ORA-00600 error but that's better than nothing! Like it, share it... Category: ORA 600 Related Posts ORA-00600: internal error code, arguments: opirfs.1 ORA-00600: internal error code, arguments: [kzaxins:sqtxt] ORA-00600: internal error code, arguments: ktsladdfcb-bsz ORA-00600: internal error code, arguments: [ksu_register_tac-1] Comments (4) Trackback URL | Comments RSS Feed nkl says: August 26, 2016 at 07:19 I tried following on 12.1, it worked for me SQL> shutdown immediate SQL> startup mount SQL>alter database recover database; SQL> alter database open Reply Robert Jackson says: September 21, 2016 at 16:54 Perfect, thanks for letting me know. Pleased it worked
internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],[], [], [], [], [], [], [], [] SQL> startup;ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area 1319546880 bytesFixed Size 2254904 bytesVariable Size 671090632 bytesDatabase Buffers 637534208 bytesRedo Buffers 8667136 bytesDatabase mounted.ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],[], [], [], [], [], [], [], [] To resolve followed below steps. post getting above error. SQL> alter database recover database;Database altered.SQL> alter database open;Database altered.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup;ORA-32004: obsolete or deprecated parameter(s) specified for http://www.ora00600.com/wordpress/scripts/ora600/ora-00600-internal-error-code-arguments-kcratr_scan_lastbwr/ RDBMS instanceORACLE instance started.Total System Global Area 1319546880 bytesFixed Size 2254904 bytesVariable Size 671090632 bytesDatabase Buffers 637534208 bytesRedo Buffers 8667136 bytesDatabase mounted.Database opened.SQL> Posted by Nikunj Thaker at 1:26 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 2 comments: Anonymous said... Hey friend...thanks a lot for your post. I could solve this problem using your instructions. July 07, 2015 6:57 PM Anonymous said... Thank http://nikunjthaker.blogspot.com/2014/03/ora-00600-internal-error-code-arguments.html you. After browsing many blog posts, this is the one that saved my database. Thank you very much! March 11, 2016 2:27 PM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Pages Home About Me Nikunj Thaker Ahmedabad, Gujarat, India Over 20+ Years Of Intensive Experience as a techno-functional In Planning, Managing, Implementing And Monitoring IT Systems. 11+ Year experience as Techno function SAP BASIS, SAP MM, SAP-FICO. View my complete profile Blog Archive ► 2016 (5) ► January (5) ► 2015 (2) ► December (1) ► March (1) ▼ 2014 (8) ► July (1) ► June (1) ► May (1) ► April (1) ▼ March (1) ORA-00600: internal error code, arguments: [kcratr... ► February (1) ► January (2) ► 2013 (3) ► November (2) ► May (1) ► 2012 (9) ► December (1) ► October (2) ► September (3) ► August (1) ► February (2) ► 2011 (14) ► October (2) ► August (1) ► July (3) ► June (8) ► 2007 (3) ► August (1) ► June (1) ► February (1) ► 2006 (8) ► July (1) ► March (1) ► February (2) ► Ja
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://dba.stackexchange.com/questions/82349/my-oracle-db-wont-open-please-help Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted internal error up and rise to the top my oracle db won't open please help up vote 0 down vote favorite This is what happens when I try to query as DBA: SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real internal error code Application Testing options SQL> select count(*) from dba_users; select count(*) from dba_users * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [824], [95], [98], [], [], [], [], [], [], [] please help to restore my db... oracle restore share|improve this question edited Nov 11 '14 at 7:49 aasim.abdullah 1,61611228 asked Nov 11 '14 at 3:35 goodluck247 1 You should post the last 1,000 lines of your alert log file. It would also help for you to give some background on what was changed before this issue came up. Did you upgrade recently, apply a patch, change a system variable? You may end up needing to create an SR with Oracle to have them help you resolve the issue. But it is not clear from the ORA-00600 error what the issue is. You may also want to try: recover database until cancel using backup controlfile; AUTO recover database until cancel using backup controlfile; CANCEL alter database open resetlogs; –Gandolf989 Nov 11 '14 at 14:45 Hi there, I think there is a problem with your restore procedure. A little google search lead me to this post link –Jefferson B. Elias Oct 10 '15