Forum Discussion

xzcsiwh's avatar
14 years ago

BE 12.5 restore oracle controlfile in Windows

1. the device name parameter:

i have a oracle rac runs in windows and use BE 12.5 backup the db without the catalog, now i want to restore the db control file in other win machine which install the BE agent by running a rman script .

the script:

set dbid=111111111111
RUN {
 ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=w2003-1,NBBSA_TOTAL_STREAMS=1,
 NBBSA_DB_DEVICE_NAME=Oracle-Win::\\target1\test,NBBSA_SOURCE_MACHINE_NAME=RAC-test-11111111111'
 RESTORE CONTROLFILE TO 'd:\control01.ctl1' FROM 'BE_abcdefsa_1_1';
 RELEASE CHANNEL ch0;
}

 

when i run the " rman target \ cmdfile=script", the scripts hung in " channel ch0: restoring the control file...", and i would login in the backup server and open the backup exec, double click the restore task, and select the device from the device list. Does the BE has a parameter which can set the device name?

 

2. How can i get the BE backup oracle rman script? i want to know the backup autobackup setting.

Then I run the belows scripts, and the rman can not find the valid autobackup set in the 7days.

set dbid=111111111111
RUN {
 ALLOCATE CHANNEL ch0 TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=w2003-1,NBBSA_TOTAL_STREAMS=1,
 NBBSA_DB_DEVICE_NAME=Oracle-Win::\\target1\test,NBBSA_SOURCE_MACHINE_NAME=RAC-test-11111111111'
  set controlfile autobackup format for device type 'sbt_tape' to '%F';
 RESTORE CONTROLFILE TO 'd:\control01.ctl1' FROM autobackup ;
 RELEASE CHANNEL ch0;
}

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece.

 

 

No RepliesBe the first to reply