Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I get around recovering a data file that doesn't need to be??

844830May 13 2011 — edited May 16 2011
Sorry 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2011
Added on May 13 2011
19 comments
1,331 views