Home » RDBMS Server » Backup & Recovery » Control files dropped (oracle 10 g)
icon14.gif  Control files dropped [message #502871] Mon, 11 April 2011 04:02 Go to next message
sdanj2003
Messages: 2
Registered: March 2011
Location: Ranchi
Junior Member
During an experiment on my testing database installed on window xp i first took the backup of the whole database with the configuration of auto backup of the control files. I deleted the control files.
When going on rman tool again as the database is in the nomount stage.I hane no dbid as I forgot to note dbid number when i connected to rman during the backup time.
I can't find the dbid from v$database as database is in nomount stage.
Can i still retrieve my dbid so as to find my database online and running.

Thanks in Advance.

Report message to a moderator

Re: Control files dropped [message #502874 is a reply to message #502871] Mon, 11 April 2011 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you did not specify a format on your backup then you have the dbid in the backup names.

Regards
Michel

Report message to a moderator

Re: Control files dropped [message #502875 is a reply to message #502874] Mon, 11 April 2011 04:14 Go to previous messageGo to next message
sdanj2003
Messages: 2
Registered: March 2011
Location: Ranchi
Junior Member
dear friend i tried to find but in which folder and from where i can get it.

Regards.

Report message to a moderator

Re: Control files dropped [message #502878 is a reply to message #502875] Mon, 11 April 2011 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't know what "it" refers to.

Regards
Michel

Report message to a moderator

Re: Control files dropped [message #502880 is a reply to message #502871] Mon, 11 April 2011 04:42 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
-if you had not explicitly set controlfile autobackup location you can find autobackups in default location
-you can find backup piece name in the logfile of the backup you had run

Report message to a moderator

Re: Control files dropped [message #503214 is a reply to message #502880] Wed, 13 April 2011 10:06 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Search for this autobackup file in the oracle home directory. try using the name of your database in the search parameter

Report message to a moderator

Previous Topic: restore database
Next Topic: RMAN from Feb 28th
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 04 06:22:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.