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日誌完好，也是完全恢復。