cancel
Showing results for 
Search instead for 
Did you mean: 

Failed oracle restore

Liffeyman
Level 3

Folks,

Trying to complete a oracle DB restore, we have setup the test environment using the following article http://www.symantec.com/business/support/index?page=content&id=TECH60371

The DB script is returning the following error when the restore is kicked off

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Oct 8 16:54:53 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=10.1.1.211,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={79C3A9F6-383D-46E5-95FA-2E4230BB970C},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\MFACTUPGORC64.ds.local\MFACT,NBBSA_SOURCE_MACHINE_NAME=Mfact-Live.ds.local';
 
 RESTORE CONTROLFILE FROM 'BE_ocnli9q5_1_1';
 
 ALTER DATABASE MOUNT;
 
 RESTORE
     DATABASE;
 
 RECOVER
     DATABASE;
 
 RELEASE CHANNEL ch0;
 alter database open resetlogs;
 }
 
connected to target database: MFACT (not mounted)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=155 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 08-OCT-12

released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/08/2012 16:54:54
ORA-27191: sbtinfo2 returned error

Recovery Manager complete.

thanks

Paul

 

1 ACCEPTED SOLUTION

Accepted Solutions

Lilavati
Level 4
Employee

 

1) Please make sure that you have installed RAWS on destination machine

2) Configured Remote Agent Utility on destination server too (Oracle and Database Access tab)

3) Added destination server in modify list on media server, 

Note: If you are using backup exec 2010 then modify list is available in Tool-Option menu

If it is BE 2012 then it is available in configuration settings-Backup Exec settings

Thanks,

Lilavati

View solution in original post

2 REPLIES 2

Sush---
Level 6
Employee Accredited Certified

Hello Paul,

   Please refer to the following technote 

 http://www.symantec.com/docs/TECH65542 : Redirect restore of Oracle database(s) fails with the Error 0xe0000340

 

Thanks,

-Sush...

Lilavati
Level 4
Employee

 

1) Please make sure that you have installed RAWS on destination machine

2) Configured Remote Agent Utility on destination server too (Oracle and Database Access tab)

3) Added destination server in modify list on media server, 

Note: If you are using backup exec 2010 then modify list is available in Tool-Option menu

If it is BE 2012 then it is available in configuration settings-Backup Exec settings

Thanks,

Lilavati