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