Unsolved
This post is more than 5 years old
101 Posts
0
616
Recovering an Oracle Control File
Hi all,
I want to recover an Oracle Control File, I have some doubts about how to configure the RMAN script, here i drop the details of the Oracle client:
>Oracle 10.2
>NetWorker 7.4.3
>NMO 4.2
The backups is managed only by Control File, there is not RMAN Catalog DB installed.
I never had to recover the control file, only recovered datafiles and DDBB, i wrote this script based in the scripts i use for DDBB recovers but i don't know if it is correct or i'm missing something:
SCRIPT |
---|
connect target sys/change_on_install@pro run { set until time='6/09/2009 13:01:36'; allocate channel t1 type 'SBT_TAPE' parms 'ENV= (NSR_SERVER=backup_server_name,NSR_CLIENT=client_name); restore controlfile; release channel t1; } |
Thanks in advance for your help.
coganb
736 Posts
0
April 28th, 2010 00:00
looks ok to me - did it work?
-Bobby
axavier1
76 Posts
0
April 28th, 2010 10:00
Hi,
I´m not a DBA but I guess this link will help you:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov.htm#i1006245
In nmo logs you can see the backups piece or using nsrinfo.
Regards,
Anderson Xavier