Restoring Oracle Database From a Cold Backup on a new Server.

Step #0:
Set up the Oracle Code Tree.


cd $ORACLE_HOME/clone/bin
perl clone.pl ORACLE_HOME="/u002/app/oracle/product/11.2.0/db_1" ORACLE_HOME_NAME="TST_ORACLE_HOME" ORACLE_SID="TST" ORACLE_BASE="/u002/app/oracle"
inventory_loc=/u002/app/oracle/oraInventory
inst_group=dba
export ORACLE_HOME=/u002/app/oracle/product/11.2.0/db_1
export ORACLE_SID=uhcmtst
export ORACLE_BASE=/u002/app/oracle
export PATH=$PATH:$ORACLE_HOME/bin/.
export PATH=$PATH:$ORACLE_HOME/OPatch/.
/u008/app/oradata/uhcmtst/controlfiles
/u008/app/oradata/uhcmtst/datafiles
/u008/app/oradata/uhcmtst/redologfiles




Ensure that you have a VALID cold backup. The cold backup mentioned here is obtained by using RMAN in mount mode on a 11g Database.

Step #1:
Restore the Control Files




[oracle@dvpsaixdb02us] controlfiles $ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Wed Nov 8 07:00:47 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: UHCMTST (not mounted)
RMAN> restore controlfile from '/u008/app/oradata/rman_cold/cold_bk_cntrl_39_1_953457271';
Starting restore at 08-NOV-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=958 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/u008/app/oradata/uhcmtst/controlfiles/controlfile_uhcmtst_01.ctl
output file name=/u008/app/oradata/uhcmtst/controlfiles/controlfile_uhcmtst_02.ctl
Finished restore at 08-NOV-17
RMAN>








Step #2:
Mount the db

RMAN> alter database mount;
using target database control file instead of recovery catalog
database mounted

Step #3:
Gather the relevant Information & Restore the COLD Backup of the Database




select GROUP#,MEMBER from v$logfile;
    GROUP# MEMBER
---------- -------------------------------------------
         3 /u001/app/oradata/uhcmtst/redo03a.log
         3 /u001/app/oradata/uhcmtst/redo03b.log
         2 /u001/app/oradata/uhcmtst/redo02a.log
         2 /u001/app/oradata/uhcmtst/redo02b.log
         1 /u001/app/oradata/uhcmtst/redo01a.log
         1 /u001/app/oradata/uhcmtst/redo01b.log

select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u001/app/oradata/uhcmtst/temp01.dbf
/u001/app/oradata/uhcmtst/pstemp01.dbf
/u001/app/oradata/uhcmtst/pstemp02.dbf
/u001/app/oradata/uhcmtst/pstemp03.dbf
/u001/app/oradata/uhcmtst/pstemp04.dbf



 select file#,name from v$datafile;
     FILE# NAME
---------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         1 /u001/app/oradata/uhcmtst/system01.dbf
         2 /u001/app/oradata/uhcmtst/sysaux01.dbf
         3 /u001/app/oradata/uhcmtst/undotbs01.dbf
         4 /u001/app/oradata/uhcmtst/users01.dbf
         5 /u001/app/oradata/uhcmtst/psdefault.dbf
         6 /u001/app/oradata/uhcmtst/psindex.dbf
         7 /u001/app/oradata/uhcmtst/tllarge.dbf
         8 /u001/app/oradata/uhcmtst/ptapp.dbf
         9 /u001/app/oradata/uhcmtst/tlapp.dbf
        10 /u001/app/oradata/uhcmtst/hrsapp.dbf
        11 /u001/app/oradata/uhcmtst/gpapp.dbf
        12 /u001/app/oradata/uhcmtst/pswork.dbf
        13 /u001/app/oradata/uhcmtst/ptlock.dbf
        14 /u001/app/oradata/uhcmtst/ptamsg.dbf
        15 /u001/app/oradata/uhcmtst/ptappe.dbf
        16 /u001/app/oradata/uhcmtst/pttlrg.dbf
        17 /u001/app/oradata/uhcmtst/pttree.dbf
        18 /u001/app/oradata/uhcmtst/ptwork.dbf
        19 /u001/app/oradata/uhcmtst/ptcmstar.dbf
        20 /u001/app/oradata/uhcmtst/ptprjwk.dbf
        21 /u001/app/oradata/uhcmtst/ptaudit.dbf
        22 /u001/app/oradata/uhcmtst/psimgr.dbf
        23 /u001/app/oradata/uhcmtst/aaapp.dbf
        24 /u001/app/oradata/uhcmtst/aalarge.dbf
        25 /u001/app/oradata/uhcmtst/adapp.dbf
        26 /u001/app/oradata/uhcmtst/amapp.dbf
        27 /u001/app/oradata/uhcmtst/avapp.dbf
        28 /u001/app/oradata/uhcmtst/bdapp.dbf
        29 /u001/app/oradata/uhcmtst/bnapp.dbf
        30 /u001/app/oradata/uhcmtst/psimage.dbf
        31 /u001/app/oradata/uhcmtst/ccapp.dbf
        32 /u001/app/oradata/uhcmtst/coapp.dbf
        33 /u001/app/oradata/uhcmtst/cuaudit.dbf
        34 /u001/app/oradata/uhcmtst/cularg1.dbf
        35 /u001/app/oradata/uhcmtst/cularg2.dbf
        36 /u001/app/oradata/uhcmtst/cularg3.dbf
        37 /u001/app/oradata/uhcmtst/cularge.dbf
        38 /u001/app/oradata/uhcmtst/diapp.dbf
        39 /u001/app/oradata/uhcmtst/dtapp.dbf
        40 /u001/app/oradata/uhcmtst/eoapp.dbf
        41 /u001/app/oradata/uhcmtst/eobfapp.dbf
        42 /u001/app/oradata/uhcmtst/eocfapp.dbf
        43 /u001/app/oradata/uhcmtst/eocmapp.dbf
        44 /u001/app/oradata/uhcmtst/eocmlrg.dbf
        45 /u001/app/oradata/uhcmtst/eocmwrk.dbf
        46 /u001/app/oradata/uhcmtst/eocuapp.dbf
        47 /u001/app/oradata/uhcmtst/eoculrg.dbf
        48 /u001/app/oradata/uhcmtst/eodsapp.dbf
        49 /u001/app/oradata/uhcmtst/eodslrg.dbf
        50 /u001/app/oradata/uhcmtst/eoecapp.dbf
        51 /u001/app/oradata/uhcmtst/eoeclrg.dbf
        52 /u001/app/oradata/uhcmtst/eoecwrk.dbf
        53 /u001/app/oradata/uhcmtst/eoeiapp.dbf
        54 /u001/app/oradata/uhcmtst/eoeilrg.dbf
        55 /u001/app/oradata/uhcmtst/eoewapp.dbf
        56 /u001/app/oradata/uhcmtst/eoewlrg.dbf
        57 /u001/app/oradata/uhcmtst/eoewwrk.dbf
        58 /u001/app/oradata/uhcmtst/eoiuapp.dbf
        59 /u001/app/oradata/uhcmtst/eoiulrg.dbf
        60 /u001/app/oradata/uhcmtst/eoiuwrk.dbf
        61 /u001/app/oradata/uhcmtst/eolarge.dbf
        62 /u001/app/oradata/uhcmtst/eoltapp.dbf
        63 /u001/app/oradata/uhcmtst/eoppapp.dbf
        64 /u001/app/oradata/uhcmtst/eopplrg.dbf
        65 /u001/app/oradata/uhcmtst/eotpapp.dbf
        66 /u001/app/oradata/uhcmtst/eotplrg.dbf
        67 /u001/app/oradata/uhcmtst/epapp.dbf
        68 /u001/app/oradata/uhcmtst/eplarge.dbf
        69 /u001/app/oradata/uhcmtst/erapp.dbf
        70 /u001/app/oradata/uhcmtst/erlarge.dbf
        71 /u001/app/oradata/uhcmtst/erwork.dbf
        72 /u001/app/oradata/uhcmtst/faapp.dbf
        73 /u001/app/oradata/uhcmtst/falarge.dbf
        74 /u001/app/oradata/uhcmtst/fgapp.dbf
        75 /u001/app/oradata/uhcmtst/fglarge.dbf
        76 /u001/app/oradata/uhcmtst/fsapp.dbf
        77 /u001/app/oradata/uhcmtst/giapp.dbf
        78 /u001/app/oradata/uhcmtst/py0lrg.dbf
        79 /u001/app/oradata/uhcmtst/gpdeapp.dbf
        80 /u001/app/oradata/uhcmtst/hpapp.dbf
        81 /u001/app/oradata/uhcmtst/hrapp.dbf
        82 /u001/app/oradata/uhcmtst/pttbl.dbf
        83 /u001/app/oradata/uhcmtst/hrapp2.dbf
        84 /u001/app/oradata/uhcmtst/hrapp3.dbf
        85 /u001/app/oradata/uhcmtst/hrapp4.dbf
        86 /u001/app/oradata/uhcmtst/hrapp5.dbf
        87 /u001/app/oradata/uhcmtst/hrapp6.dbf
        88 /u001/app/oradata/uhcmtst/hrapp7.dbf
        89 /u001/app/oradata/uhcmtst/hrimage.dbf
        90 /u001/app/oradata/uhcmtst/hrlarg1.dbf
        91 /u001/app/oradata/uhcmtst/bnlarge.dbf
        92 /u001/app/oradata/uhcmtst/ptrpts.dbf
        93 /u001/app/oradata/uhcmtst/hrsarch.dbf
        94 /u001/app/oradata/uhcmtst/hrslarge.dbf
        95 /u001/app/oradata/uhcmtst/hrswork.dbf
        96 /u001/app/oradata/uhcmtst/hrwork.dbf
        97 /u001/app/oradata/uhcmtst/htapp.dbf
        98 /u001/app/oradata/uhcmtst/inapp.dbf
        99 /u001/app/oradata/uhcmtst/paapp.dbf
       100 /u001/app/oradata/uhcmtst/palarge.dbf
       101 /u001/app/oradata/uhcmtst/pcapp.dbf
       102 /u001/app/oradata/uhcmtst/pclarge.dbf
       103 /u001/app/oradata/uhcmtst/piapp.dbf
       104 /u001/app/oradata/uhcmtst/pilarge.dbf
       105 /u001/app/oradata/uhcmtst/piwork.dbf
       106 /u001/app/oradata/uhcmtst/poapp.dbf
       107 /u001/app/oradata/uhcmtst/pvapp.dbf
       108 /u001/app/oradata/uhcmtst/ptprc.dbf
       109 /u001/app/oradata/uhcmtst/pyapp.dbf
       110 /u001/app/oradata/uhcmtst/pylarge.dbf
       111 /u001/app/oradata/uhcmtst/pywork.dbf
       112 /u001/app/oradata/uhcmtst/saapp.dbf
       113 /u001/app/oradata/uhcmtst/sacapp.dbf
       114 /u001/app/oradata/uhcmtst/salarge.dbf
       115 /u001/app/oradata/uhcmtst/srapp.dbf
       116 /u001/app/oradata/uhcmtst/stapp.dbf
       117 /u001/app/oradata/uhcmtst/stlarge.dbf
       118 /u001/app/oradata/uhcmtst/stwork.dbf
       119 /u001/app/oradata/uhcmtst/hrapp1.dbf
       120 /u001/app/oradata/uhcmtst/taapp.dbf
       121 /u001/app/oradata/uhcmtst/tlwork.dbf
       122 /u001/app/oradata/uhcmtst/hrlarge.dbf
       123 /u001/app/oradata/uhcmtst/waapp.dbf
       124 /u001/app/oradata/uhcmtst/psresume.dbf
       125 /u001/app/oradata/uhcmtst/BPELUSER1.dbf
       126 /u001/app/oradata/uhcmtst/sysaux02.dbf
       127 /u001/app/oradata/uhcmtst/psindex_01.dbf
       128 /u001/app/oradata/uhcmtst/undotbs02.dbf
       129 /u001/app/oradata/uhcmtst/sysaux03.dbf
       130 /u001/app/oradata/uhcmtst/psimage01.dbf
       131 /u001/app/oradata/uhcmtst/sysaux04.dbf
       132 /u001/app/oradata/uhcmtst/sysaux05.dbf
       133 /u001/app/oradata/uhcmtst/psindex_02.dbf
       134 /u001/app/oradata/uhcmtst/sysaux06.dbf
134 rows selected.


Above are the details of the backup on the OLD server, now we have the datafile mount point on /u008. Hence we need to set new names to the datafile and once copied, we need to change the contents or entries in the control file by doing a "switch datafile copy". The following tasks will help you achieve the same. Follow it step by step.




1) Execute the SQL
select 'set new name for datafile '||file#||' to '''||name||''';' from v$datafile;
2) Copy the Contents on to a text file.
3) perl -p -i -e 's!u001!u008!g' datafile.txt
4) perl -p -i -e 's!uhcmtst!uhcmtst/datafiles!g' datafile.txt
5) Execute the SQL
select 'set newname for tempfile '||file#||' to '''||name||''';' from v$tempfile;
6) perl -p -i -e 's!u001!u008!g' tempfile.txt
7) perl -p -i -e 's!uhcmtst!uhcmtst/tempfiles!g' tempfile.txt
8) use the above information to create the restoration script as below.


== Create the restoration script ==
run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
set newname for datafile 1 to '/u008/app/oradata/uhcmtst/datafiles/system01.dbf';
set newname for datafile 2 to '/u008/app/oradata/uhcmtst/datafiles/sysaux01.dbf';
set newname for datafile 3 to '/u008/app/oradata/uhcmtst/datafiles/undotbs01.dbf';
set newname for datafile 4 to '/u008/app/oradata/uhcmtst/datafiles/users01.dbf';
set newname for datafile 5 to '/u008/app/oradata/uhcmtst/datafiles/psdefault.dbf';
set newname for datafile 6 to '/u008/app/oradata/uhcmtst/datafiles/psindex.dbf';
set newname for datafile 7 to '/u008/app/oradata/uhcmtst/datafiles/tllarge.dbf';
set newname for datafile 8 to '/u008/app/oradata/uhcmtst/datafiles/ptapp.dbf';
set newname for datafile 9 to '/u008/app/oradata/uhcmtst/datafiles/tlapp.dbf';
set newname for datafile 10 to '/u008/app/oradata/uhcmtst/datafiles/hrsapp.dbf';
set newname for datafile 11 to '/u008/app/oradata/uhcmtst/datafiles/gpapp.dbf';
set newname for datafile 12 to '/u008/app/oradata/uhcmtst/datafiles/pswork.dbf';
set newname for datafile 13 to '/u008/app/oradata/uhcmtst/datafiles/ptlock.dbf';
set newname for datafile 14 to '/u008/app/oradata/uhcmtst/datafiles/ptamsg.dbf';
set newname for datafile 15 to '/u008/app/oradata/uhcmtst/datafiles/ptappe.dbf';
set newname for datafile 16 to '/u008/app/oradata/uhcmtst/datafiles/pttlrg.dbf';
set newname for datafile 17 to '/u008/app/oradata/uhcmtst/datafiles/pttree.dbf';
set newname for datafile 18 to '/u008/app/oradata/uhcmtst/datafiles/ptwork.dbf';
set newname for datafile 19 to '/u008/app/oradata/uhcmtst/datafiles/ptcmstar.dbf';
set newname for datafile 20 to '/u008/app/oradata/uhcmtst/datafiles/ptprjwk.dbf';
set newname for datafile 21 to '/u008/app/oradata/uhcmtst/datafiles/ptaudit.dbf';
set newname for datafile 22 to '/u008/app/oradata/uhcmtst/datafiles/psimgr.dbf';
set newname for datafile 23 to '/u008/app/oradata/uhcmtst/datafiles/aaapp.dbf';
set newname for datafile 24 to '/u008/app/oradata/uhcmtst/datafiles/aalarge.dbf';
set newname for datafile 25 to '/u008/app/oradata/uhcmtst/datafiles/adapp.dbf';
set newname for datafile 26 to '/u008/app/oradata/uhcmtst/datafiles/amapp.dbf';
set newname for datafile 27 to '/u008/app/oradata/uhcmtst/datafiles/avapp.dbf';
set newname for datafile 28 to '/u008/app/oradata/uhcmtst/datafiles/bdapp.dbf';
set newname for datafile 29 to '/u008/app/oradata/uhcmtst/datafiles/bnapp.dbf';
set newname for datafile 30 to '/u008/app/oradata/uhcmtst/datafiles/psimage.dbf';
set newname for datafile 31 to '/u008/app/oradata/uhcmtst/datafiles/ccapp.dbf';
set newname for datafile 32 to '/u008/app/oradata/uhcmtst/datafiles/coapp.dbf';
set newname for datafile 33 to '/u008/app/oradata/uhcmtst/datafiles/cuaudit.dbf';
set newname for datafile 34 to '/u008/app/oradata/uhcmtst/datafiles/cularg1.dbf';
set newname for datafile 35 to '/u008/app/oradata/uhcmtst/datafiles/cularg2.dbf';
set newname for datafile 36 to '/u008/app/oradata/uhcmtst/datafiles/cularg3.dbf';
set newname for datafile 37 to '/u008/app/oradata/uhcmtst/datafiles/cularge.dbf';
set newname for datafile 38 to '/u008/app/oradata/uhcmtst/datafiles/diapp.dbf';
set newname for datafile 39 to '/u008/app/oradata/uhcmtst/datafiles/dtapp.dbf';
set newname for datafile 40 to '/u008/app/oradata/uhcmtst/datafiles/eoapp.dbf';
set newname for datafile 41 to '/u008/app/oradata/uhcmtst/datafiles/eobfapp.dbf';
set newname for datafile 42 to '/u008/app/oradata/uhcmtst/datafiles/eocfapp.dbf';
set newname for datafile 43 to '/u008/app/oradata/uhcmtst/datafiles/eocmapp.dbf';
set newname for datafile 44 to '/u008/app/oradata/uhcmtst/datafiles/eocmlrg.dbf';
set newname for datafile 45 to '/u008/app/oradata/uhcmtst/datafiles/eocmwrk.dbf';
set newname for datafile 46 to '/u008/app/oradata/uhcmtst/datafiles/eocuapp.dbf';
set newname for datafile 47 to '/u008/app/oradata/uhcmtst/datafiles/eoculrg.dbf';
set newname for datafile 48 to '/u008/app/oradata/uhcmtst/datafiles/eodsapp.dbf';
set newname for datafile 49 to '/u008/app/oradata/uhcmtst/datafiles/eodslrg.dbf';
set newname for datafile 50 to '/u008/app/oradata/uhcmtst/datafiles/eoecapp.dbf';
set newname for datafile 51 to '/u008/app/oradata/uhcmtst/datafiles/eoeclrg.dbf';
set newname for datafile 52 to '/u008/app/oradata/uhcmtst/datafiles/eoecwrk.dbf';
set newname for datafile 53 to '/u008/app/oradata/uhcmtst/datafiles/eoeiapp.dbf';
set newname for datafile 54 to '/u008/app/oradata/uhcmtst/datafiles/eoeilrg.dbf';
set newname for datafile 55 to '/u008/app/oradata/uhcmtst/datafiles/eoewapp.dbf';
set newname for datafile 56 to '/u008/app/oradata/uhcmtst/datafiles/eoewlrg.dbf';
set newname for datafile 57 to '/u008/app/oradata/uhcmtst/datafiles/eoewwrk.dbf';
set newname for datafile 58 to '/u008/app/oradata/uhcmtst/datafiles/eoiuapp.dbf';
set newname for datafile 59 to '/u008/app/oradata/uhcmtst/datafiles/eoiulrg.dbf';
set newname for datafile 60 to '/u008/app/oradata/uhcmtst/datafiles/eoiuwrk.dbf';
set newname for datafile 61 to '/u008/app/oradata/uhcmtst/datafiles/eolarge.dbf';
set newname for datafile 62 to '/u008/app/oradata/uhcmtst/datafiles/eoltapp.dbf';
set newname for datafile 63 to '/u008/app/oradata/uhcmtst/datafiles/eoppapp.dbf';
set newname for datafile 64 to '/u008/app/oradata/uhcmtst/datafiles/eopplrg.dbf';
set newname for datafile 65 to '/u008/app/oradata/uhcmtst/datafiles/eotpapp.dbf';
set newname for datafile 66 to '/u008/app/oradata/uhcmtst/datafiles/eotplrg.dbf';
set newname for datafile 67 to '/u008/app/oradata/uhcmtst/datafiles/epapp.dbf';
set newname for datafile 68 to '/u008/app/oradata/uhcmtst/datafiles/eplarge.dbf';
set newname for datafile 69 to '/u008/app/oradata/uhcmtst/datafiles/erapp.dbf';
set newname for datafile 70 to '/u008/app/oradata/uhcmtst/datafiles/erlarge.dbf';
set newname for datafile 71 to '/u008/app/oradata/uhcmtst/datafiles/erwork.dbf';
set newname for datafile 72 to '/u008/app/oradata/uhcmtst/datafiles/faapp.dbf';
set newname for datafile 73 to '/u008/app/oradata/uhcmtst/datafiles/falarge.dbf';
set newname for datafile 74 to '/u008/app/oradata/uhcmtst/datafiles/fgapp.dbf';
set newname for datafile 75 to '/u008/app/oradata/uhcmtst/datafiles/fglarge.dbf';
set newname for datafile 76 to '/u008/app/oradata/uhcmtst/datafiles/fsapp.dbf';
set newname for datafile 77 to '/u008/app/oradata/uhcmtst/datafiles/giapp.dbf';
set newname for datafile 78 to '/u008/app/oradata/uhcmtst/datafiles/py0lrg.dbf';
set newname for datafile 79 to '/u008/app/oradata/uhcmtst/datafiles/gpdeapp.dbf';
set newname for datafile 80 to '/u008/app/oradata/uhcmtst/datafiles/hpapp.dbf';
set newname for datafile 81 to '/u008/app/oradata/uhcmtst/datafiles/hrapp.dbf';
set newname for datafile 82 to '/u008/app/oradata/uhcmtst/datafiles/pttbl.dbf';
set newname for datafile 83 to '/u008/app/oradata/uhcmtst/datafiles/hrapp2.dbf';
set newname for datafile 84 to '/u008/app/oradata/uhcmtst/datafiles/hrapp3.dbf';
set newname for datafile 85 to '/u008/app/oradata/uhcmtst/datafiles/hrapp4.dbf';
set newname for datafile 86 to '/u008/app/oradata/uhcmtst/datafiles/hrapp5.dbf';
set newname for datafile 87 to '/u008/app/oradata/uhcmtst/datafiles/hrapp6.dbf';
set newname for datafile 88 to '/u008/app/oradata/uhcmtst/datafiles/hrapp7.dbf';
set newname for datafile 89 to '/u008/app/oradata/uhcmtst/datafiles/hrimage.dbf';
set newname for datafile 90 to '/u008/app/oradata/uhcmtst/datafiles/hrlarg1.dbf';
set newname for datafile 91 to '/u008/app/oradata/uhcmtst/datafiles/bnlarge.dbf';
set newname for datafile 92 to '/u008/app/oradata/uhcmtst/datafiles/ptrpts.dbf';
set newname for datafile 93 to '/u008/app/oradata/uhcmtst/datafiles/hrsarch.dbf';
set newname for datafile 94 to '/u008/app/oradata/uhcmtst/datafiles/hrslarge.dbf';
set newname for datafile 95 to '/u008/app/oradata/uhcmtst/datafiles/hrswork.dbf';
set newname for datafile 96 to '/u008/app/oradata/uhcmtst/datafiles/hrwork.dbf';
set newname for datafile 97 to '/u008/app/oradata/uhcmtst/datafiles/htapp.dbf';
set newname for datafile 98 to '/u008/app/oradata/uhcmtst/datafiles/inapp.dbf';
set newname for datafile 99 to '/u008/app/oradata/uhcmtst/datafiles/paapp.dbf';
set newname for datafile 100 to '/u008/app/oradata/uhcmtst/datafiles/palarge.dbf';
set newname for datafile 101 to '/u008/app/oradata/uhcmtst/datafiles/pcapp.dbf';
set newname for datafile 102 to '/u008/app/oradata/uhcmtst/datafiles/pclarge.dbf';
set newname for datafile 103 to '/u008/app/oradata/uhcmtst/datafiles/piapp.dbf';
set newname for datafile 104 to '/u008/app/oradata/uhcmtst/datafiles/pilarge.dbf';
set newname for datafile 105 to '/u008/app/oradata/uhcmtst/datafiles/piwork.dbf';
set newname for datafile 106 to '/u008/app/oradata/uhcmtst/datafiles/poapp.dbf';
set newname for datafile 107 to '/u008/app/oradata/uhcmtst/datafiles/pvapp.dbf';
set newname for datafile 108 to '/u008/app/oradata/uhcmtst/datafiles/ptprc.dbf';
set newname for datafile 109 to '/u008/app/oradata/uhcmtst/datafiles/pyapp.dbf';
set newname for datafile 110 to '/u008/app/oradata/uhcmtst/datafiles/pylarge.dbf';
set newname for datafile 111 to '/u008/app/oradata/uhcmtst/datafiles/pywork.dbf';
set newname for datafile 112 to '/u008/app/oradata/uhcmtst/datafiles/saapp.dbf';
set newname for datafile 113 to '/u008/app/oradata/uhcmtst/datafiles/sacapp.dbf';
set newname for datafile 114 to '/u008/app/oradata/uhcmtst/datafiles/salarge.dbf';
set newname for datafile 115 to '/u008/app/oradata/uhcmtst/datafiles/srapp.dbf';
set newname for datafile 116 to '/u008/app/oradata/uhcmtst/datafiles/stapp.dbf';
set newname for datafile 117 to '/u008/app/oradata/uhcmtst/datafiles/stlarge.dbf';
set newname for datafile 118 to '/u008/app/oradata/uhcmtst/datafiles/stwork.dbf';
set newname for datafile 119 to '/u008/app/oradata/uhcmtst/datafiles/hrapp1.dbf';
set newname for datafile 120 to '/u008/app/oradata/uhcmtst/datafiles/taapp.dbf';
set newname for datafile 121 to '/u008/app/oradata/uhcmtst/datafiles/tlwork.dbf';
set newname for datafile 122 to '/u008/app/oradata/uhcmtst/datafiles/hrlarge.dbf';
set newname for datafile 123 to '/u008/app/oradata/uhcmtst/datafiles/waapp.dbf';
set newname for datafile 124 to '/u008/app/oradata/uhcmtst/datafiles/psresume.dbf';
set newname for datafile 125 to '/u008/app/oradata/uhcmtst/datafiles/BPELUSER1.dbf';
set newname for datafile 126 to '/u008/app/oradata/uhcmtst/datafiles/sysaux02.dbf';
set newname for datafile 127 to '/u008/app/oradata/uhcmtst/datafiles/psindex_01.dbf';
set newname for datafile 128 to '/u008/app/oradata/uhcmtst/datafiles/undotbs02.dbf';
set newname for datafile 129 to '/u008/app/oradata/uhcmtst/datafiles/sysaux03.dbf';
set newname for datafile 130 to '/u008/app/oradata/uhcmtst/datafiles/psimage01.dbf';
set newname for datafile 131 to '/u008/app/oradata/uhcmtst/datafiles/sysaux04.dbf';
set newname for datafile 132 to '/u008/app/oradata/uhcmtst/datafiles/sysaux05.dbf';
set newname for datafile 133 to '/u008/app/oradata/uhcmtst/datafiles/psindex_02.dbf';
set newname for datafile 134 to '/u008/app/oradata/uhcmtst/datafiles/sysaux06.dbf';
set newname for tempfile 2 to '/u008/app/oradata/uhcmtst/tempfiles/temp01.dbf';
set newname for tempfile 6 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp01.dbf';
set newname for tempfile 7 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp02.dbf';
set newname for tempfile 8 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp03.dbf';
set newname for tempfile 9 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp04.dbf';
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03a.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03b.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02a.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02b.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01a.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01b.log'' ";
restore database;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
}




9)Copy the above into a sql file as "restore"
10)Create a shell script "rman_restore.sh" with contents as "rman target / @restore" or use the detailed shell script below to obtain logs.




rman target /
catalog start with '/u008/app/oradata/rman_cold';

== output ==

RMAN> catalog start with '/u008/app/oradata/rman_cold';
Starting implicit crosscheck backup at 08-NOV-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=958 device type=DISK
Crosschecked 38 objects
Finished implicit crosscheck backup at 08-NOV-17
Starting implicit crosscheck copy at 08-NOV-17
using channel ORA_DISK_1
Finished implicit crosscheck copy at 08-NOV-17
searching for all files in the recovery area
cataloging files...
no files cataloged
searching for all files that match the pattern /u008/app/oradata/rman_cold
List of Files Unknown to the Database
=====================================
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_11sd8hkd_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_12sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_13sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_14sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_15sd94a1_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_16sd94aa_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_cntrl_39_1_953457271
File Name: /u008/app/oradata/rman_cold/cold_bk_spfile_40_1_953457275
File Name: /u008/app/oradata/rman_cold/nohup.out
File Name: /u008/app/oradata/rman_cold/rman.sh
File Name: /u008/app/oradata/rman_cold/rman.sql
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_11sd8hkd_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_12sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_13sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_14sd8hke_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_15sd94a1_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_16sd94aa_1_1
File Name: /u008/app/oradata/rman_cold/cold_bk_cntrl_39_1_953457271
File Name: /u008/app/oradata/rman_cold/cold_bk_spfile_40_1_953457275



11) Now execute rman_restore.sh

#!/usr/bin/ksh

export ORACLE_SID=uhcmtst;
export ORACLE_HOME=/u002/app/oracle/product/11.2.0/db_1;
export PATH=$PATH:$ORACLE_HOME/bin;
rman log=/u008/app/oradata/rman_cold/rman_restore_${ORACLE_SID}.log<<EOF
@/u008/app/oradata/rman_cold/restore
exit;
EOF


Execute the script above and find the below contents of the log file.



cat rman_restore_uhcmtst.log
Recovery Manager: Release 11.2.0.2.0 - Production on Wed Nov 8 09:51:53 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: UHCMTST (DBID=2737752116, not open)
RMAN> run
2> {
3> allocate channel ch1 device type disk;
4> allocate channel ch2 device type disk;
5> allocate channel ch3 device type disk;
6> allocate channel ch4 device type disk;
7> set newname for datafile 1 to '/u008/app/oradata/uhcmtst/datafiles/system01.dbf';
8> set newname for datafile 2 to '/u008/app/oradata/uhcmtst/datafiles/sysaux01.dbf';
9> set newname for datafile 3 to '/u008/app/oradata/uhcmtst/datafiles/undotbs01.dbf';
10> set newname for datafile 4 to '/u008/app/oradata/uhcmtst/datafiles/users01.dbf';
11> set newname for datafile 5 to '/u008/app/oradata/uhcmtst/datafiles/psdefault.dbf';
12> set newname for datafile 6 to '/u008/app/oradata/uhcmtst/datafiles/psindex.dbf';
13> set newname for datafile 7 to '/u008/app/oradata/uhcmtst/datafiles/tllarge.dbf';
14> set newname for datafile 8 to '/u008/app/oradata/uhcmtst/datafiles/ptapp.dbf';
15> set newname for datafile 9 to '/u008/app/oradata/uhcmtst/datafiles/tlapp.dbf';
16> set newname for datafile 10 to '/u008/app/oradata/uhcmtst/datafiles/hrsapp.dbf';
17> set newname for datafile 11 to '/u008/app/oradata/uhcmtst/datafiles/gpapp.dbf';
18> set newname for datafile 12 to '/u008/app/oradata/uhcmtst/datafiles/pswork.dbf';
19> set newname for datafile 13 to '/u008/app/oradata/uhcmtst/datafiles/ptlock.dbf';
20> set newname for datafile 14 to '/u008/app/oradata/uhcmtst/datafiles/ptamsg.dbf';
21> set newname for datafile 15 to '/u008/app/oradata/uhcmtst/datafiles/ptappe.dbf';
22> set newname for datafile 16 to '/u008/app/oradata/uhcmtst/datafiles/pttlrg.dbf';
23> set newname for datafile 17 to '/u008/app/oradata/uhcmtst/datafiles/pttree.dbf';
24> set newname for datafile 18 to '/u008/app/oradata/uhcmtst/datafiles/ptwork.dbf';
25> set newname for datafile 19 to '/u008/app/oradata/uhcmtst/datafiles/ptcmstar.dbf';
26> set newname for datafile 20 to '/u008/app/oradata/uhcmtst/datafiles/ptprjwk.dbf';
27> set newname for datafile 21 to '/u008/app/oradata/uhcmtst/datafiles/ptaudit.dbf';
28> set newname for datafile 22 to '/u008/app/oradata/uhcmtst/datafiles/psimgr.dbf';
29> set newname for datafile 23 to '/u008/app/oradata/uhcmtst/datafiles/aaapp.dbf';
30> set newname for datafile 24 to '/u008/app/oradata/uhcmtst/datafiles/aalarge.dbf';
31> set newname for datafile 25 to '/u008/app/oradata/uhcmtst/datafiles/adapp.dbf';
32> set newname for datafile 26 to '/u008/app/oradata/uhcmtst/datafiles/amapp.dbf';
33> set newname for datafile 27 to '/u008/app/oradata/uhcmtst/datafiles/avapp.dbf';
34> set newname for datafile 28 to '/u008/app/oradata/uhcmtst/datafiles/bdapp.dbf';
35> set newname for datafile 29 to '/u008/app/oradata/uhcmtst/datafiles/bnapp.dbf';
36> set newname for datafile 30 to '/u008/app/oradata/uhcmtst/datafiles/psimage.dbf';
37> set newname for datafile 31 to '/u008/app/oradata/uhcmtst/datafiles/ccapp.dbf';
38> set newname for datafile 32 to '/u008/app/oradata/uhcmtst/datafiles/coapp.dbf';
39> set newname for datafile 33 to '/u008/app/oradata/uhcmtst/datafiles/cuaudit.dbf';
40> set newname for datafile 34 to '/u008/app/oradata/uhcmtst/datafiles/cularg1.dbf';
41> set newname for datafile 35 to '/u008/app/oradata/uhcmtst/datafiles/cularg2.dbf';
42> set newname for datafile 36 to '/u008/app/oradata/uhcmtst/datafiles/cularg3.dbf';
43> set newname for datafile 37 to '/u008/app/oradata/uhcmtst/datafiles/cularge.dbf';
44> set newname for datafile 38 to '/u008/app/oradata/uhcmtst/datafiles/diapp.dbf';
45> set newname for datafile 39 to '/u008/app/oradata/uhcmtst/datafiles/dtapp.dbf';
46> set newname for datafile 40 to '/u008/app/oradata/uhcmtst/datafiles/eoapp.dbf';
47> set newname for datafile 41 to '/u008/app/oradata/uhcmtst/datafiles/eobfapp.dbf';
48> set newname for datafile 42 to '/u008/app/oradata/uhcmtst/datafiles/eocfapp.dbf';
49> set newname for datafile 43 to '/u008/app/oradata/uhcmtst/datafiles/eocmapp.dbf';
50> set newname for datafile 44 to '/u008/app/oradata/uhcmtst/datafiles/eocmlrg.dbf';
51> set newname for datafile 45 to '/u008/app/oradata/uhcmtst/datafiles/eocmwrk.dbf';
52> set newname for datafile 46 to '/u008/app/oradata/uhcmtst/datafiles/eocuapp.dbf';
53> set newname for datafile 47 to '/u008/app/oradata/uhcmtst/datafiles/eoculrg.dbf';
54> set newname for datafile 48 to '/u008/app/oradata/uhcmtst/datafiles/eodsapp.dbf';
55> set newname for datafile 49 to '/u008/app/oradata/uhcmtst/datafiles/eodslrg.dbf';
56> set newname for datafile 50 to '/u008/app/oradata/uhcmtst/datafiles/eoecapp.dbf';
57> set newname for datafile 51 to '/u008/app/oradata/uhcmtst/datafiles/eoeclrg.dbf';
58> set newname for datafile 52 to '/u008/app/oradata/uhcmtst/datafiles/eoecwrk.dbf';
59> set newname for datafile 53 to '/u008/app/oradata/uhcmtst/datafiles/eoeiapp.dbf';
60> set newname for datafile 54 to '/u008/app/oradata/uhcmtst/datafiles/eoeilrg.dbf';
61> set newname for datafile 55 to '/u008/app/oradata/uhcmtst/datafiles/eoewapp.dbf';
62> set newname for datafile 56 to '/u008/app/oradata/uhcmtst/datafiles/eoewlrg.dbf';
63> set newname for datafile 57 to '/u008/app/oradata/uhcmtst/datafiles/eoewwrk.dbf';
64> set newname for datafile 58 to '/u008/app/oradata/uhcmtst/datafiles/eoiuapp.dbf';
65> set newname for datafile 59 to '/u008/app/oradata/uhcmtst/datafiles/eoiulrg.dbf';
66> set newname for datafile 60 to '/u008/app/oradata/uhcmtst/datafiles/eoiuwrk.dbf';
67> set newname for datafile 61 to '/u008/app/oradata/uhcmtst/datafiles/eolarge.dbf';
68> set newname for datafile 62 to '/u008/app/oradata/uhcmtst/datafiles/eoltapp.dbf';
69> set newname for datafile 63 to '/u008/app/oradata/uhcmtst/datafiles/eoppapp.dbf';
70> set newname for datafile 64 to '/u008/app/oradata/uhcmtst/datafiles/eopplrg.dbf';
71> set newname for datafile 65 to '/u008/app/oradata/uhcmtst/datafiles/eotpapp.dbf';
72> set newname for datafile 66 to '/u008/app/oradata/uhcmtst/datafiles/eotplrg.dbf';
73> set newname for datafile 67 to '/u008/app/oradata/uhcmtst/datafiles/epapp.dbf';
74> set newname for datafile 68 to '/u008/app/oradata/uhcmtst/datafiles/eplarge.dbf';
75> set newname for datafile 69 to '/u008/app/oradata/uhcmtst/datafiles/erapp.dbf';
76> set newname for datafile 70 to '/u008/app/oradata/uhcmtst/datafiles/erlarge.dbf';
77> set newname for datafile 71 to '/u008/app/oradata/uhcmtst/datafiles/erwork.dbf';
78> set newname for datafile 72 to '/u008/app/oradata/uhcmtst/datafiles/faapp.dbf';
79> set newname for datafile 73 to '/u008/app/oradata/uhcmtst/datafiles/falarge.dbf';
80> set newname for datafile 74 to '/u008/app/oradata/uhcmtst/datafiles/fgapp.dbf';
81> set newname for datafile 75 to '/u008/app/oradata/uhcmtst/datafiles/fglarge.dbf';
82> set newname for datafile 76 to '/u008/app/oradata/uhcmtst/datafiles/fsapp.dbf';
83> set newname for datafile 77 to '/u008/app/oradata/uhcmtst/datafiles/giapp.dbf';
84> set newname for datafile 78 to '/u008/app/oradata/uhcmtst/datafiles/py0lrg.dbf';
85> set newname for datafile 79 to '/u008/app/oradata/uhcmtst/datafiles/gpdeapp.dbf';
86> set newname for datafile 80 to '/u008/app/oradata/uhcmtst/datafiles/hpapp.dbf';
87> set newname for datafile 81 to '/u008/app/oradata/uhcmtst/datafiles/hrapp.dbf';
88> set newname for datafile 82 to '/u008/app/oradata/uhcmtst/datafiles/pttbl.dbf';
89> set newname for datafile 83 to '/u008/app/oradata/uhcmtst/datafiles/hrapp2.dbf';
90> set newname for datafile 84 to '/u008/app/oradata/uhcmtst/datafiles/hrapp3.dbf';
91> set newname for datafile 85 to '/u008/app/oradata/uhcmtst/datafiles/hrapp4.dbf';
92> set newname for datafile 86 to '/u008/app/oradata/uhcmtst/datafiles/hrapp5.dbf';
93> set newname for datafile 87 to '/u008/app/oradata/uhcmtst/datafiles/hrapp6.dbf';
94> set newname for datafile 88 to '/u008/app/oradata/uhcmtst/datafiles/hrapp7.dbf';
95> set newname for datafile 89 to '/u008/app/oradata/uhcmtst/datafiles/hrimage.dbf';
96> set newname for datafile 90 to '/u008/app/oradata/uhcmtst/datafiles/hrlarg1.dbf';
97> set newname for datafile 91 to '/u008/app/oradata/uhcmtst/datafiles/bnlarge.dbf';
98> set newname for datafile 92 to '/u008/app/oradata/uhcmtst/datafiles/ptrpts.dbf';
99> set newname for datafile 93 to '/u008/app/oradata/uhcmtst/datafiles/hrsarch.dbf';
100> set newname for datafile 94 to '/u008/app/oradata/uhcmtst/datafiles/hrslarge.dbf';
101> set newname for datafile 95 to '/u008/app/oradata/uhcmtst/datafiles/hrswork.dbf';
102> set newname for datafile 96 to '/u008/app/oradata/uhcmtst/datafiles/hrwork.dbf';
103> set newname for datafile 97 to '/u008/app/oradata/uhcmtst/datafiles/htapp.dbf';
104> set newname for datafile 98 to '/u008/app/oradata/uhcmtst/datafiles/inapp.dbf';
105> set newname for datafile 99 to '/u008/app/oradata/uhcmtst/datafiles/paapp.dbf';
106> set newname for datafile 100 to '/u008/app/oradata/uhcmtst/datafiles/palarge.dbf';
107> set newname for datafile 101 to '/u008/app/oradata/uhcmtst/datafiles/pcapp.dbf';
108> set newname for datafile 102 to '/u008/app/oradata/uhcmtst/datafiles/pclarge.dbf';
109> set newname for datafile 103 to '/u008/app/oradata/uhcmtst/datafiles/piapp.dbf';
110> set newname for datafile 104 to '/u008/app/oradata/uhcmtst/datafiles/pilarge.dbf';
111> set newname for datafile 105 to '/u008/app/oradata/uhcmtst/datafiles/piwork.dbf';
112> set newname for datafile 106 to '/u008/app/oradata/uhcmtst/datafiles/poapp.dbf';
113> set newname for datafile 107 to '/u008/app/oradata/uhcmtst/datafiles/pvapp.dbf';
114> set newname for datafile 108 to '/u008/app/oradata/uhcmtst/datafiles/ptprc.dbf';
115> set newname for datafile 109 to '/u008/app/oradata/uhcmtst/datafiles/pyapp.dbf';
116> set newname for datafile 110 to '/u008/app/oradata/uhcmtst/datafiles/pylarge.dbf';
117> set newname for datafile 111 to '/u008/app/oradata/uhcmtst/datafiles/pywork.dbf';
118> set newname for datafile 112 to '/u008/app/oradata/uhcmtst/datafiles/saapp.dbf';
119> set newname for datafile 113 to '/u008/app/oradata/uhcmtst/datafiles/sacapp.dbf';
120> set newname for datafile 114 to '/u008/app/oradata/uhcmtst/datafiles/salarge.dbf';
121> set newname for datafile 115 to '/u008/app/oradata/uhcmtst/datafiles/srapp.dbf';
122> set newname for datafile 116 to '/u008/app/oradata/uhcmtst/datafiles/stapp.dbf';
123> set newname for datafile 117 to '/u008/app/oradata/uhcmtst/datafiles/stlarge.dbf';
124> set newname for datafile 118 to '/u008/app/oradata/uhcmtst/datafiles/stwork.dbf';
125> set newname for datafile 119 to '/u008/app/oradata/uhcmtst/datafiles/hrapp1.dbf';
126> set newname for datafile 120 to '/u008/app/oradata/uhcmtst/datafiles/taapp.dbf';
127> set newname for datafile 121 to '/u008/app/oradata/uhcmtst/datafiles/tlwork.dbf';
128> set newname for datafile 122 to '/u008/app/oradata/uhcmtst/datafiles/hrlarge.dbf';
129> set newname for datafile 123 to '/u008/app/oradata/uhcmtst/datafiles/waapp.dbf';
130> set newname for datafile 124 to '/u008/app/oradata/uhcmtst/datafiles/psresume.dbf';
131> set newname for datafile 125 to '/u008/app/oradata/uhcmtst/datafiles/BPELUSER1.dbf';
132> set newname for datafile 126 to '/u008/app/oradata/uhcmtst/datafiles/sysaux02.dbf';
133> set newname for datafile 127 to '/u008/app/oradata/uhcmtst/datafiles/psindex_01.dbf';
134> set newname for datafile 128 to '/u008/app/oradata/uhcmtst/datafiles/undotbs02.dbf';
135> set newname for datafile 129 to '/u008/app/oradata/uhcmtst/datafiles/sysaux03.dbf';
136> set newname for datafile 130 to '/u008/app/oradata/uhcmtst/datafiles/psimage01.dbf';
137> set newname for datafile 131 to '/u008/app/oradata/uhcmtst/datafiles/sysaux04.dbf';
138> set newname for datafile 132 to '/u008/app/oradata/uhcmtst/datafiles/sysaux05.dbf';
139> set newname for datafile 133 to '/u008/app/oradata/uhcmtst/datafiles/psindex_02.dbf';
140> set newname for datafile 134 to '/u008/app/oradata/uhcmtst/datafiles/sysaux06.dbf';
141> set newname for tempfile 2 to '/u008/app/oradata/uhcmtst/tempfiles/temp01.dbf';
142> set newname for tempfile 6 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp01.dbf';
143> set newname for tempfile 7 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp02.dbf';
144> set newname for tempfile 8 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp03.dbf';
145> set newname for tempfile 9 to '/u008/app/oradata/uhcmtst/tempfiles/pstemp04.dbf';
146> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03a.log'' ";
147> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03b.log'' ";
148> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02a.log'' ";
149> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02b.log'' ";
150> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01a.log'' ";
151> SQL "ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01b.log'' ";
152> restore database;
153> SWITCH DATAFILE ALL;
154> SWITCH TEMPFILE ALL;
155> release channel ch1;
156> release channel ch2;
157> release channel ch3;
158> release channel ch4;
159> }
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=958 device type=DISK
allocated channel: ch2
channel ch2: SID=1149 device type=DISK
allocated channel: ch3
channel ch3: SID=1338 device type=DISK
allocated channel: ch4
channel ch4: SID=3 device type=DISK
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
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo03b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo03b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo02b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo02b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01a.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01a.log''
sql statement: ALTER DATABASE RENAME FILE ''/u001/app/oradata/uhcmtst/redo01b.log'' TO ''/u008/app/oradata/uhcmtst/redologfiles/redo01b.log''
Starting restore at 08-NOV-17
channel ch1: starting datafile backup set restore
channel ch1: specifying datafile(s) to restore from backup set
channel ch1: restoring datafile 00005 to /u008/app/oradata/uhcmtst/datafiles/psdefault.dbf
channel ch1: restoring datafile 00007 to /u008/app/oradata/uhcmtst/datafiles/tllarge.dbf
channel ch1: restoring datafile 00015 to /u008/app/oradata/uhcmtst/datafiles/ptappe.dbf
channel ch1: restoring datafile 00020 to /u008/app/oradata/uhcmtst/datafiles/ptprjwk.dbf
channel ch1: restoring datafile 00027 to /u008/app/oradata/uhcmtst/datafiles/avapp.dbf
channel ch1: restoring datafile 00030 to /u008/app/oradata/uhcmtst/datafiles/psimage.dbf
channel ch1: restoring datafile 00031 to /u008/app/oradata/uhcmtst/datafiles/ccapp.dbf
channel ch1: restoring datafile 00036 to /u008/app/oradata/uhcmtst/datafiles/cularg3.dbf
channel ch1: restoring datafile 00045 to /u008/app/oradata/uhcmtst/datafiles/eocmwrk.dbf
channel ch1: restoring datafile 00050 to /u008/app/oradata/uhcmtst/datafiles/eoecapp.dbf
channel ch1: restoring datafile 00052 to /u008/app/oradata/uhcmtst/datafiles/eoecwrk.dbf
channel ch1: restoring datafile 00059 to /u008/app/oradata/uhcmtst/datafiles/eoiulrg.dbf
channel ch1: restoring datafile 00066 to /u008/app/oradata/uhcmtst/datafiles/eotplrg.dbf
channel ch1: restoring datafile 00069 to /u008/app/oradata/uhcmtst/datafiles/erapp.dbf
channel ch1: restoring datafile 00076 to /u008/app/oradata/uhcmtst/datafiles/fsapp.dbf
channel ch1: restoring datafile 00079 to /u008/app/oradata/uhcmtst/datafiles/gpdeapp.dbf
channel ch1: restoring datafile 00081 to /u008/app/oradata/uhcmtst/datafiles/hrapp.dbf
channel ch1: restoring datafile 00084 to /u008/app/oradata/uhcmtst/datafiles/hrapp3.dbf
channel ch1: restoring datafile 00085 to /u008/app/oradata/uhcmtst/datafiles/hrapp4.dbf
channel ch1: restoring datafile 00091 to /u008/app/oradata/uhcmtst/datafiles/bnlarge.dbf
channel ch1: restoring datafile 00095 to /u008/app/oradata/uhcmtst/datafiles/hrswork.dbf
channel ch1: restoring datafile 00097 to /u008/app/oradata/uhcmtst/datafiles/htapp.dbf
channel ch1: restoring datafile 00098 to /u008/app/oradata/uhcmtst/datafiles/inapp.dbf
channel ch1: restoring datafile 00102 to /u008/app/oradata/uhcmtst/datafiles/pclarge.dbf
channel ch1: restoring datafile 00106 to /u008/app/oradata/uhcmtst/datafiles/poapp.dbf
channel ch1: restoring datafile 00107 to /u008/app/oradata/uhcmtst/datafiles/pvapp.dbf
channel ch1: restoring datafile 00108 to /u008/app/oradata/uhcmtst/datafiles/ptprc.dbf
channel ch1: restoring datafile 00114 to /u008/app/oradata/uhcmtst/datafiles/salarge.dbf
channel ch1: restoring datafile 00116 to /u008/app/oradata/uhcmtst/datafiles/stapp.dbf
channel ch1: restoring datafile 00117 to /u008/app/oradata/uhcmtst/datafiles/stlarge.dbf
channel ch1: restoring datafile 00120 to /u008/app/oradata/uhcmtst/datafiles/taapp.dbf
channel ch1: restoring datafile 00128 to /u008/app/oradata/uhcmtst/datafiles/undotbs02.dbf
channel ch1: restoring datafile 00132 to /u008/app/oradata/uhcmtst/datafiles/sysaux05.dbf
channel ch1: reading from backup piece /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_13sd8hke_1_1
channel ch2: starting datafile backup set restore
channel ch2: specifying datafile(s) to restore from backup set
channel ch2: restoring datafile 00003 to /u008/app/oradata/uhcmtst/datafiles/undotbs01.dbf
channel ch2: restoring datafile 00004 to /u008/app/oradata/uhcmtst/datafiles/users01.dbf
channel ch2: restoring datafile 00006 to /u008/app/oradata/uhcmtst/datafiles/psindex.dbf
channel ch2: restoring datafile 00010 to /u008/app/oradata/uhcmtst/datafiles/hrsapp.dbf
channel ch2: restoring datafile 00011 to /u008/app/oradata/uhcmtst/datafiles/gpapp.dbf
channel ch2: restoring datafile 00013 to /u008/app/oradata/uhcmtst/datafiles/ptlock.dbf
channel ch2: restoring datafile 00018 to /u008/app/oradata/uhcmtst/datafiles/ptwork.dbf
channel ch2: restoring datafile 00019 to /u008/app/oradata/uhcmtst/datafiles/ptcmstar.dbf
channel ch2: restoring datafile 00029 to /u008/app/oradata/uhcmtst/datafiles/bnapp.dbf
channel ch2: restoring datafile 00035 to /u008/app/oradata/uhcmtst/datafiles/cularg2.dbf
channel ch2: restoring datafile 00039 to /u008/app/oradata/uhcmtst/datafiles/dtapp.dbf
channel ch2: restoring datafile 00040 to /u008/app/oradata/uhcmtst/datafiles/eoapp.dbf
channel ch2: restoring datafile 00044 to /u008/app/oradata/uhcmtst/datafiles/eocmlrg.dbf
channel ch2: restoring datafile 00049 to /u008/app/oradata/uhcmtst/datafiles/eodslrg.dbf
channel ch2: restoring datafile 00057 to /u008/app/oradata/uhcmtst/datafiles/eoewwrk.dbf
channel ch2: restoring datafile 00058 to /u008/app/oradata/uhcmtst/datafiles/eoiuapp.dbf
channel ch2: restoring datafile 00063 to /u008/app/oradata/uhcmtst/datafiles/eoppapp.dbf
channel ch2: restoring datafile 00065 to /u008/app/oradata/uhcmtst/datafiles/eotpapp.dbf
channel ch2: restoring datafile 00067 to /u008/app/oradata/uhcmtst/datafiles/epapp.dbf
channel ch2: restoring datafile 00074 to /u008/app/oradata/uhcmtst/datafiles/fgapp.dbf
channel ch2: restoring datafile 00075 to /u008/app/oradata/uhcmtst/datafiles/fglarge.dbf
channel ch2: restoring datafile 00083 to /u008/app/oradata/uhcmtst/datafiles/hrapp2.dbf
channel ch2: restoring datafile 00088 to /u008/app/oradata/uhcmtst/datafiles/hrapp7.dbf
channel ch2: restoring datafile 00093 to /u008/app/oradata/uhcmtst/datafiles/hrsarch.dbf
channel ch2: restoring datafile 00101 to /u008/app/oradata/uhcmtst/datafiles/pcapp.dbf
channel ch2: restoring datafile 00103 to /u008/app/oradata/uhcmtst/datafiles/piapp.dbf
channel ch2: restoring datafile 00109 to /u008/app/oradata/uhcmtst/datafiles/pyapp.dbf
channel ch2: restoring datafile 00110 to /u008/app/oradata/uhcmtst/datafiles/pylarge.dbf
channel ch2: restoring datafile 00112 to /u008/app/oradata/uhcmtst/datafiles/saapp.dbf
channel ch2: restoring datafile 00115 to /u008/app/oradata/uhcmtst/datafiles/srapp.dbf
channel ch2: restoring datafile 00119 to /u008/app/oradata/uhcmtst/datafiles/hrapp1.dbf
channel ch2: restoring datafile 00124 to /u008/app/oradata/uhcmtst/datafiles/psresume.dbf
channel ch2: restoring datafile 00127 to /u008/app/oradata/uhcmtst/datafiles/psindex_01.dbf
channel ch2: reading from backup piece /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_12sd8hke_1_1
channel ch3: starting datafile backup set restore
channel ch3: specifying datafile(s) to restore from backup set
channel ch3: restoring datafile 00001 to /u008/app/oradata/uhcmtst/datafiles/system01.dbf
channel ch3: restoring datafile 00009 to /u008/app/oradata/uhcmtst/datafiles/tlapp.dbf
channel ch3: restoring datafile 00012 to /u008/app/oradata/uhcmtst/datafiles/pswork.dbf
channel ch3: restoring datafile 00014 to /u008/app/oradata/uhcmtst/datafiles/ptamsg.dbf
channel ch3: restoring datafile 00016 to /u008/app/oradata/uhcmtst/datafiles/pttlrg.dbf
channel ch3: restoring datafile 00017 to /u008/app/oradata/uhcmtst/datafiles/pttree.dbf
channel ch3: restoring datafile 00022 to /u008/app/oradata/uhcmtst/datafiles/psimgr.dbf
channel ch3: restoring datafile 00025 to /u008/app/oradata/uhcmtst/datafiles/adapp.dbf
channel ch3: restoring datafile 00026 to /u008/app/oradata/uhcmtst/datafiles/amapp.dbf
channel ch3: restoring datafile 00028 to /u008/app/oradata/uhcmtst/datafiles/bdapp.dbf
channel ch3: restoring datafile 00033 to /u008/app/oradata/uhcmtst/datafiles/cuaudit.dbf
channel ch3: restoring datafile 00037 to /u008/app/oradata/uhcmtst/datafiles/cularge.dbf
channel ch3: restoring datafile 00038 to /u008/app/oradata/uhcmtst/datafiles/diapp.dbf
channel ch3: restoring datafile 00046 to /u008/app/oradata/uhcmtst/datafiles/eocuapp.dbf
channel ch3: restoring datafile 00054 to /u008/app/oradata/uhcmtst/datafiles/eoeilrg.dbf
channel ch3: restoring datafile 00055 to /u008/app/oradata/uhcmtst/datafiles/eoewapp.dbf
channel ch3: restoring datafile 00060 to /u008/app/oradata/uhcmtst/datafiles/eoiuwrk.dbf
channel ch3: restoring datafile 00061 to /u008/app/oradata/uhcmtst/datafiles/eolarge.dbf
channel ch3: restoring datafile 00068 to /u008/app/oradata/uhcmtst/datafiles/eplarge.dbf
channel ch3: restoring datafile 00070 to /u008/app/oradata/uhcmtst/datafiles/erlarge.dbf
channel ch3: restoring datafile 00072 to /u008/app/oradata/uhcmtst/datafiles/faapp.dbf
channel ch3: restoring datafile 00077 to /u008/app/oradata/uhcmtst/datafiles/giapp.dbf
channel ch3: restoring datafile 00080 to /u008/app/oradata/uhcmtst/datafiles/hpapp.dbf
channel ch3: restoring datafile 00086 to /u008/app/oradata/uhcmtst/datafiles/hrapp5.dbf
channel ch3: restoring datafile 00089 to /u008/app/oradata/uhcmtst/datafiles/hrimage.dbf
channel ch3: restoring datafile 00094 to /u008/app/oradata/uhcmtst/datafiles/hrslarge.dbf
channel ch3: restoring datafile 00096 to /u008/app/oradata/uhcmtst/datafiles/hrwork.dbf
channel ch3: restoring datafile 00099 to /u008/app/oradata/uhcmtst/datafiles/paapp.dbf
channel ch3: restoring datafile 00113 to /u008/app/oradata/uhcmtst/datafiles/sacapp.dbf
channel ch3: restoring datafile 00118 to /u008/app/oradata/uhcmtst/datafiles/stwork.dbf
channel ch3: restoring datafile 00121 to /u008/app/oradata/uhcmtst/datafiles/tlwork.dbf
channel ch3: restoring datafile 00126 to /u008/app/oradata/uhcmtst/datafiles/sysaux02.dbf
channel ch3: restoring datafile 00129 to /u008/app/oradata/uhcmtst/datafiles/sysaux03.dbf
channel ch3: restoring datafile 00130 to /u008/app/oradata/uhcmtst/datafiles/psimage01.dbf
channel ch3: reading from backup piece /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_14sd8hke_1_1
channel ch4: starting datafile backup set restore
channel ch4: specifying datafile(s) to restore from backup set
channel ch4: restoring datafile 00002 to /u008/app/oradata/uhcmtst/datafiles/sysaux01.dbf
channel ch4: restoring datafile 00008 to /u008/app/oradata/uhcmtst/datafiles/ptapp.dbf
channel ch4: restoring datafile 00021 to /u008/app/oradata/uhcmtst/datafiles/ptaudit.dbf
channel ch4: restoring datafile 00023 to /u008/app/oradata/uhcmtst/datafiles/aaapp.dbf
channel ch4: restoring datafile 00024 to /u008/app/oradata/uhcmtst/datafiles/aalarge.dbf
channel ch4: restoring datafile 00032 to /u008/app/oradata/uhcmtst/datafiles/coapp.dbf
channel ch4: restoring datafile 00034 to /u008/app/oradata/uhcmtst/datafiles/cularg1.dbf
channel ch4: restoring datafile 00041 to /u008/app/oradata/uhcmtst/datafiles/eobfapp.dbf
channel ch4: restoring datafile 00042 to /u008/app/oradata/uhcmtst/datafiles/eocfapp.dbf
channel ch4: restoring datafile 00043 to /u008/app/oradata/uhcmtst/datafiles/eocmapp.dbf
channel ch4: restoring datafile 00047 to /u008/app/oradata/uhcmtst/datafiles/eoculrg.dbf
channel ch4: restoring datafile 00048 to /u008/app/oradata/uhcmtst/datafiles/eodsapp.dbf
channel ch4: restoring datafile 00051 to /u008/app/oradata/uhcmtst/datafiles/eoeclrg.dbf
channel ch4: restoring datafile 00053 to /u008/app/oradata/uhcmtst/datafiles/eoeiapp.dbf
channel ch4: restoring datafile 00056 to /u008/app/oradata/uhcmtst/datafiles/eoewlrg.dbf
channel ch4: restoring datafile 00062 to /u008/app/oradata/uhcmtst/datafiles/eoltapp.dbf
channel ch4: restoring datafile 00064 to /u008/app/oradata/uhcmtst/datafiles/eopplrg.dbf
channel ch4: restoring datafile 00071 to /u008/app/oradata/uhcmtst/datafiles/erwork.dbf
channel ch4: restoring datafile 00073 to /u008/app/oradata/uhcmtst/datafiles/falarge.dbf
channel ch4: restoring datafile 00078 to /u008/app/oradata/uhcmtst/datafiles/py0lrg.dbf
channel ch4: restoring datafile 00082 to /u008/app/oradata/uhcmtst/datafiles/pttbl.dbf
channel ch4: restoring datafile 00087 to /u008/app/oradata/uhcmtst/datafiles/hrapp6.dbf
channel ch4: restoring datafile 00090 to /u008/app/oradata/uhcmtst/datafiles/hrlarg1.dbf
channel ch4: restoring datafile 00092 to /u008/app/oradata/uhcmtst/datafiles/ptrpts.dbf
channel ch4: restoring datafile 00100 to /u008/app/oradata/uhcmtst/datafiles/palarge.dbf
channel ch4: restoring datafile 00104 to /u008/app/oradata/uhcmtst/datafiles/pilarge.dbf
channel ch4: restoring datafile 00105 to /u008/app/oradata/uhcmtst/datafiles/piwork.dbf
channel ch4: restoring datafile 00111 to /u008/app/oradata/uhcmtst/datafiles/pywork.dbf
channel ch4: restoring datafile 00122 to /u008/app/oradata/uhcmtst/datafiles/hrlarge.dbf
channel ch4: restoring datafile 00123 to /u008/app/oradata/uhcmtst/datafiles/waapp.dbf
channel ch4: restoring datafile 00125 to /u008/app/oradata/uhcmtst/datafiles/BPELUSER1.dbf
channel ch4: restoring datafile 00131 to /u008/app/oradata/uhcmtst/datafiles/sysaux04.dbf
channel ch4: restoring datafile 00133 to /u008/app/oradata/uhcmtst/datafiles/psindex_02.dbf
channel ch4: restoring datafile 00134 to /u008/app/oradata/uhcmtst/datafiles/sysaux06.dbf
channel ch4: reading from backup piece /u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_11sd8hkd_1_1
channel ch2: piece handle=/u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_12sd8hke_1_1 tag=TAG20170831T031626
channel ch2: restored backup piece 1
channel ch2: restore complete, elapsed time: 00:59:06
channel ch1: piece handle=/u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_13sd8hke_1_1 tag=TAG20170831T031626
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 01:01:16
channel ch4: piece handle=/u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_11sd8hkd_1_1 tag=TAG20170831T031626
channel ch4: restored backup piece 1
channel ch4: restore complete, elapsed time: 01:14:36
channel ch3: piece handle=/u008/app/oradata/rman_cold/cold_bk_UHCMTSTx_14sd8hke_1_1 tag=TAG20170831T031626
channel ch3: restored backup piece 1
channel ch3: restore complete, elapsed time: 01:15:37
Finished restore at 08-NOV-17
datafile 1 switched to datafile copy
input datafile copy RECID=268 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=269 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=270 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=271 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=272 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/psdefault.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=273 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/psindex.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=274 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/tllarge.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=275 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptapp.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=276 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/tlapp.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=277 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/hrsapp.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=278 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/gpapp.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=279 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/pswork.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=280 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptlock.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=281 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptamsg.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=282 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptappe.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=283 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/pttlrg.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=284 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/pttree.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=285 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptwork.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=286 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptcmstar.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=287 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptprjwk.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=288 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ptaudit.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=289 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/psimgr.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=290 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/aaapp.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=291 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/aalarge.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=292 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/adapp.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=293 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/amapp.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=294 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/avapp.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=295 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/bdapp.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=296 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/bnapp.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=297 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/psimage.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=298 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/ccapp.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=299 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/coapp.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=300 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/cuaudit.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=301 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/cularg1.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=302 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/cularg2.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=303 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/cularg3.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=304 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/cularge.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=305 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/diapp.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=306 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/dtapp.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=307 STAMP=959512060 file name=/u008/app/oradata/uhcmtst/datafiles/eoapp.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=308 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eobfapp.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=309 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eocfapp.dbf
datafile 43 switched to datafile copy
input datafile copy RECID=310 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eocmapp.dbf
datafile 44 switched to datafile copy
input datafile copy RECID=311 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eocmlrg.dbf
datafile 45 switched to datafile copy
input datafile copy RECID=312 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eocmwrk.dbf
datafile 46 switched to datafile copy
input datafile copy RECID=313 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eocuapp.dbf
datafile 47 switched to datafile copy
input datafile copy RECID=314 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoculrg.dbf
datafile 48 switched to datafile copy
input datafile copy RECID=315 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eodsapp.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=316 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eodslrg.dbf
datafile 50 switched to datafile copy
input datafile copy RECID=317 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoecapp.dbf
datafile 51 switched to datafile copy
input datafile copy RECID=318 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoeclrg.dbf
datafile 52 switched to datafile copy
input datafile copy RECID=319 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoecwrk.dbf
datafile 53 switched to datafile copy
input datafile copy RECID=320 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoeiapp.dbf
datafile 54 switched to datafile copy
input datafile copy RECID=321 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoeilrg.dbf
datafile 55 switched to datafile copy
input datafile copy RECID=322 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoewapp.dbf
datafile 56 switched to datafile copy
input datafile copy RECID=323 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoewlrg.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=324 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoewwrk.dbf
datafile 58 switched to datafile copy
input datafile copy RECID=325 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoiuapp.dbf
datafile 59 switched to datafile copy
input datafile copy RECID=326 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoiulrg.dbf
datafile 60 switched to datafile copy
input datafile copy RECID=327 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoiuwrk.dbf
datafile 61 switched to datafile copy
input datafile copy RECID=328 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eolarge.dbf
datafile 62 switched to datafile copy
input datafile copy RECID=329 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoltapp.dbf
datafile 63 switched to datafile copy
input datafile copy RECID=330 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eoppapp.dbf
datafile 64 switched to datafile copy
input datafile copy RECID=331 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eopplrg.dbf
datafile 65 switched to datafile copy
input datafile copy RECID=332 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eotpapp.dbf
datafile 66 switched to datafile copy
input datafile copy RECID=333 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eotplrg.dbf
datafile 67 switched to datafile copy
input datafile copy RECID=334 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/epapp.dbf
datafile 68 switched to datafile copy
input datafile copy RECID=335 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/eplarge.dbf
datafile 69 switched to datafile copy
input datafile copy RECID=336 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/erapp.dbf
datafile 70 switched to datafile copy
input datafile copy RECID=337 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/erlarge.dbf
datafile 71 switched to datafile copy
input datafile copy RECID=338 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/erwork.dbf
datafile 72 switched to datafile copy
input datafile copy RECID=339 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/faapp.dbf
datafile 73 switched to datafile copy
input datafile copy RECID=340 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/falarge.dbf
datafile 74 switched to datafile copy
input datafile copy RECID=341 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/fgapp.dbf
datafile 75 switched to datafile copy
input datafile copy RECID=342 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/fglarge.dbf
datafile 76 switched to datafile copy
input datafile copy RECID=343 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/fsapp.dbf
datafile 77 switched to datafile copy
input datafile copy RECID=344 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/giapp.dbf
datafile 78 switched to datafile copy
input datafile copy RECID=345 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/py0lrg.dbf
datafile 79 switched to datafile copy
input datafile copy RECID=346 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/gpdeapp.dbf
datafile 80 switched to datafile copy
input datafile copy RECID=347 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hpapp.dbf
datafile 81 switched to datafile copy
input datafile copy RECID=348 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp.dbf
datafile 82 switched to datafile copy
input datafile copy RECID=349 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pttbl.dbf
datafile 83 switched to datafile copy
input datafile copy RECID=350 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp2.dbf
datafile 84 switched to datafile copy
input datafile copy RECID=351 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp3.dbf
datafile 85 switched to datafile copy
input datafile copy RECID=352 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp4.dbf
datafile 86 switched to datafile copy
input datafile copy RECID=353 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp5.dbf
datafile 87 switched to datafile copy
input datafile copy RECID=354 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp6.dbf
datafile 88 switched to datafile copy
input datafile copy RECID=355 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp7.dbf
datafile 89 switched to datafile copy
input datafile copy RECID=356 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrimage.dbf
datafile 90 switched to datafile copy
input datafile copy RECID=357 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrlarg1.dbf
datafile 91 switched to datafile copy
input datafile copy RECID=358 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/bnlarge.dbf
datafile 92 switched to datafile copy
input datafile copy RECID=359 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/ptrpts.dbf
datafile 93 switched to datafile copy
input datafile copy RECID=360 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrsarch.dbf
datafile 94 switched to datafile copy
input datafile copy RECID=361 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrslarge.dbf
datafile 95 switched to datafile copy
input datafile copy RECID=362 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrswork.dbf
datafile 96 switched to datafile copy
input datafile copy RECID=363 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrwork.dbf
datafile 97 switched to datafile copy
input datafile copy RECID=364 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/htapp.dbf
datafile 98 switched to datafile copy
input datafile copy RECID=365 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/inapp.dbf
datafile 99 switched to datafile copy
input datafile copy RECID=366 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/paapp.dbf
datafile 100 switched to datafile copy
input datafile copy RECID=367 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/palarge.dbf
datafile 101 switched to datafile copy
input datafile copy RECID=368 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pcapp.dbf
datafile 102 switched to datafile copy
input datafile copy RECID=369 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pclarge.dbf
datafile 103 switched to datafile copy
input datafile copy RECID=370 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/piapp.dbf
datafile 104 switched to datafile copy
input datafile copy RECID=371 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pilarge.dbf
datafile 105 switched to datafile copy
input datafile copy RECID=372 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/piwork.dbf
datafile 106 switched to datafile copy
input datafile copy RECID=373 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/poapp.dbf
datafile 107 switched to datafile copy
input datafile copy RECID=374 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pvapp.dbf
datafile 108 switched to datafile copy
input datafile copy RECID=375 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/ptprc.dbf
datafile 109 switched to datafile copy
input datafile copy RECID=376 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pyapp.dbf
datafile 110 switched to datafile copy
input datafile copy RECID=377 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pylarge.dbf
datafile 111 switched to datafile copy
input datafile copy RECID=378 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/pywork.dbf
datafile 112 switched to datafile copy
input datafile copy RECID=379 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/saapp.dbf
datafile 113 switched to datafile copy
input datafile copy RECID=380 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/sacapp.dbf
datafile 114 switched to datafile copy
input datafile copy RECID=381 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/salarge.dbf
datafile 115 switched to datafile copy
input datafile copy RECID=382 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/srapp.dbf
datafile 116 switched to datafile copy
input datafile copy RECID=383 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/stapp.dbf
datafile 117 switched to datafile copy
input datafile copy RECID=384 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/stlarge.dbf
datafile 118 switched to datafile copy
input datafile copy RECID=385 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/stwork.dbf
datafile 119 switched to datafile copy
input datafile copy RECID=386 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrapp1.dbf
datafile 120 switched to datafile copy
input datafile copy RECID=387 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/taapp.dbf
datafile 121 switched to datafile copy
input datafile copy RECID=388 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/tlwork.dbf
datafile 122 switched to datafile copy
input datafile copy RECID=389 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/hrlarge.dbf
datafile 123 switched to datafile copy
input datafile copy RECID=390 STAMP=959512061 file name=/u008/app/oradata/uhcmtst/datafiles/waapp.dbf
datafile 124 switched to datafile copy
input datafile copy RECID=391 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/psresume.dbf
datafile 125 switched to datafile copy
input datafile copy RECID=392 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/BPELUSER1.dbf
datafile 126 switched to datafile copy
input datafile copy RECID=393 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux02.dbf
datafile 127 switched to datafile copy
input datafile copy RECID=394 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/psindex_01.dbf
datafile 128 switched to datafile copy
input datafile copy RECID=395 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/undotbs02.dbf
datafile 129 switched to datafile copy
input datafile copy RECID=396 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux03.dbf
datafile 130 switched to datafile copy
input datafile copy RECID=397 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/psimage01.dbf
datafile 131 switched to datafile copy
input datafile copy RECID=398 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux04.dbf
datafile 132 switched to datafile copy
input datafile copy RECID=399 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux05.dbf
datafile 133 switched to datafile copy
input datafile copy RECID=400 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/psindex_02.dbf
datafile 134 switched to datafile copy
input datafile copy RECID=401 STAMP=959512062 file name=/u008/app/oradata/uhcmtst/datafiles/sysaux06.dbf
renamed tempfile 2 to /u008/app/oradata/uhcmtst/tempfiles/temp01.dbf in control file
renamed tempfile 6 to /u008/app/oradata/uhcmtst/tempfiles/pstemp01.dbf in control file
renamed tempfile 7 to /u008/app/oradata/uhcmtst/tempfiles/pstemp02.dbf in control file
renamed tempfile 8 to /u008/app/oradata/uhcmtst/tempfiles/pstemp03.dbf in control file
renamed tempfile 9 to /u008/app/oradata/uhcmtst/tempfiles/pstemp04.dbf in control file
released channel: ch1
released channel: ch2
released channel: ch3
released channel: ch4
RMAN> **end-of-file**
RMAN>
Recovery Manager complete.
[oracle@dvpsaixdb02us] rman_cold $


Step 4:








Post Database Recovery, issue database reset logs.


RMAN> alter database open resetlogs;
database opened.








Step 5:
Health Checks


Verify Alert log file.
See that the datafiles, controlfiles and redolog files are created in the specified locations.
See for any trace files generated.




Regards
Sai