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,205 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
[X]
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
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

622 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