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
'Troubleshooting > Application' 카테고리의 다른 글
CRRTC0290E (0) | 2018.12.16 |
---|---|
wireshark “couldn't run /usr/bin/dumpcap in child process” (0) | 2018.11.05 |
RTC CRJAZ1745E 데이터웨어 하우스 테이블을 만드는 중 오류가 발생했습니다. 다시 시도하십시오 .ID (0) | 2018.10.06 |
error: ORA-65096: invalid common user or role name in oracle (0) | 2018.10.05 |
STS Error (0) | 2018.05.20 |