Restore problem - how to get rid of corrupt database ?
910524Jan 13 2012 — edited Jan 14 2012Folks,
Some dumb developer managed to trash on of our Oracle database by doing a mistake in SQLDev.
This database was / is using the "autobackup" feature as proposed in the installation wizard.
For some reason it would seem that the restore is not complete, tough.
I get an error when mounting the database
ORA-01248: file 5 was created in the future of incomplete recovery
ORA-01110: data file 5: <path to file>
not sure to understand what happened but I can live without that specific database assuming the others are ok.
Any advise as of how to get rid of that specific database and enjoy the rest of the server ?!
Nest step will be to understand why autobackup is not doing what it is supposed to do...
This is Oracle 11g standard on Oracle Linux.