Recover datafile error - cannot find spec seqence # in archive log

From: <schang7_at_my-deja.com>
Date: Tue, 14 Dec 1999 22:05:00 GMT
Message-ID: <836etv$p7d$1@nnrp1.deja.com>

Hi,
The list below were the errors I got when trying to recover a datafile

SVRMGR> recover datafile 'f:\history\history.ora'; ORA-00279: Change 525082216 generated at 12/08/99 16:24:02 needed for thread 1
ORA-00289: Suggestion : d:\ORANT\RDBMS73\%ORACLE_SID%25290.001 ORA-00280: Change 525082216 for thread 1 is in sequence #252904 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00310: archived log contains sequence 252909; sequence 252904 required
ORA-00334: archived log: 'D:\ORANT\RDBMS73\ORCL25290.001'

I try auto, <RET> and event the suggested log file orcl25290.001 and still could not recover the datafile. It seems the recover program cannot find the specific sequence # in the log file! Any suggestion?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 16:05:00 CST