a10g/redo01.log
--在另一个session中查看online redo log是否已经恢复
[oracle@ora10g ora10g]$ ll
total 1068436
-rw-r----- 1 oracle oinstall 7061504 Aug 25 13:03 control01.ctl
-rw-r----- 1 oracle oinstall 7061504 Aug 25 13:03 control02.ctl
-rw-r----- 1 oracle oinstall 7061504 Aug 25 13:03 control03.ctl
-rw-r----- 1 oracle oinstall 104865792 Aug 25 13:00 example01.dbf
-rw-r----- 1 oracle oinstall 52429312 Aug 25 13:12 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Aug 25 13:12 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Aug 25 13:12 redo03.log
-rw-r----- 1 oracle oinstall 251666432 Aug 25 13:01 sysaux01.dbf
-rw-r----- 1 oracle oinstall 503324672 Aug 25 13:02 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Aug 25 12:59 temp01.dbf
-rw-r----- 1 oracle oinstall 31465472 Aug 25 13:01 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Aug 25 13:00 users01.dbf
[oracle@ora10g ora10g]$
--重新登录数据库，进行dml操作
[oracle@ora10g fd]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 25 13:14:25 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select count(*) from dba_objects;
COUNT(*)
----------
50314
此时数据库可以正常dml了，但是关闭后再开启数据库，会报600错误：
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []
--查看alert.log
Mon Aug 25 13:19:16 2014
ALTER DATABASE MOUNT
Mon Aug 25 13:19:20 2014
Setting recovery target incarnation to 2
Mon Aug 25 13:19:21 2014
Successful mount of redo thread 1, with mount id 4175423764
Mon Aug 25 13:19:21 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Aug 25 13:19:21 2014
ALTER DATABASE OPEN
Mon Aug 25 13:19:21 2014
Beginning crash recovery of 1 threads
Mon Aug 25 13:19:21 2014
Started redo scan
Mon Aug 25 13:19:21 2014
Errors in file /u01/app/oracle/admin/ora10g/udump/ora10g_ora_3320.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
Mon Aug 25 13:19:22 2014
Aborting crash recovery due to error 600--终止实例恢复
根据Metalink note ID: [393984.1]文档的说明，出现该问题的原因是oracle不能执行实例恢复，手工完成介质恢复后即可以打开
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> recover database
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select count(*) from dba_objects;
COUNT(*)
----------
50314
SQL>
--再次验证数据文件
SQL> !ps -ef | grep ora_
oracle 3464 1 0 13:50 00:00:00 ora_pmon_ora10g
oracle 3466 1 0 13:50 00:00:00 ora_psp0_ora10g
oracle 3468 1 0 13:50 00:00:00 ora_mman_ora10g
oracle 3470 1 0 13:50 00:00:00 ora_dbw0_ora10g
oracle 3472 1 0 13:50 00:00:00 ora_lgwr_ora10g
oracle 3474 1 0 13:50 00:00:01 ora_ckpt_ora10g
oracle 3476 1 0 13:50 00:00:01 ora_smon_ora10g
oracle 3478 1 |