본문 바로가기
Troubleshooting/Application

ORA-00600 에러 대처방법

by 신군. 2018. 10. 11.
반응형

AMSU:/home/lips> su - oracle
¾ÏÈ£: 
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
[AMSU:/home/oracle]$sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jul 10 16:32:16 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> 
SQL> 
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1043886080 bytes
Fixed Size                  2217624 bytes
Variable Size             276826472 bytes
Database Buffers          759169024 bytes
Redo Buffers                5672960 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[45], [45448], [45484], [], [], [], [], [], [], []


SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SP2-0734: unknown command beginning "_corrupt_b..." - rest of line ignored.
SQL> recover database until cancel using backup controlfile;

ORA-00279: change 532815 generated at 07/10/2010 06:20:27 needed for thread 1
ORA-00289: suggestion :
/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_45_723921756.dbf
ORA-00280: change 532815 for thread 1 is in sequence #45


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_45_723921756.dbf'
ORA-27037: unable to obtain file status
Solaris-AMD64 Error: 2: No such file or directory
Additional information: 3


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 532815 generated at 07/10/2010 06:20:27 needed for thread 1
ORA-00289: suggestion :
/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_45_723921756.dbf
ORA-00280: change 532815 for thread 1 is in sequence #45


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;

Database altered.

SQL> shutdown immediate;

Database closed.


Database dismounted.
ORACLE instance shut down.
SQL> 
SQL> 
SQL> startup;
ORACLE instance started.

Total System Global Area 1043886080 bytes
Fixed Size                  2217624 bytes
Variable Size             276826472 bytes
Database Buffers          759169024 bytes
Redo Buffers                5672960 bytes
Database mounted.
Database opened.
SQL> 
SQL> quit
Disconnected from Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

반응형