今天同事又反应了一个600问题,这个跟上次处理的不一样,这个要简单是多,不需要重建undo,具体如下:
--错误日志
SQL> startup
ORACLE instance started.
ORACLE instance started.
Total System Global Area 1577058304 bytes
Fixed Size 2084264 bytes
Variable Size 1040187992 bytes
Database Buffers 520093696 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
Fixed Size 2084264 bytes
Variable Size 1040187992 bytes
Database Buffers 520093696 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
--执行恢复
SQL> recover database;
Media recovery complete.
SQL>
SQL> alter database open;
Media recovery complete.
SQL>
SQL> alter database open;
Database altered.
数据库可以顺利打开!
出现这个问题的原因是oracle不能执行实例恢复,手工完成介质恢复后可以打开。