Internal Error Code Arguments Kcratr_nab_less_than_odr
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not ora-00600 internal error code arguments kcratr_nab_less_than_odr solution work correctly without it enabled. Please turn JavaScript back
Ora-00600 Internal Error Code Arguments Kcratr1_lastbwr
on and reload this page. More documents in OTN Summit Database Replay Library alter database open ora 00600 All PlacesOTN Summit Database Replay Library Currently Being Moderated How to fix ORA-00600: internal error code Version 1 Created by BCG14 on Jul ora-00600 internal error code arguments kdsgrp1 28, 2016 8:33 PM. Last modified by BCG14 on Jul 28, 2016 8:33 PM. How to fix ORA-00600: internal error code, arguments: kcratr_nab_less_than_odrError and How to troubleshoot it: ___ SQL> startup;ORACLE instance started.Total System Global Area 1603411968 bytesFixed Size 2213776 bytesVariable Size 402655344 bytesDatabase Buffers
Ora-01589: Must Use Resetlogs Or Noresetlogs Option For Database Open
1191182336 bytesRedo Buffers 7360512 bytesDatabase mounted.ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],[8], [584], [593], [], [], [], [], [], [], []___Steps to fix. sql > startup mount;select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT';MEMBER-------------------------------------------------------------------------------- GROUP# STATUS---------- ----------------/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_bhkyvzjv_.log2 CURRENT/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_2_bhkyvzng_.log2 CURRENT_____recover database using backup controlfile until cancel;ORA-00279: change 1117415 generated at 03/07/2015 15:09:02 needed for thread 1ORA-00289: suggestion :/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2015_04_14/o1_mf_1_8_%u_.arcORA-00280: change 1117415 for thread 1 is in sequence #8____Specify log: {
Alter database open fails with ORA-00600 kcratr_nab_less_than_odr Db: 11.2.0.1SymptomsAfter Power Fail Alter database open fails withORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]ChangesPower ora-01194: file 1 needs more recovery to be consistent failureCauseThere was a power failure causing logical corruption in controlfileSolutionOption a------------SQL>Startup ora-01033 oracle initialization mount ;SQL>Show parameter control_filesQuery 1------------sql>select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status='CURRENT'Note down the
Ora-01110
name of the redo logSQL>Shutdown abort ;Take a OS Level back of the controlfile (This is to ensure we have a backup of current state of controlfile)SQL>Startup mount ;SQL>recover https://community.oracle.com/docs/DOC-1003662 database using backup controlfile until cancel ;Enter location of redo log shown as current in Query 1 when prompted for recoveryHit EnterSQL>Alter database open resetlogs ;Option b-----------Recreate the controlfile using the Controlfile recreation scriptWith database in mount stagerman target /rman> spool log to '/tmp/rman.log';Rman> list backup ;Rman > exitKeep this log handyGo to sqlplusSQL> Show parameter control_filesKeep http://dbataj.blogspot.com/2011/06/alter-database-open-fails-with-ora.html this location handy.SQL>oradebug setmypidSQL>Alter session set tracefile_identifier='controlfilerecreate' ;SQL>Alter database backup controlfile to trace ;SQL>Oradebug tracefile_name ; --> This command will give the path and name of the trace fileGo to this location ,Open this trace file and select the controlfile recreation script with NO Resetlogs optionSQL>Shutdown immediate;Rename the existing controlfile to _old ---> This is Important as we need to have a backup of existing controlfile since we plan to recreate itSQL>Startup nomountNow run the Controlfile recreation script with NO Resetlogs modeSQL>Alter database open ;For database version 10g and aboveOnce database is opened you can recatalog the rman backup information present in the list /tmp/rman.log usingRman> Catalog start with '' ;Once the database has been opened using the option a or option b its recommended to take a hot backup of the database.Same Steps are applicable to Rac if all instance are down with same error. Posted by Mohammed Taj at Wednesday, June 29, 2011 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Oracle 11gr2 Reactions: 31 com
here for a quick overview of the site Help Center Detailed answers to any questions you might http://stackoverflow.com/questions/5575611/oracle-error-ora-00600 have Meta Discuss the workings and policies of this site About http://satishvchandran.blogspot.com/2014/07/ora-00600-internal-error-code-arguments.html Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, internal error just like you, helping each other. Join them; it only takes a minute: Sign up Oracle error ORA-00600 up vote 2 down vote favorite I use Oracle 11g. A few days ago I encountered an ORA-12514 error. I tried to solve it by following this website suggestions: C:\>set oracle_sid=SID Create a new environment variable called internal error code TNS_ADMIN: in the ‘value’ field, add the new folder: c:\oracle\network\admin Copy tnsnames.ora, sqlnet.ora and listener.ora from c:\oracle\product\102\network\admin Paste into c:\oracle\network\admin Stop/start listener C:\>lsnrctl stop C:\>lsnrctl start after that I receive below error (ORA-01033): SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: pentacms Enter password: ERROR: ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 Enter user-name: I try to solve the error, but it raised an other error, I try to open log file but I receive below error(last line) "ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], 1, [46], [32689], [32690], [], [], [], [], [], [], [] " please advice me, It's an emergency case. FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# -------------------- ------------- -------------- --------------- ------------- TOP_LEVEL_CALL# LOGON_TIM LAST_CALL_ET PDM FAILOVER_TYPE FAILOVER_M FAI --------------- --------- ------------ --- ------------- ---------- --- RESOURCE_CONSUMER_GROUP PDML_STA PDDL_STA PQ_STATU -------------------------------- -------- -------- -------- CURRENT_QUEUE_DURATION ---------------------- CLIENT_IDENTIFIER BLOCKING_SE ------------------------------------------------
Version: DB:12.1.0.1.0 OS: OEL 6, 64 bit Issue: The file system on which DB files were available crashed, resulting in a DB crash. The next DB startup is failing with Internal errors. DB is coming up to the mount stage only. Error: Database mounted. ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1895], [12597], [12603], [], [], [], [], [], [], [] Reason: Because of the file system crash when DB was running,the data files became in accessible. This resulted in a "lost Write" into the Online RedoLogs. So the normal Instance Recovery procedure became impossible to happen causing the ORA-600 error. Solution: We can manually recover the DB by specifying the online redo thread at the time of crash if the full set of redo logs are available in the storage. Note:It is better to have a full backup of all the files before trying the steps. 1. Backup all DB files if possible 2. Identify the current log sequence group and file. SQL> startup mount; SQL> select GROUP#,STATUS from v$log; GROUP# STATUS ---------- ---------------- 1 INACTIVE 3 INACTIVE 2 CURRENT SQL> select GROUP#,MEMBER from v$logfile; GROUP# MEMBER --------- ----------------------- 1 /u01/oradata/orcl/redo01.log 2 /u01/oradata/orcl/redo02.log 3 /u01/oradata/orcl/redo03.log Here Group# 2 is current. So I am going to pass it manually 3. Manually Recover the DB SQL> recover database until cancel using backup controlfile; ORA-00279: change 23977161 generated at 07/18/2014 07:00:59 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/product/121010/dbs/arch1_1895_847740493.dbf ORA-00280: change 23977161 for thread 1 is in sequence #1895 Specify log: {