Oracle Database Discussions

Hello DBA's

I need some advice if the database can be recovered in the below scenario? Using Oracle 11G R2 on a Windows box.

This is a test db and can be dropped and rebuild but wondered if its possible to recover it?

The database in archive log mode. Backed the entire database except redo logs (I know not a good idea)

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'E:\ORADATA\ORCL\SYSTEM01.DBF'


SQL> recover database using backup controlfile;
ORA-00279: change 2064228 generated at 05/29/2011 20:05:18 needed for thread 1
ORA-00289: suggestion : E:\ORADATA\BACKUP\ARC0000000006_0752442994.0001
ORA-00280: change 2064228 for thread 1 is in sequence #6


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


Now there is no archive for sequence 6 for this so assume it's still in redo, which is not there. How do I recover it?

Note- I've got consistent archives from seq 1 to 5. but I assume its not needed.

Your advice is much appreciated.

Regards,

Edited by: nickn on May 30, 2011 4:55 AM