Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Failed oracle restore

Created: 09 Oct 2012 | 2 comments

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?pag...

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

 

Comments 2 CommentsJump to latest comment

Sush...'s picture

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

Hope this piece of Information Helps you... and if it does then mark this response as Solution....!!!

Lilavati's picture

 

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