SQL> recover database using backup controlfile until cancel;ORA-00279: change 179837183114 generated at 07/11/2014 10:48:42 needed for
thread 1
ORA-00289: suggestion : F:\ARCH\ARC0000040233_0849244163.0001
ORA-00280: change 179837183114 for thread 1 is in sequence #40233
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\PRCWEB\SYSTEM01.DBF'
ORA-01112: media recovery not started
然后我试着恢复了下这个归档 失败:
RMAN> restore archivelog sequence 40233 ;
Starting restore at 17-JUL-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/17/2014 09:49:39
RMAN-06026: some targets not found - aborting restore
RMAN-06102: no channel to restore a backup or copy of archived log for thread 1
with sequence 40233 and starting SCN of 179837183093