OraFAQ Forum: Backup & Recovery » Control files dropped

Home » RDBMS Server » Backup & Recovery » Control files dropped (oracle 10 g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control files dropped [message #502871]

Mon, 11 April 2011 04:02

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:41:33 CDT 2024