Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-09-26
5
Medium Priority
?
1,241 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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 78

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 78

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
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…
Suggested Courses

578 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