Database recovery dilemma. Our database server was reconfigured, we
restored from the most recent backup and issued the 'recover database using
backup controlfile;' command, stepped through applying the Archive Logs,
but at the end of the archive logs I get this message.

*************************************
SQL> recover database using backup controlfile;
ORA-00279: change 55753613 generated at 06/22/2002 18:53:45 needed for
thread 1
ORA-00289: suggestion : D:\ORACLE\ORA81\RDBMS\ARC05863.001
ORA-00280: change 55753613 for thread 1 is in sequence #5863


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\CSL\ODHC\ODDATA\SYS.ORA'


ORA-01112: media recovery not started
*************************************

It is telling the truth, if I do a 'alter database open resetlogs' it just
responds with that bit about the SYS.ORA file needing more recovery.


There are no more Archive Logs to apply. Any ideas??????

Some things we have tried, without success:

- recover database using backup controlfile until time
'2002-06-22:17:00:00';
- We have restored a older copy of the control file and ran 'recover
database' without success.


>

Oracle LazyDBA home page