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!

How can I get my DBID

tianaNov 12 2015 — edited Nov 12 2015

Hi, all,

I need to get the DBID of a database for a restore, here is what happened.

The below was executed by an idiot!

shutdown abort;

startup mount exclusive restrict;

drop database;

exit


... for testing purposes so he said...


Luckily for me, i had RMAN backup running but unfortunately the backups are on the same machine so now i can't seem to find the DBID anywhere. The naming convention for the autobackup controlfile is by OMF so no DBID there and to need to perform a restore.

Any help please?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2015
Added on Nov 12 2015
31 comments
25,214 views