1.startup mount and issue 'recover using backup controlfile until cancel'
2.when prompted for D:\ORACLE\ORA81\RDBMS\ARC05863.001, type name of current
redo log . Maybe you will have to try which one it is.

Reason: shutdown abort was performed. Required recovery contains
transactions in online redo logs not yet applied to database. And at least
current online redo log was not archived


If the data is critical:
try setting the parameter "_allow_resetlogs_corruption" to TRUE in the
init.ora and performing the steps you did earlier.
If the database does come up , then take an export immediately and rebuild
the database.(not sure what level of corruption this might cause)
============================================================================
=======================

HTHU

Ankur Shah
Oracle DBA
DHR-GA



----- Original Message -----
From: Tom Schruefer <[Email Address Removed] LazyDBA.com Discussion <[Email Address Removed] June 28, 2002 10:22 AM
Subject: HELP: Oracle Database Recovery Problem


> 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
Oracle LazyDBA home page