#!/usr/bin/ksh export NLS_DATE_FORMAT='DD-MON-YY HH24:MI' TIMESTAMP=`date +%y%m%d%H%M` PATH=$PATH:/usr/local/bin export ORACLE_BASE=/u01/home/oracle export ORACLE_SID=WE7C LOG_DIR=${ORACLE_BASE}/admin/${ORACLE_SID}/logs RMAN_LOGFILE=${LOG_DIR}/restore_${ORACLE_SID}_${TIMESTAMP}.log MAIL_LIST="manjunath.maller@DexMedia.com,rahul.raman@dexmedia.com,ranit.bagchi@dexmedia.com" ################################ ################################ ${ORACLE_HOME}/bin/rman << RMANTAG >> ${RMAN_LOGFILE} connect target / startup nomount; set dbid=2706841772; restore standby controlfile from '/u01/home/oracle/product/10.2.0/Db_1/dbs/jgrt6hrq_1_1'; sql 'alter database mount standby database'; RUN { ALLOCATE CHANNEL c1 DEVICE TYPE 'sbt' PARMS 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/WE7C.tdpo.opt)'; set newname for datafile 182 to '/u05/oradata/WE7C/cltables_lg_06.dbf' ; set newname for datafile 173 to '/u04/oradata/WE7C/cltables_lg_06.dbf' ; set newname for datafile 8 to '/u05/oradata/WE7C/equity_data_lg_02.dbf' ; set newname for datafile 162 to '/u04/oradata/WE7C/equity_data_lg_02.dbf' ; set newname for datafile 67 to '/u05/oradata/WE7C/indexes_lg_06.dbf' ; set newname for datafile 66 to '/u04/oradata/WE7C/indexes_lg_06.dbf' ; set newname for datafile 39 to '/u05/oradata/WE7C/tables_lg1_03.dbf' ; set newname for datafile 157 to '/u04/oradata/WE7C/tables_lg1_03.dbf' ; set newname for datafile 156 to '/u05/oradata/WE7C/tables_lg2_01.dbf' ; set newname for datafile 41 to '/u04/oradata/WE7C/tables_lg2_01.dbf' ; set newname for datafile 56 to '/u05/oradata/WE7C/tables_lg4_05.dbf' ; set newname for datafile 155 to '/u04/oradata/WE7C/tables_lg4_05.dbf' ; set newname for datafile 168 to '/u05/oradata/WE7C/tables_lg_11.dbf' ; set newname for datafile 206 to '/u04/oradata/WE7C/tables_lg_11.dbf' ; set newname for datafile 12 to '/u05/oradata/WE7C/tables_sm_01.dbf' ; set newname for datafile 172 to '/u04/oradata/WE7C/tables_sm_01.dbf' ; set newname for datafile 163 to '/u04/oradata/WE7C/EQUITY_WEEK_DATA_01_new.dbf' ; set newname for datafile 183 to '/u04/oradata/WE7C/WE7C_undo_tbs_07.dbf' ; set newname for datafile 100 to '/u04/oradata/WE7C/clindexes_lg_01.dbf' ; set newname for datafile 114 to '/u04/oradata/WE7C/clindexes_lg_02.dbf' ; set newname for datafile 123 to '/u04/oradata/WE7C/clindexes_lg_03.dbf' ; set newname for datafile 131 to '/u04/oradata/WE7C/clindexes_lg_04.dbf' ; set newname for datafile 134 to '/u04/oradata/WE7C/clindexes_lg_05.dbf' ; set newname for datafile 152 to '/u04/oradata/WE7C/clindexes_lg_06.dbf' ; set newname for datafile 181 to '/u04/oradata/WE7C/clindexes_lg_07.dbf' ; set newname for datafile 204 to '/u04/oradata/WE7C/clindexes_lg_08.dbf' ; set newname for datafile 207 to '/u04/oradata/WE7C/clindexes_lg_09.dbf' ; set newname for datafile 213 to '/u04/oradata/WE7C/clindexes_lg_10.dbf' ; set newname for datafile 154 to '/u04/oradata/WE7C/clindexes_lg_new.dbf' ; set newname for datafile 93 to '/u04/oradata/WE7C/clindexes_md_01.dbf' ; set newname for datafile 214 to '/u04/oradata/WE7C/clindexes_md_02.dbf' ; set newname for datafile 101 to '/u04/oradata/WE7C/clindexes_raw_01.dbf' ; set newname for datafile 102 to '/u04/oradata/WE7C/clindexes_raw_02.dbf' ; set newname for datafile 103 to '/u04/oradata/WE7C/clindexes_raw_03.dbf' ; set newname for datafile 82 to '/u04/oradata/WE7C/clindexes_raw_04.dbf' ; set newname for datafile 83 to '/u04/oradata/WE7C/clindexes_raw_05.dbf' ; set newname for datafile 84 to '/u04/oradata/WE7C/clindexes_raw_06.dbf' ; set newname for datafile 85 to '/u04/oradata/WE7C/clindexes_raw_07.dbf' ; set newname for datafile 110 to '/u04/oradata/WE7C/clindexes_raw_08.dbf' ; set newname for datafile 120 to '/u04/oradata/WE7C/clindexes_raw_09.dbf' ; set newname for datafile 124 to '/u04/oradata/WE7C/clindexes_raw_10.dbf' ; set newname for datafile 125 to '/u04/oradata/WE7C/clindexes_raw_11.dbf' ; set newname for datafile 128 to '/u04/oradata/WE7C/clindexes_raw_12.dbf' ; set newname for datafile 130 to '/u04/oradata/WE7C/clindexes_raw_13.dbf' ; set newname for datafile 133 to '/u04/oradata/WE7C/clindexes_raw_14.dbf' ; set newname for datafile 136 to '/u04/oradata/WE7C/clindexes_raw_15.dbf' ; set newname for datafile 140 to '/u04/oradata/WE7C/clindexes_raw_16.dbf' ; set newname for datafile 145 to '/u04/oradata/WE7C/clindexes_raw_17.dbf' ; set newname for datafile 147 to '/u04/oradata/WE7C/clindexes_raw_18.dbf' ; set newname for datafile 150 to '/u04/oradata/WE7C/clindexes_raw_19.dbf' ; set newname for datafile 179 to '/u04/oradata/WE7C/clindexes_raw_20.dbf' ; set newname for datafile 180 to '/u04/oradata/WE7C/clindexes_raw_21.dbf' ; set newname for datafile 190 to '/u04/oradata/WE7C/clindexes_raw_22.dbf' ; set newname for datafile 191 to '/u04/oradata/WE7C/clindexes_raw_23.dbf' ; set newname for datafile 195 to '/u04/oradata/WE7C/clindexes_raw_24.dbf' ; set newname for datafile 197 to '/u04/oradata/WE7C/clindexes_raw_25.dbf' ; set newname for datafile 199 to '/u04/oradata/WE7C/clindexes_raw_26.dbf' ; set newname for datafile 202 to '/u04/oradata/WE7C/clindexes_raw_27.dbf' ; set newname for datafile 208 to '/u04/oradata/WE7C/clindexes_raw_28.dbf' ; set newname for datafile 210 to '/u04/oradata/WE7C/clindexes_raw_30.dbf' ; set newname for datafile 211 to '/u04/oradata/WE7C/clindexes_raw_31.dbf' ; set newname for datafile 164 to '/u04/oradata/WE7C/clindexes_raw_new.dbf' ; set newname for datafile 91 to '/u04/oradata/WE7C/clindexes_sm_01.dbf' ; set newname for datafile 94 to '/u04/oradata/WE7C/cltables_lg_01.dbf' ; set newname for datafile 105 to '/u04/oradata/WE7C/cltables_lg_02.dbf' ; set newname for datafile 146 to '/u04/oradata/WE7C/cltables_lg_03.dbf' ; set newname for datafile 151 to '/u04/oradata/WE7C/cltables_lg_04.dbf' ; set newname for datafile 153 to '/u04/oradata/WE7C/cltables_lg_05.dbf' ; set newname for datafile 201 to '/u04/oradata/WE7C/cltables_lg_07.dbf' ; set newname for datafile 205 to '/u04/oradata/WE7C/cltables_lg_08.dbf' ; set newname for datafile 209 to '/u04/oradata/WE7C/cltables_lg_10.dbf' ; set newname for datafile 92 to '/u04/oradata/WE7C/cltables_md_01.dbf' ; set newname for datafile 95 to '/u04/oradata/WE7C/cltables_raw_01.dbf' ; set newname for datafile 96 to '/u04/oradata/WE7C/cltables_raw_02.dbf' ; set newname for datafile 97 to '/u04/oradata/WE7C/cltables_raw_03.dbf' ; set newname for datafile 98 to '/u04/oradata/WE7C/cltables_raw_04.dbf' ; set newname for datafile 99 to '/u04/oradata/WE7C/cltables_raw_05.dbf' ; set newname for datafile 79 to '/u04/oradata/WE7C/cltables_raw_06.dbf' ; set newname for datafile 80 to '/u04/oradata/WE7C/cltables_raw_07.dbf' ; set newname for datafile 89 to '/u04/oradata/WE7C/cltables_raw_08.dbf' ; set newname for datafile 107 to '/u04/oradata/WE7C/cltables_raw_09.dbf' ; set newname for datafile 108 to '/u04/oradata/WE7C/cltables_raw_10.dbf' ; set newname for datafile 109 to '/u04/oradata/WE7C/cltables_raw_11.dbf' ; set newname for datafile 115 to '/u04/oradata/WE7C/cltables_raw_12.dbf' ; set newname for datafile 116 to '/u04/oradata/WE7C/cltables_raw_13.dbf' ; set newname for datafile 117 to '/u04/oradata/WE7C/cltables_raw_14.dbf' ; set newname for datafile 118 to '/u04/oradata/WE7C/cltables_raw_15.dbf' ; set newname for datafile 119 to '/u04/oradata/WE7C/cltables_raw_16.dbf' ; set newname for datafile 121 to '/u04/oradata/WE7C/cltables_raw_17.dbf' ; set newname for datafile 122 to '/u04/oradata/WE7C/cltables_raw_18.dbf' ; set newname for datafile 126 to '/u04/oradata/WE7C/cltables_raw_19.dbf' ; set newname for datafile 127 to '/u05/oradata/WE7C/cltables_raw_20.dbf' ; set newname for datafile 129 to '/u05/oradata/WE7C/cltables_raw_21.dbf' ; set newname for datafile 132 to '/u05/oradata/WE7C/cltables_raw_22.dbf' ; set newname for datafile 135 to '/u05/oradata/WE7C/cltables_raw_23.dbf' ; set newname for datafile 137 to '/u05/oradata/WE7C/cltables_raw_24.dbf' ; set newname for datafile 138 to '/u05/oradata/WE7C/cltables_raw_25.dbf' ; set newname for datafile 139 to '/u05/oradata/WE7C/cltables_raw_26.dbf' ; set newname for datafile 141 to '/u05/oradata/WE7C/cltables_raw_27.dbf' ; set newname for datafile 142 to '/u05/oradata/WE7C/cltables_raw_28.dbf' ; set newname for datafile 143 to '/u05/oradata/WE7C/cltables_raw_29.dbf' ; set newname for datafile 144 to '/u05/oradata/WE7C/cltables_raw_30.dbf' ; set newname for datafile 148 to '/u05/oradata/WE7C/cltables_raw_31.dbf' ; set newname for datafile 149 to '/u05/oradata/WE7C/cltables_raw_32.dbf' ; set newname for datafile 178 to '/u05/oradata/WE7C/cltables_raw_33.dbf' ; set newname for datafile 189 to '/u05/oradata/WE7C/cltables_raw_34.dbf' ; set newname for datafile 192 to '/u05/oradata/WE7C/cltables_raw_35.dbf' ; set newname for datafile 193 to '/u05/oradata/WE7C/cltables_raw_36.dbf' ; set newname for datafile 196 to '/u05/oradata/WE7C/cltables_raw_37.dbf' ; set newname for datafile 198 to '/u05/oradata/WE7C/cltables_raw_38.dbf' ; set newname for datafile 200 to '/u05/oradata/WE7C/cltables_raw_39.dbf' ; set newname for datafile 203 to '/u05/oradata/WE7C/cltables_raw_40.dbf' ; set newname for datafile 165 to '/u05/oradata/WE7C/cltables_raw_new.dbf' ; set newname for datafile 174 to '/u05/oradata/WE7C/cltables_raw_new_02.dbf' ; set newname for datafile 90 to '/u05/oradata/WE7C/cltables_sm_01.dbf' ; set newname for datafile 75 to '/u05/oradata/WE7C/equity_bid_data_01.dbf' ; set newname for datafile 76 to '/u05/oradata/WE7C/equity_bid_index_01.dbf' ; set newname for datafile 112 to '/u05/oradata/WE7C/equity_bid_index_02.dbf' ; set newname for datafile 113 to '/u05/oradata/WE7C/equity_bid_index_03.dbf' ; set newname for datafile 71 to '/u05/oradata/WE7C/equity_data_lg_01.dbf' ; set newname for datafile 9 to '/u05/oradata/WE7C/equity_data_lg_03.dbf' ; set newname for datafile 184 to '/u05/oradata/WE7C/equity_data_lg_04.dbf' ; set newname for datafile 185 to '/u05/oradata/WE7C/equity_data_lg_05.dbf' ; set newname for datafile 73 to '/u05/oradata/WE7C/equity_data_sm_01.dbf' ; set newname for datafile 72 to '/u05/oradata/WE7C/equity_index_lg_01.dbf' ; set newname for datafile 111 to '/u05/oradata/WE7C/equity_index_lg_02.dbf' ; set newname for datafile 74 to '/u05/oradata/WE7C/equity_index_sm_01.dbf' ; set newname for datafile 77 to '/u05/oradata/WE7C/equity_week_data_01.dbf' ; set newname for datafile 81 to '/u05/oradata/WE7C/equity_week_data_02.dbf' ; set newname for datafile 58 to '/u05/oradata/WE7C/equity_week_data_03.dbf' ; set newname for datafile 59 to '/u05/oradata/WE7C/equity_week_data_04.dbf' ; set newname for datafile 61 to '/u05/oradata/WE7C/equity_week_data_05.dbf' ; set newname for datafile 62 to '/u05/oradata/WE7C/equity_week_data_06.dbf' ; set newname for datafile 68 to '/u05/oradata/WE7C/equity_week_data_07.dbf' ; set newname for datafile 78 to '/u05/oradata/WE7C/equity_week_index_01.dbf' ; set newname for datafile 26 to '/u05/oradata/WE7C/indexes_lg_01.dbf' ; set newname for datafile 28 to '/u05/oradata/WE7C/indexes_lg_02.dbf' ; set newname for datafile 27 to '/u05/oradata/WE7C/indexes_lg_03.dbf' ; set newname for datafile 29 to '/u05/oradata/WE7C/indexes_lg_04.dbf' ; set newname for datafile 57 to '/u05/oradata/WE7C/indexes_lg_05.dbf' ; set newname for datafile 176 to '/u05/oradata/WE7C/indexes_lg_07.dbf' ; set newname for datafile 159 to '/u05/oradata/WE7C/indexes_lg_new.dbf' ; set newname for datafile 21 to '/u05/oradata/WE7C/indexes_md1_01.dbf' ; set newname for datafile 22 to '/u05/oradata/WE7C/indexes_md1_02.dbf' ; set newname for datafile 23 to '/u05/oradata/WE7C/indexes_md2_01.dbf' ; set newname for datafile 24 to '/u05/oradata/WE7C/indexes_md2_02.dbf' ; set newname for datafile 25 to '/u05/oradata/WE7C/indexes_md2_03.dbf' ; set newname for datafile 86 to '/u05/oradata/WE7C/indexes_md2_04.dbf' ; set newname for datafile 160 to '/u05/oradata/WE7C/indexes_md2_new.dbf' ; set newname for datafile 19 to '/u05/oradata/WE7C/indexes_sm_01.dbf' ; set newname for datafile 20 to '/u05/oradata/WE7C/indexes_sm_02.dbf' ; set newname for datafile 170 to '/u05/oradata/WE7C/indexes_sm_03.dbf' ; set newname for datafile 188 to '/u05/oradata/WE7C/indexes_sm_04.dbf' ; set newname for datafile 169 to '/u05/oradata/WE7C/indexmd1_04.dbf' ; set newname for datafile 212 to '/u05/oradata/WE7C/indexmd1_05.dbf' ; set newname for datafile 194 to '/u05/oradata/WE7C/security_audit_01.dbf' ; set newname for datafile 69 to '/u05/oradata/WE7C/splex_data_01.dbf' ; set newname for datafile 70 to '/u05/oradata/WE7C/splex_index_01.dbf' ; set newname for datafile 106 to '/u05/oradata/WE7C/sysaux01.dbf' ; set newname for datafile 177 to '/u05/oradata/WE7C/sysaux02.dbf' ; set newname for datafile 1 to '/u05/oradata/WE7C/system_01.dbf' ; set newname for datafile 37 to '/u05/oradata/WE7C/tables_lg1_01.dbf' ; set newname for datafile 38 to '/u05/oradata/WE7C/tables_lg1_02.dbf' ; set newname for datafile 40 to '/u05/oradata/WE7C/tables_lg1_04.dbf' ; set newname for datafile 53 to '/u05/oradata/WE7C/tables_lg1_05.dbf' ; set newname for datafile 60 to '/u05/oradata/WE7C/tables_lg1_06.dbf' ; set newname for datafile 64 to '/u05/oradata/WE7C/tables_lg1_07.dbf' ; set newname for datafile 42 to '/u05/oradata/WE7C/tables_lg2_02.dbf' ; set newname for datafile 43 to '/u05/oradata/WE7C/tables_lg2_03.dbf' ; set newname for datafile 44 to '/u05/oradata/WE7C/tables_lg2_04.dbf' ; set newname for datafile 54 to '/u05/oradata/WE7C/tables_lg2_05.dbf' ; set newname for datafile 45 to '/u05/oradata/WE7C/tables_lg3_01.dbf' ; set newname for datafile 46 to '/u05/oradata/WE7C/tables_lg3_02.dbf' ; set newname for datafile 47 to '/u05/oradata/WE7C/tables_lg3_03.dbf' ; set newname for datafile 48 to '/u05/oradata/WE7C/tables_lg3_04.dbf' ; set newname for datafile 55 to '/u05/oradata/WE7C/tables_lg3_05.dbf' ; set newname for datafile 167 to '/u05/oradata/WE7C/tables_lg3_06.dbf' ; set newname for datafile 49 to '/u05/oradata/WE7C/tables_lg4_01.dbf' ; set newname for datafile 50 to '/u05/oradata/WE7C/tables_lg4_02.dbf' ; set newname for datafile 51 to '/u05/oradata/WE7C/tables_lg4_03.dbf' ; set newname for datafile 52 to '/u05/oradata/WE7C/tables_lg4_04.dbf' ; set newname for datafile 63 to '/u05/oradata/WE7C/tables_lg4_06.dbf' ; set newname for datafile 65 to '/u05/oradata/WE7C/tables_lg4_07.dbf' ; set newname for datafile 30 to '/u05/oradata/WE7C/tables_lg_01.dbf' ; set newname for datafile 31 to '/u05/oradata/WE7C/tables_lg_02.dbf' ; set newname for datafile 32 to '/u05/oradata/WE7C/tables_lg_03.dbf' ; set newname for datafile 33 to '/u05/oradata/WE7C/tables_lg_04.dbf' ; set newname for datafile 34 to '/u05/oradata/WE7C/tables_lg_05.dbf' ; set newname for datafile 35 to '/u05/oradata/WE7C/tables_lg_06.dbf' ; set newname for datafile 36 to '/u05/oradata/WE7C/tables_lg_07.dbf' ; set newname for datafile 104 to '/u05/oradata/WE7C/tables_lg_08.dbf' ; set newname for datafile 87 to '/u05/oradata/WE7C/tables_lg_09.dbf' ; set newname for datafile 88 to '/u05/oradata/WE7C/tables_lg_10.dbf' ; set newname for datafile 175 to '/u05/oradata/WE7C/tables_lg_12.dbf' ; set newname for datafile 158 to '/u05/oradata/WE7C/tables_lg_new.dbf' ; set newname for datafile 14 to '/u05/oradata/WE7C/tables_md1_01.dbf' ; set newname for datafile 15 to '/u05/oradata/WE7C/tables_md1_02.dbf' ; set newname for datafile 171 to '/u05/oradata/WE7C/tables_md1_03.dbf' ; set newname for datafile 186 to '/u05/oradata/WE7C/tables_md1_04.dbf' ; set newname for datafile 16 to '/u05/oradata/WE7C/tables_md2_01.dbf' ; set newname for datafile 17 to '/u05/oradata/WE7C/tables_md2_02.dbf' ; set newname for datafile 18 to '/u05/oradata/WE7C/tables_md2_03.dbf' ; set newname for datafile 161 to '/u05/oradata/WE7C/tables_md2_new.dbf' ; set newname for datafile 13 to '/u05/oradata/WE7C/tables_sm_02.dbf' ; set newname for datafile 187 to '/u05/oradata/WE7C/tables_sm_03.dbf' ; set newname for datafile 10 to '/u05/oradata/WE7C/tools_01.dbf' ; set newname for datafile 2 to '/u05/oradata/WE7C/undo_tbs_01.dbf' ; set newname for datafile 3 to '/u05/oradata/WE7C/undo_tbs_02.dbf' ; set newname for datafile 4 to '/u05/oradata/WE7C/undo_tbs_03.dbf' ; set newname for datafile 5 to '/u05/oradata/WE7C/undo_tbs_04.dbf' ; set newname for datafile 6 to '/u05/oradata/WE7C/undo_tbs_05.dbf' ; set newname for datafile 7 to '/u05/oradata/WE7C/undo_tbs_06.dbf' ; set newname for datafile 217 to '/u05/oradata/WE7C/undo_tbs_07.dbf' ; set newname for datafile 218 to '/u05/oradata/WE7C/undo_tbs_08.dbf' ; set newname for datafile 219 to '/u05/oradata/WE7C/undo_tbs_09.dbf' ; set newname for datafile 166 to '/u05/oradata/WE7C/undo_tbs_new.dbf' ; set newname for datafile 11 to '/u05/oradata/WE7C/users_01.dbf' ; set newname for datafile 215 to '/u05/oradata/WE7C/users_02.dbf' ; set newname for datafile 216 to '/u05/oradata/WE7C/users_03.dbf' ; SQL "ALTER DATABASE RENAME FILE ''/u08/oradata/WE7C/SYSTEM/redo01a.log'' TO ''/u02/oradata/WE7C/redo01a.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u04/oradata/WE7C/SYSTEM/redo01b.log'' TO ''/u03/oradata/WE7C/redo01b.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u04/oradata/WE7C/SYSTEM/redo04a.log'' TO ''/u02/oradata/WE7C/redo04a.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u07/oradata/WE7C/SYSTEM/redo04b.log'' TO ''/u03/oradata/WE7C/redo04b.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u03/oradata/WE7C/SYSTEM/redo03a.log'' TO ''/u02/oradata/WE7C/redo03a.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u06/oradata/WE7C/SYSTEM/redo03b.log'' TO ''/u03/oradata/WE7C/redo03b.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u02/oradata/WE7C/SYSTEM/redo02a.log'' TO ''/u02/oradata/WE7C/redo02a.log'' "; SQL "ALTER DATABASE RENAME FILE ''/u05/oradata/WE7C/SYSTEM/redo02b.log'' TO ''/u03/oradata/WE7C/redo02b.log'' "; restore database; switch datafile all ; } exit RMANTAG ERR=`egrep 'ORA-|RMAN-' ${RMAN_LOGFILE} |wc -l` if [ ${ERR} -gt 0 ] then echo "${ORACLE_SID} restore is having errors. Please check ${RMAN_LOGFILE}" > /tmp/m_file else echo "${ORACLE_SID} restore is successfull. Please do crosscheck ${RMAN_LOGFILE}" > /tmp/m_file fi mailx -s "!!....${ORACLE_SID} - RMAN Duplicate " "${MAIL_LIST}" < /tmp/m_file rm /tmp/m_file exit 0