Re: Recovery problem

From: Wladislav Ovchinnikov <wlad_at_cbsd.donetsk.ua>
Date: Wed, 20 May 1998 10:56:32 +0300
Message-ID: <35628CB0.5806AB0F@cbsd.donetsk.ua>

Since last change# is incorrect when using BACKUP CONTROLFILE the better way is to add 'UNYIL TIME... ' or 'UNTIL CHANGE ...' clause to ALTER DATABASE command. In other case database 'thinks' that not all logs are applied.

> > SVRMGR> recover database using backup controlfile;
> > ORA-00279: Change 66200338 generated at 04/07/98 18:58:04 needed for thread
> 1

[skip]
> > ORA-00289: Suggestion : /export/ria4a/archive01/arch/1_215711.dbf
> > ORA-00280: Change 66250056 for thread 1 is in sequence #215711
> > ORA-00278: Logfile '/export/ria4a/archive01/arch/1_215710.dbf' no longer
> needed for this recovery
> > ORA-00308: cannot open archived log
> '/export/ria4a/archive01/arch/1_215711.dbf'
> > ORA-07360: sfifi: stat error, unable to obtain information about file.
> > SVR4 Error: 2: No such file or directory
> > SVRMGR> alter database open resetlogs;
> > alter database open resetlogs
> > *
> > ORA-01113: file 1 needs media recovery
> > ORA-01110: data file 1: '/export/ria4a/data01/system01.dbf'

Wladislav Ovchinnikov, DBA
Donetskaya direktsiya Ukrsotsbanka
Donetsk, Ukraine

e-mail: wlad_at_cbsd.donetsk.ua Received on Wed May 20 1998 - 02:56:32 CDT