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

In article <385757b9.2997531_at_news.cis.dfn.de>,   stojentin_at_orgdv.din.de wrote:
> 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
>

The log_archive_format paramater did not exist in the init.ora. I checked all archive files and found all log files were in sid+6digit.001 format.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 19:11:57 CST