09-27-2011 11:11 AM
Oracle Database Restore fails with Error 0xe0001501 "specified backup object was not found in Backup Exec Catalogs"
I am using Symantec Backup Exec 12.5 to restore an Oracle 8i database which was backed up from server ABC, to server XYZ. I get the error above.
Below is my RMAN Output:
Recovery Manager: Release 8.1.7.4.1 - Production
# --------------------------
# RMAN command section
# --------------------------
RUN {
ALLOCATE CHANNEL ch0
TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=192.168.
RESTORE
DATABASE;
RECOVER
DATABASE;
RELEASE CHANNEL ch0;
alter database open;
}
RMAN-06005: connected to target database: SKY2000 (DBID=3532803791)
RMAN-06009: using target database controlfile instead of recovery catalog
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch0
RMAN-08500: channel ch0: sid=11 devtype=SBT_TAPE
RMAN-08526: channel ch0: Symantec/BackupExec/1.1.0
RMAN-03022: compiling command: send
RMAN-06421: sent command to channel: ch0
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch0: starting datafile backupset restore
RMAN-08502: set_count=19 set_stamp=731883693 creation_time=08-OCT-10
RMAN-08089: channel ch0: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00002 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00003 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00004 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00005 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00006 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00007 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00008 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00009 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00010 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00011 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00012 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00013 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00014 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00015 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00016 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00017 to E:\ORACLE\ORADATA\SKY2000\
RMAN-08523: restoring datafile 00018 to E:\ORACLE\ORADATA\SKY2000\
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch0
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="BE_0jlpva5d_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: BEError(0xe0001501) The specified backup object was not found in Backup Exec catalogs.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOR
Recovery Manager complete.