Re: Recovery problem

1. Maybe you did not copy your backup file for system01.dbf before you make your recovery. You have to do this, because you have to start with recovery always in the past.
2. If the error appears contingously you may want to try this. Be careful. Backup your database before! Set init.ora parameter _allow_resetlogs_corruption=true startup with open resetlogs shutdown delete this init.ora parameter Maybe your database is then corrupt.

In article <6jq0al$dth$1_at_interport.net>,   cjc_at_interport.net (Cheng-Jih Chen) wrote:
>
> >
> 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}
>
> 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.

> [...]
>
> 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.
> --
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 19 1998 - 03:37:00 CDT