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

On Tue, 14 Dec 1999 22:05:00 GMT, schang7_at_my-deja.com wrote:

>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'
>

Hi,

the logfile names are strange, they should have one digit more. The filename for Sequence 252904 is really ORCL25290.001?

Take a look at the filesystem and check if the filenames are ORCL252900.001 .. ORCL2529009.001. If they are with 6 digits you can overwrite the suggested filename when promted by the recovery process.

If the names are only with 5 digits it may be possible that the archiver has overwrite the logfiles, because the names are too short (all files ORCL252900.001 .. ORCL2529009.001 are mapped to one).

Check the init.ora paramater for log_archive_format. If there are so much log switches use "%S" instead of "%s".

Fred Stojentin Received on Wed Dec 15 1999 - 03:12:22 CST