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,169 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 77

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

Author Comment

by:jlaurice
ID: 36893715
I am unaware of where Symantec would keep that script.
0
 
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
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…

808 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