Login  Register

RMAN backup

Posted by Roshan on Oct 11, 2016; 10:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-backup-tp1369.html

Hello Erman,

we are performing a restore from a backup from Networker. It generated the RMAN script after we configured networker. The source(target) is 10.210.27.101 and destination is 10.210.27.104.

The script is shown below:
connect target sys/M@PMTCC01;
connect auxiliary /;

RUN {

     ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH2 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH3 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';

     SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,
          NSR_CLIENT=RHIS-CCBS-BILLDB-01.MTG.LOCAL)';

     SET NEWNAME FOR TEMPFILE '/data/ora/PMTCC01/temp01.dbf' to '/data/ora/PMTCC01//temp01.dbf';

     DUPLICATE TARGET DATABASE TO PMTCC01
          PFILE = /exec/products/oracle/v10.2/dbs/initPMTCC01.ora
          LOGFILE
                 GROUP 1 ('/data/ora/PMTCC01//redo01a.rdo', '/redo/PMTCC01//redo01b.rdo') SIZE 268435456,
                 GROUP 2 ('/data/ora/PMTCC01//redo02a.rdo', '/redo/PMTCC01//redo02b.rdo') SIZE 268435456,
                 GROUP 3 ('/data/ora/PMTCC01//redo03a.rdo', '/data/PMTCC01//redo03b.rdo') SIZE 268435456
          NOFILENAMECHECK;

}


We have encountered the error shown below:
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-OCT-16

released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/11/2016 14:22:44
RMAN-03015: error occurred in stored script Memory Script
ORA-27191: sbtinfo2 returned error
Additional information: 2

Thanks,
Roshan