OraFAQ Forum: Backup & Recovery » restore controlfile issue

Home » RDBMS Server » Backup & Recovery » restore controlfile issue (10.2.0.1)

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

restore controlfile issue [message #534876]

Fri, 09 December 2011 21:17

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I want to restore control file from backup set,just as the flowing command,where location does the control file be restored to? how can i spfecify the location when restore control file?

restore controlfile from '/u01/rman_backup/mybak/df_768589733_7_1.bak';

Report message to a moderator

Re: restore controlfile issue [message #534886 is a reply to message #534876]

Fri, 09 December 2011 23:50

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe using TO clause?
In normal restore you have not to specify where you have to restore it, RMAN knows it from your init.ora or spfile.

Regards
Michel

Report message to a moderator

Re: restore controlfile issue [message #534942 is a reply to message #534886]

Sat, 10 December 2011 09:25

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks Michel,
To clause can do it.

restore controlfile to 'E:\oracle\product\10.2.0\oradata\acf\control01.ctl' 
from 'E:\OracleBacup\ACFCTL_ACF_20080904_222.CTL';

Report message to a moderator

Previous Topic:	log file concept in oracle
Next Topic:	obselete backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 12 04:19:02 CDT 2026