ITPub博客

首页 > 应用开发 > IT综合 > 在做完全恢复时如果有redo存在,则会使用redo而不会使用对应的归档

在做完全恢复时如果有redo存在,则会使用redo而不会使用对应的归档

原创 IT综合 作者:warehouse 时间:2013-04-26 10:08:41 0 删除 编辑
在恢复的提示中以及alert中都能清楚的发现,如果是不完全恢复那么只会寻找归档而不会去使用redo[@more@]

SQL> recover database;
ORA-00279: change 715107 generated at 04/26/2013 09:32:44 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_43_8QMPCSPY_.AR
C
ORA-00280: change 715107 for thread 1 is in sequence #43


Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 715136 generated at 04/26/2013 09:33:45 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_44_8QMPF9RF_.AR
C
ORA-00280: change 715136 for thread 1 is in sequence #44


ORA-00279: change 715163 generated at 04/26/2013 09:34:33 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_45_8QMPGMPG_.AR
C
ORA-00280: change 715163 for thread 1 is in sequence #45


Log applied.Media recovery complete.
SQL>

--==================================

alert日志中的提示如下:

ALTER DATABASE RECOVER database
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 8 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER database ...
Fri Apr 26 10:06:09 2013
Checker run found 5 new persistent data failures
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_43_8QMPCSPY_.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_44_8QMPF9RF_.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_45_8QMPGMPG_.ARC
Fri Apr 26 10:06:13 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 46 Reading mem 0
Mem# 0: E:ORADATATESTREDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 47 Reading mem 0
Mem# 0: E:ORADATATESTREDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 48 Reading mem 0
Mem# 0: E:ORADATATESTREDO03.LOG
Completed: ALTER DATABASE RECOVER CONTINUE DEFAULT
Fri Apr 26 10:06:49 2013

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/19602/viewspace-1060436/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5366310