Sun Sep 25 14:33:19 2011
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15 Reading mem 0
Mem# 0 errs 0: /home/oracle/oracle/product/oradata/orcl/redo02.log
Sun Sep 25 14:33:19 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 16 Reading mem 0
Mem# 0 errs 0: /home/oracle/oracle/product/oradata/orcl/redo03.log
Sun Sep 25 14:33:19 2011
Media Recovery Complete (orcl)
Completed: ALTER DATABASE RECOVER CONTINUE DEFAULT
根据以上信息，可以看到：Oracle使用的redo日志。
结论：Oracle介质恢复，使用归档日志+Redo日志，优先使用Redo日志。
8、验证一下SCN
select 'scnOfDatafile',name,checkpoint_change# from v$datafile
union
select 'scnOfDatafileHeader',name,checkpoint_change# from v$datafile_header
union
select 'scnOfDatabase','database',checkpoint_change# from v$database;
'SCNOFDATAFILE' NAME CHECKPOINT_CHANGE#
------------------- ------------------------------------------------------------ ------------------
scnOfDatafile /home/oracle/oracle/product/oradata/orcl/sysaux01.dbf 743906
scnOfDatafile /home/oracle/oracle/product/oradata/orcl/system01.dbf 743906
scnOfDatafile /home/oracle/oracle/product/oradata/orcl/undotbs01.dbf 743906
scnOfDatafile /home/oracle/oracle/product/oradata/orcl/users01.dbf 743906
scnOfDatafileHeader /home/oracle/oracle/product/oradata/orcl/sysaux01.dbf 743906
scnOfDatafileHeader /home/oracle/oracle/product/oradata/orcl/system01.dbf 743906
scnOfDatafileHeader /home/oracle/oracle/product/oradata/orcl/undotbs01.dbf 743906
scnOfDatafileHeader /home/oracle/oracle/product/oradata/orcl/users01.dbf 743906
8 rows selected.
发现SCN号已经一致。此时数据库已经处于同步状态。
9、检查数据是否恢复
SQL> select count(*) from scott.recover_test;
COUNT(*)
----------
448
作者“隔壁老王”