Solved

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

Posted on 2011-09-26
5
1,144 Views
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 8.1.7.4.1 - Production

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=192.168.1.7,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={1D68C1A3-0F9A-4C47-886A-D50E3215CF38},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\SKYORABACK2\Sky2000,NBBSA_SOURCE_MACHINE_NAME=SKYORACLE';
 
 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\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.

0
Comment
Question by:jlaurice
  • 3
  • 2
5 Comments
 
LVL 76

Accepted Solution

by:
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:
http://www.symantec.com/business/support/index?page=content&id=TECH61527

Solution
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
0
 

Author Comment

by:jlaurice
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.  
0
 
LVL 76

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.
0
 

Author Comment

by:jlaurice
ID: 36893715
I am unaware of where Symantec would keep that script.
0
 
LVL 76

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.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now