Re: Recovery problem

It's possible that the change Oracle is looking for is in the online redo logs and has not been archived. Let's say you have logs 100-200 on disk. During recovery, Oracle asks for log 201, but that file doesn' t exist. Simply tell Oracle to use the current online redo log as the next log. Now, when Oracle asks for 202, reply with CANCEL.

The following steps may help you down the right path to fixing your problem.

First, do you have auto archving set TRUE? If so, things will be easier. Assuming you have auto archiving set TRUE, run the following command from Server Manager:

    select a.member, b.status from v$logfile a, v$log b where a.group# = b.group#;

This will show you the online redo log that is the "current" one.

Now run your recover command again and when Oracle asks for an archive log it cannot find, you reply with the name of the current online redo log displayed in the above query.

Hope this helps a little.

-Michael

Cheng-Jih Chen wrote:

> Hi, I'm trying to do a recover on a test server, and am getting this
> 'ORA-01113: file 1 needs media recovery' error when I try to open the
> database. All redo logs have been applied.
>
> SVRMGR> recover database using backup controlfile;
> ORA-00279: Change 66200338 generated at 04/07/98 18:58:04 needed for thread 1
> ORA-00289: Suggestion : /export/ria4a/archive01/arch/1_215520.dbf
> ORA-00280: Change 66200338 for thread 1 is in sequence #215520
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> [...]
>
> ORA-00279: Change 66250056 generated at 04/08/98 07:33:13 needed for thread 1
> 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'
>
> Any idea why this is happening? Ways to make the error go away?
>
> Thanks.
> --
Received on Mon May 18 1998 - 14:53:26 CDT