Start a Conversation

Unsolved

This post is more than 5 years old

616

April 27th, 2010 04:00

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.

736 Posts

April 28th, 2010 00:00

looks ok to me - did it work?

-Bobby

76 Posts

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

No Events found!

Top