recover database until cancel using backup controlfile

recover database until cancel using backup controlfile的一些知识点。[@more@]

QAPROD_arch15342.dbf 已经在归档地址，但用rman里的recover提示：RMAN-06054: media recovery requesting unknown log: thread 1 scn 7418781225888。

用“recover database until cancel using backup controlfile;” 就可以。难道是因为控制文件是用“alter database backup control file to '/u16/me/control_bkup';” 这种方法备份来的，就需要用“recover database until cancel using backup controlfile;”

RMAN> run {

allocate channel c1 type disk;
recover database;
release channel c1;

}

2> 3> 4> 5> 6> 7>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=10 devtype=DISK

RMAN-03022: compiling command: recover

RMAN-03022: compiling command: recover(1)

RMAN-03022: compiling command: recover(2)

RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery

RMAN-03022: compiling command: recover(4)
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover(4)
RMAN-06054: media recovery requesting unknown log: thread 1 scn 7418781225888

××××××××××××××××××××××××××××××××××××××××××××××××

××××××××××××××××××××××××××××××××××××××××××××××××

n-nesdb:oracle:QAPROD> sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jan 10 18:02:32 2013

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 7418781225888 generated at 01/04/2013 14:11:36 needed for
thread 1
ORA-00289: suggestion : /u03/oraarch/QAPROD/QAPROD_arch15342.dbf
ORA-00280: change 7418781225888 for thread 1 is in sequence #15342


Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00279: change 7418781234427 generated at 01/10/2013 17:50:53 needed for
thread 1
ORA-00289: suggestion : /u03/oraarch/QAPROD/QAPROD_arch15343.dbf
ORA-00280: change 7418781234427 for thread 1 is in sequence #15343
ORA-00278: log file '/u03/oraarch/QAPROD/QAPROD_arch15342.dbf' no longer needed
for this recovery


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.

××××××××××××××××××××××××××××××××××××××××××

××××××××××××××××××××××××××××××××××××××××××

using backup controlfile 告诉Oracle不要使用control file中的scn
until cancel 用于redo log file丢失时使用，如redo log sequence#1,2,3,4,5,6，丢失4，5，会恢复到3。

两个连用告诉Oracle恢复的时候恢复到最后一个可用的redo log file，不管控制文件中的scn是多少
我也就说until cancel 不一定是不完全恢复，如果归档日志文件和redo日志完好，也是完全恢复。

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

转载于:http://blog.itpub.net/14377/viewspace-1060067/