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!

I accidentally the whole database

user9038Apr 21 2009 — edited Apr 21 2009
Lately our development database had some hiccups (archivelog destination was full or sth), but I didn't really pay attention, because it's development DB (we had to use rman delete archive log all and it was ok).
The data is not important, the only real value is the schema and we have that in another database, so the situation is not critical.

So, today I wanted to do the routine again, but screwed something in the process. I don't know exactly what, where and when I clicked, but I know I did click "perform recovery" a few times in the EM. I think one of the times it was trying to perform restore from backup (I have no idea how old that backup was).

Now i'm stuck with

ERROR at line 1:
ORA-01113: file 1 needs media recovery
'/u01/app/oracle/product/11.1.0/db_1/oradata/oradb/system01.dbf'

I suspect the backup was performed from a really old backup files. I think I do have current archivelogs.

Is there any way to simply recover the database? I do have other options, we do have create scripts etc., but just want to know it I can do anything.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2009
Added on Apr 21 2009
6 comments
654 views