RMAN> @bilrman.sql

RMAN> connect target *
connected to target database: PMTBIL01 (DBID=483556544)

RMAN> connect auxiliary *
connected to auxiliary database: PMTBIL01 (not mounted)

RMAN>
RMAN> RUN {
2>
3>      ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
4>      ALLOCATE AUXILIARY CHANNEL CH2 TYPE 'SBT_TAPE';
5>      ALLOCATE AUXILIARY CHANNEL CH3 TYPE 'SBT_TAPE';
6>      ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';
7>
8>      SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,
9>           NSR_CLIENT=RHIS-CCBS-BILLDB-01.MTG.LOCAL)';
10>
11>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp01.dbf' to '/data/ora/PMTBIL01/u01//temp01.dbf';
12>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp03.dbf' to '/data/ora/PMTBIL01/u01//temp03.dbf';
13>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp04.dbf' to '/data/ora/PMTBIL01/u01//temp04.dbf';
14>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp05.dbf' to '/data/ora/PMTBIL01/u01//temp05.dbf';
15>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp06.dbf' to '/data/ora/PMTBIL01/u01//temp06.dbf';
16>      SET NEWNAME FOR TEMPFILE '/data/ora/PMTBIL01/u01/temp02.dbf' to '/data/ora/PMTBIL01/u01//temp02.dbf';
17>
18>      DUPLICATE TARGET DATABASE TO PMTBIL01
19>           PFILE = /exec/products/oracle/v10.2/dbs/initPMTBIL01.ora
20>           LOGFILE
21>                  GROUP 4 ('/data/ora/PMTBIL01/u01//redo4ardo', '/redo/PMTBIL01//redo4brdo') SIZE 524288000,
22>                  GROUP 5 ('/data/ora/PMTBIL01/u01//redo5ardo', '/redo/PMTBIL01//redo5brdo') SIZE 524288000,
23>                  GROUP 6 ('/data/ora/PMTBIL01/u01//redo6ardo', '/redo/PMTBIL01//redo6brdo') SIZE 524288000,
24>                  GROUP 7 ('/data/ora/PMTBIL01/u01//redo7ardo', '/redo/PMTBIL01//redo7brdo') SIZE 524288000,
25>                  GROUP 8 ('/data/ora/PMTBIL01/u01//redo8ardo', '/redo/PMTBIL01//redo8brdo') SIZE 524288000,
26>                  GROUP 9 ('/data/ora/PMTBIL01/u01//redo9ardo', '/redo/PMTBIL01//redo9brdo') SIZE 524288000;
27>
28> }
using target database control file instead of recovery catalog
allocated channel: CH1
channel CH1: sid=868 devtype=SBT_TAPE
channel CH1: NMDA Oracle v8.2.3

allocated channel: CH2
channel CH2: sid=869 devtype=SBT_TAPE
channel CH2: NMDA Oracle v8.2.3

allocated channel: CH3
channel CH3: sid=874 devtype=SBT_TAPE
channel CH3: NMDA Oracle v8.2.3

allocated channel: CH4
channel CH4: sid=872 devtype=SBT_TAPE
channel CH4: NMDA Oracle v8.2.3

sent command to channel: CH1
sent command to channel: CH2
sent command to channel: CH3
sent command to channel: CH4

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 20-DEC-16

contents of Memory Script:
{
   set until scn  141455230969;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  2 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  8 to new;
   set newname for clone datafile  9 to new;
   set newname for clone datafile  10 to new;
   set newname for clone datafile  11 to new;
   set newname for clone datafile  12 to new;
   set newname for clone datafile  13 to new;
   set newname for clone datafile  14 to new;
   set newname for clone datafile  15 to new;
   set newname for clone datafile  16 to new;
   set newname for clone datafile  17 to new;
   set newname for clone datafile  18 to new;
   set newname for clone datafile  19 to new;
   set newname for clone datafile  20 to new;
   set newname for clone datafile  21 to new;
   set newname for clone datafile  22 to new;
   set newname for clone datafile  23 to new;
   set newname for clone datafile  24 to new;
   set newname for clone datafile  25 to new;
   set newname for clone datafile  26 to new;
   set newname for clone datafile  27 to new;
   set newname for clone datafile  28 to new;
   set newname for clone datafile  29 to new;
   set newname for clone datafile  30 to new;
   set newname for clone datafile  31 to new;
   set newname for clone datafile  32 to new;
   set newname for clone datafile  33 to new;
   set newname for clone datafile  34 to new;
   set newname for clone datafile  35 to new;
   set newname for clone datafile  36 to new;
   set newname for clone datafile  37 to new;
   set newname for clone datafile  38 to new;
   set newname for clone datafile  39 to new;
   set newname for clone datafile  40 to new;
   set newname for clone datafile  41 to new;
   set newname for clone datafile  42 to new;
   set newname for clone datafile  43 to new;
   set newname for clone datafile  44 to new;
   set newname for clone datafile  45 to new;
   set newname for clone datafile  46 to new;
   set newname for clone datafile  47 to new;
   set newname for clone datafile  48 to new;
   set newname for clone datafile  49 to new;
   set newname for clone datafile  50 to new;
   set newname for clone datafile  51 to new;
   set newname for clone datafile  52 to new;
   set newname for clone datafile  53 to new;
   set newname for clone datafile  54 to new;
   set newname for clone datafile  55 to new;
   set newname for clone datafile  56 to new;
   set newname for clone datafile  57 to new;
   set newname for clone datafile  58 to new;
   set newname for clone datafile  59 to new;
   set newname for clone datafile  60 to new;
   set newname for clone datafile  61 to new;
   set newname for clone datafile  62 to new;
   set newname for clone datafile  63 to new;
   set newname for clone datafile  64 to new;
   set newname for clone datafile  65 to new;
   set newname for clone datafile  66 to new;
   set newname for clone datafile  67 to new;
   set newname for clone datafile  68 to new;
   set newname for clone datafile  69 to new;
   set newname for clone datafile  70 to new;
   set newname for clone datafile  71 to new;
   set newname for clone datafile  72 to new;
   set newname for clone datafile  73 to new;
   set newname for clone datafile  74 to new;
   set newname for clone datafile  75 to new;
   set newname for clone datafile  76 to new;
   set newname for clone datafile  77 to new;
   set newname for clone datafile  78 to new;
   set newname for clone datafile  80 to new;
   set newname for clone datafile  81 to new;
   set newname for clone datafile  82 to new;
   set newname for clone datafile  83 to new;
   set newname for clone datafile  84 to new;
   set newname for clone datafile  85 to new;
   set newname for clone datafile  86 to new;
   set newname for clone datafile  87 to new;
   set newname for clone datafile  88 to new;
   set newname for clone datafile  89 to new;
   set newname for clone datafile  90 to new;
   set newname for clone datafile  91 to new;
   set newname for clone datafile  92 to new;
   set newname for clone datafile  93 to new;
   set newname for clone datafile  94 to new;
   set newname for clone datafile  95 to new;
   set newname for clone datafile  96 to new;
   set newname for clone datafile  97 to new;
   set newname for clone datafile  98 to new;
   set newname for clone datafile  99 to new;
   set newname for clone datafile  100 to new;
   set newname for clone datafile  101 to new;
   set newname for clone datafile  102 to new;
   set newname for clone datafile  103 to new;
   set newname for clone datafile  104 to new;
   set newname for clone datafile  105 to new;
   set newname for clone datafile  106 to new;
   set newname for clone datafile  107 to new;
   set newname for clone datafile  108 to new;
   set newname for clone datafile  109 to new;
   set newname for clone datafile  110 to new;
   set newname for clone datafile  111 to new;
   set newname for clone datafile  112 to new;
   set newname for clone datafile  113 to new;
   set newname for clone datafile  114 to new;
   set newname for clone datafile  115 to new;
   set newname for clone datafile  116 to new;
   set newname for clone datafile  117 to new;
   set newname for clone datafile  118 to new;
   set newname for clone datafile  119 to new;
   set newname for clone datafile  120 to new;
   set newname for clone datafile  121 to new;
   set newname for clone datafile  122 to new;
   set newname for clone datafile  123 to new;
   set newname for clone datafile  124 to new;
   set newname for clone datafile  125 to new;
   set newname for clone datafile  126 to new;
   set newname for clone datafile  127 to new;
   set newname for clone datafile  132 to new;
   set newname for clone datafile  133 to new;
   set newname for clone datafile  134 to new;
   set newname for clone datafile  135 to new;
   set newname for clone datafile  136 to new;
   set newname for clone datafile  141 to new;
   set newname for clone datafile  142 to new;
   set newname for clone datafile  143 to new;
   set newname for clone datafile  144 to new;
   set newname for clone datafile  145 to new;
   set newname for clone datafile  146 to new;
   set newname for clone datafile  147 to new;
   set newname for clone datafile  148 to new;
   restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-DEC-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 12/20/2016 15:39:40
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 78 found to restore

RMAN> **end-of-file**

RMAN>