I accidentally the whole database
user9038Apr 21 2009 — edited Apr 21 2009Lately 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.