Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recover impossible?with a missed link in archvied log

Status
Not open for further replies.

StraightL

MIS
Jun 7, 2004
13
AU
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!!
 
Nope. You need an uninterrupted redo log thread from the time the file was backed up to the point you wish to recover to.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top