ORA-01194: file 1 needs more recovery to be consistent
Hi guys.
Ran a duplicate that failed after applying full, incr and then about 6 archive logs...
I just want to get the database open, don't care about losing the data.
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
Tried:
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1687171004 generated at 01/07/2010 10:58:26 needed for thread
1
ORA-00289: suggestion : /u01/arch/vcost/arch_1_3.arc
ORA-00280: change 1687171004 for thread 1 is in sequence #3
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u02/oradata/vcost/system01.dbf'
ORA-01112: media recovery not started
SQL> recover datafile '/u02/oradata/vcost/system01.dbf';
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
How can I get this db open?
Thanks
Jamie