Skip to Main Content

Database Software

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!

Restore problem - how to get rid of corrupt database ?

910524Jan 13 2012 — edited Jan 14 2012
Folks,

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.
This post has been answered by tychos on Jan 14 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 11 2012
Added on Jan 13 2012
6 comments
1,836 views