Oracle Database Restore fails with Error 0xe0001501 "specified backup object was not found in Backup Exec Catalogs"

Posted on 2011-09-26
Last Modified: 2012-05-12
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 - Production

 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 RUN {
 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\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to E:\ORACLE\ORADATA\SKY2000\RBS01.DBF
RMAN-08523: restoring datafile 00003 to E:\ORACLE\ORADATA\SKY2000\USERS01.DBF
RMAN-08523: restoring datafile 00004 to E:\ORACLE\ORADATA\SKY2000\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to E:\ORACLE\ORADATA\SKY2000\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to E:\ORACLE\ORADATA\SKY2000\INDX01.DBF
RMAN-08523: restoring datafile 00007 to E:\ORACLE\ORADATA\SKY2000\AVOUCH_DATA1.ORA
RMAN-08523: restoring datafile 00008 to E:\ORACLE\ORADATA\SKY2000\AVOUCH_DATA2.ORA
RMAN-08523: restoring datafile 00009 to E:\ORACLE\ORADATA\SKY2000\AVOUCH_DATA3.ORA
RMAN-08523: restoring datafile 00010 to E:\ORACLE\ORADATA\SKY2000\AVOUCH_DATA4.ORA
RMAN-08523: restoring datafile 00011 to E:\ORACLE\ORADATA\SKY2000\LMSDATA7.ORA
RMAN-08523: restoring datafile 00012 to E:\ORACLE\ORADATA\SKY2000\LMSDATA1.ORA
RMAN-08523: restoring datafile 00013 to E:\ORACLE\ORADATA\SKY2000\LMSDATA2.ORA
RMAN-08523: restoring datafile 00014 to E:\ORACLE\ORADATA\SKY2000\LMSDATA3.ORA
RMAN-08523: restoring datafile 00015 to E:\ORACLE\ORADATA\SKY2000\LMSDATA4.ORA
RMAN-08523: restoring datafile 00016 to E:\ORACLE\ORADATA\SKY2000\LMSDATA5.ORA
RMAN-08523: restoring datafile 00017 to E:\ORACLE\ORADATA\SKY2000\LMSDATA6.ORA
RMAN-08523: restoring datafile 00018 to E:\ORACLE\ORADATA\SKY2000\TEMP_LARGE.ORA
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.RESTOREBACKUPPIECE

Recovery Manager complete.

Question by:jlaurice
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 500 total points
ID: 36709192
Not a Backup Exec person but sine no other Expert has posted I'm responding to a Neglected Question alert.

Did you already look at this:

Check availability of space on the drive where restore is going.
Alternative Method
Use RMAN to restore
Find the string "db_create_file_destination" used by RMAN for restore and remove it

Author Comment

ID: 36710942
The destination for the restore has plenty of space.
As far as the alternative method, I am not sure where I would look for that string since the restore is being done by Backup Exec, which calls RMAN.  
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36711179
My guess is that Backup Exec is executing a script file and they are wanting you to edit that script and execute RMAN manually.

Author Comment

ID: 36893715
I am unaware of where Symantec would keep that script.
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36893766
From the little I can find on that it appears it is actually an old 8i init.ora parameter.

Try removing it from there.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question