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.