Recovery problem

From: Cheng-Jih Chen <cjc_at_interport.net>
Date: 18 May 1998 14:57:25 -0400
Message-ID: <6jq0al$dth$1@interport.net>

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 - 13:57:25 CDT