Home » RDBMS Server » Backup & Recovery » Restore Control File from Backup
Restore Control File from Backup [message #554843] Thu, 17 May 2012 18:45 Go to next message
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
Re: Restore Control File from Backup [message #554844 is a reply to message #554843] Thu, 17 May 2012 18:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
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/
Re: Restore Control File from Backup [message #554857 is a reply to message #554843] Fri, 18 May 2012 00:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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';
Re: Restore Control File from Backup [message #554861 is a reply to message #554860] Fri, 18 May 2012 01:17 Go to previous message
John Watson
Messages: 8922
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
Previous Topic: ora-01194 file 1 needs more recovery to be consistentora-110
Next Topic: recorvery DBF file
Goto Forum:
  


Current Time: Fri Mar 29 04:09:41 CDT 2024