Home » RDBMS Server » Backup & Recovery » how to know the DBID ?
how to know the DBID ? [message #401110] Fri, 01 May 2009 12:29 Go to next message
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 #401115 is a reply to message #401110] Fri, 01 May 2009 12:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the following topic: How to discover DBID having RMAN backup files

Regards
Michel
Re: how to know the DBID ? [message #401116 is a reply to message #401110] Fri, 01 May 2009 12:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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 #401141 is a reply to message #401137] Fri, 01 May 2009 15:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>There is no need to set DB ID , just connect to target database
Not true always.

Quoting docs.
Quote:

Because the repository is not available when you restore the control file, you must use the SET DBID command to identify the target database.
Re: how to know the DBID ? [message #401195 is a reply to message #401141] Sat, 02 May 2009 04:57 Go to previous messageGo to next message
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) ?
Re: how to know the DBID ? [message #401196 is a reply to message #401195] Sat, 02 May 2009 06:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>How would I know this considering my database is crashed (ie. controlfiles are lost/corrupt) ?

Did you consider reading the methods described in URL posted by Michel
Or
Just what I posted?
Re: how to know the DBID ? [message #401211 is a reply to message #401196] Sat, 02 May 2009 11:34 Go to previous message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Sorry i missed looking at that link.


referred it now

thx.
Previous Topic: clone db from datafiles
Next Topic: recovery manually in case of corrupt RMAN
Goto Forum:
  


Current Time: Tue Dec 06 02:53:57 CST 2016

Total time taken to generate the page: 0.05772 seconds