How can I get around recovering a data file that doesn't need to be??
844830May 13 2011 — edited May 16 2011Sorry I am opening a new thread, but this is the biggest emergency of my 20+ year career.
Oracle 11g
1) redo logs were deleted
2) We don't do backups of the database. It is only used to demo our product, it is not a prod database
3) To get around the problem of the redo logs (which caused Oracle not able to start) I rebuilt the control file with the RESETLOGS option on
Now, when I try to start the database and open it with alter database open resetlogs; I get this:
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oradata/orcl/system01.dbf'
I don't understand why it wants this and I have no idea to get around it. I don't know what to recover FROM as I already said there are no backups. But why should I have to recover anything, there never was any data loss, only the redo logs were deleted. Why can't I just tell Oracle to forget the recovery, the data files are fine?