My db totallyy stucked:
I do not have DB ID in backup log it was 2 weeks ago. I do now see any more that backup log on my terminal
How to determine DBID?
I accedently set some wrong DBID and now I can not open database at all.
How to determine DBID and please tell me what is the step after I do restore controlfile?
Edited by: 999170 on Apr 19, 2013 3:18 AM
DBID doesn't change..even if the backup log is 2 weeks old that DBID will be the same unless you changed it explicitly with NID tool etc.
post first 20 lines of that logfile.
Post error messages that you are getting.
how did you manage to post the LIST BACKUP command output? When you connected through RMAN to the database that time in firstfew lines DBID is shown.
Below is undocumented method:
bring the DB to nomount mode
then do the below steps
rman target /
RMAN>restore controlfile from '/opt/oracle/backup/std_0vo6morv_1_1';
RMAN>alter database mount;
RMAN>restore daatbase from '/opt/oracle/backup/std_0uo6morg_1_1';
RMAN>alter database open resetlogs;
You need to set the correct DBID before you RESTORE CONTROLFILE.
After the RESTORE CONTROLFILE, you need to RESTORE DATABASE (and, after that, RECOVER DATABASE). If you are doing a Point In Time Recovery or an Incomplete Recovery, you need to SET UNTIL before the RECOVER DATABASE.
Hemant K Chitale