Forum Discussion

Liffeyman's avatar
Liffeyman
Level 3
13 years ago

Failed oracle restore

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

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

  •  

    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