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

It seems it is looking for the scn 525082216 in sequence 252904 which is not found in the archived log orcl25290.001. Do you have a full set of archived log files before you perform the recovery? How about perform an incomplete recovery until scn = 525082215 and check if it prompts error.

John Chiu

<schang7_at_my-deja.com> wrote in message news:836etv$p7d$1_at_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 - 22:56:04 CST