| how to know the DBID ? [message #401110] |
Fri, 01 May 2009 12:29  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
RMAN> set dbid = 1213359295;
RMAN> restore controlfile;
^^
I tried this on Oracle 9i and OS as Windows.
It seems restore of controlfile is only possible after setting the DBID ?
So how does one know the DBID if there is alread a problem with the Database instance (or its controlfile) ?
The DBID does get shown in :
select dbid from v$database; << doesnt help
rman target / << doesnt help here also, as this is when the instance is running fine ?
Whats the way to get in a extreme situation ?
|
|
|
|
|
|
| Re: how to know the DBID ? [message #401116 is a reply to message #401110] |
Fri, 01 May 2009 12:45  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
From your backup logs assuming you have enabled controlfile autobackup.
Starting Control File and SPFILE Autobackup at APR 30 2009 22:22:42
piece handle=/backup/xxx/snapcf/c-1166811531-20090430-00 comment=NONE
Finished Control File and SPFILE Autobackup at APR 30 2009 22:23:13
>>c-1166811531-20090430-00
Bolded text is the DBID.
[Updated on: Fri, 01 May 2009 12:49] Report message to a moderator |
|
|
|
| Re: how to know the DBID ? [message #401137 is a reply to message #401110] |
Fri, 01 May 2009 14:59 |
satishnawle
Messages: 3
Registered: May 2009
|
Junior Member |
|
|
Dear
There is no need to set DB ID , just connect to target database and fire RMAN>restore controlfile otherwise RMAN>restore controlfile from '.snap ' file location file is present on oracle_home/dbs
Satish Nawle
+919222130789
|
|
|
|
|
|
| Re: how to know the DBID ? [message #401195 is a reply to message #401141] |
Sat, 02 May 2009 04:57 |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
Yes. What Mahesh states is correct.
Thats why I made this post. I was trying this and it asked for the DBID to be set in RMAN without which the controlfile would not be restored.
--
SO my question remains : How would I know this considering my database is crashed (ie. controlfiles are lost/corrupt) ?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
