OraFAQ Forum: Backup & Recovery » Restore Control File from Backup

Home » RDBMS Server » Backup & Recovery » Restore Control File from Backup

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

Restore Control File from Backup [message #554843]

Thu, 17 May 2012 18:45

ajk3117
Messages: 1
Registered: May 2012

Junior Member

In order for the following command to work:

> recover database using backup control file until cancel;

what command must precede it, is it:

> alter database backup control file to trace;

Tony

Report message to a moderator

Re: Restore Control File from Backup [message #554844 is a reply to message #554843]

Thu, 17 May 2012 18:48

BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Restore Control File from Backup [message #554857 is a reply to message #554843]

Fri, 18 May 2012 00:45

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

Senior Member
Account Moderator

Quote:

is it:

No.

Regards
Michel

[Updated on: Fri, 18 May 2012 00:46]

Report message to a moderator

Re: Restore Control File from Backup [message #554860 is a reply to message #554843]

Fri, 18 May 2012 01:16

John Watson
Messages: 8461
Registered: January 2010
Location: Global Village

Senior Member

You must have restored a binary copy of the controlfile, made with
alter database backup controlfile to 'some_file_name';

Report message to a moderator

Re: Restore Control File from Backup [message #554861 is a reply to message #554860]

Fri, 18 May 2012 01:17

John Watson
Messages: 8461
Registered: January 2010
Location: Global Village

Senior Member

And, by the way, welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Report message to a moderator

Previous Topic:	ora-01194 file 1 needs more recovery to be consistentora-110
Next Topic:	recorvery DBF file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 27 17:28:41 CST 2021