Hi All,
I currently am backing up an oracle rac instance in our production environment using the oracle agent and get a sucessful backup. Windows 2008 is the os with backup exec 12.5 with oracle 10g on the database server cluster. To restore the data, I have a dr site with a windows 2008 server with backup exec 12.5 and a standalone oracle 10g server. When I atempt to restore the data I get the following error:
allocated channel: ch0
channel ch0: SID=151 device type=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
sent command to channel: ch0
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
Starting restore at 17-DEC-09
channel ch0: looking for AUTOBACKUP on day: 20091217
channel ch0: AUTOBACKUP found: c-665481463-20091217-04
channel ch0: restoring control file from AUTOBACKUP c-665481463-20091217-04
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/17/2009 23:35:33
ORA-19870: error while restoring backup piece c-665481463-20091217-04
ORA-19507: failed to retrieve sequential file, handle="c-665481463-20091217-04",
parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
BEError(0xe0001405) Unknown CORBA exception. Unable to contact the media serv
er. Confirm that the Backup Exec Job Engine service is running on the media serv
er.RUN {
2> ALLOCATE CHANNEL ch0
3> TYPE 'SBT_TAPE';
4> SEND 'BSA_SERVICE_HOST=10.220.0.161,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={
C8FC598F-0DED-4A50-B4D5-3C03AF7C7F71},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\MCSGTMS
DR\gtmsni,NBBSA_SOURCE_MACHINE_NAME=RAC-gtmsni-665481463';
5> set controlfile autobackup format for device type 'sbt_tape' to '%F';
6> restore controlfile from autobackup MAXSEQ 5 MAXDAYS 9;
7> mount database;
8> }
Can the restore of a rac instance be performed to a single oracle box. Has anyone out there had sucess restoring from oracle rac to single instance before. Any help would be greatly appreciated.
Regards,
pgala