Just a test Env.
Archived log mode
Warm backup user01.dbf
missed one leading archived log.
copy back user01.dbf
SVRMGR> recover datafile '/export/home/oracle/oradata/fun/users01.dbf';
ORA-00279: change 59576 generated at 06/16/2004 16:29:54 needed for thread 1
ORA-00289: suggestion : /export/home/oracle/orafile/product/8.1.7/dbs/arch1_450.dbf
ORA-00280: change 59576 for thread 1 is in sequence #450
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/export/home/oracle/orafile/product/8.1.7/dbs/arch1_449.dbf
ORA-00310: archived log contains sequence 449; sequence 450 required
ORA-00334: archived log: '/export/home/oracle/orafile/product/8.1.7/dbs/arch1_449.dbf'
---
I admit it is impossible to replay logs with one missed log file.
But i just want to recover data in datafile without replay logs ,Is it possible?
Thanks!!
Archived log mode
Warm backup user01.dbf
missed one leading archived log.
copy back user01.dbf
SVRMGR> recover datafile '/export/home/oracle/oradata/fun/users01.dbf';
ORA-00279: change 59576 generated at 06/16/2004 16:29:54 needed for thread 1
ORA-00289: suggestion : /export/home/oracle/orafile/product/8.1.7/dbs/arch1_450.dbf
ORA-00280: change 59576 for thread 1 is in sequence #450
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/export/home/oracle/orafile/product/8.1.7/dbs/arch1_449.dbf
ORA-00310: archived log contains sequence 449; sequence 450 required
ORA-00334: archived log: '/export/home/oracle/orafile/product/8.1.7/dbs/arch1_449.dbf'
---
I admit it is impossible to replay logs with one missed log file.
But i just want to recover data in datafile without replay logs ,Is it possible?
Thanks!!