Rman Cloning from Node1 to Node 2

RMAN CLONING FROM SERVER A to SERVER B

STEP1: TAKE COLD BACKUP ON SERVER A
STEP2:TRANSFER The Backuppiece from Server A to ServerB
STEP3:Restore the Controlfile from backuppiece restore controlfile from 'D:/DATA/bsdewd'
$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 12 06:50:26 2010

connected to target database: XYZ (not mounted)

RMAN> restore controlfile from 'D:/DATA/bsdewd';

Starting restore at 12-OCT-10
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1091 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=d:\oracle\ctl1.ora
output filename=d:\oracle\ctl2.ora
output filename=d:\oracle\ctl3.ora
output filename=d:\oracle\ctl4.ora
Finished restore at 12-OCT-10

STEP4: Mount the database.

STEP5: CATALOG Bacup Piece

RMAN> catalog backuppiece '/emcd03/oracle/ORACLE/SF0T/DATA/Full_SF2T_352_1_732061884';

cataloged backuppiece
backup piece handle=/emcd03/oracle/ORACLE/SF0T/DATA/Full_SF2T_352_1_732061884 recid=355 stamp=732178556

RMAN>catalog backuppiece '/emcd03/oracle/ORACLE/SF0T/DATA/Full_SF2T_353_1_732062341';

cataloged backuppiece
backup piece handle=/emcd03/oracle/ORACLE/SF0T/DATA/Full_SF2T_353_1_732062341 recid=356 stamp=732178559

STEP6: Restore all datafiles from backup piece

rman target /

run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
set newname for datafile 1 to 'd:\oracle\system_02.dbf';
set newname for datafile 2 to 'd:\oracle\system.dbf';
set newname for datafile 3 to 'd:\oracle\rollback.dbf';
set newname for datafile 4 to 'd:\oracle\system_03.dbf';
set newname for datafile 15 to 'd:\oracle\1_data8_01.dbf';
set newname for datafile 16 to 'd:\oracle\1_indx11_01.dbf';
set newname for datafile 17 to 'd:\oracle\1_indx14_06.dbf';
set newname for datafile 18 to 'd:\oracle\1_indx16_01.dbf';
set newname for datafile 21 to 'd:\oracle\1_indx18_05.dbf';
set newname for datafile 5 to 'd:\oracle\tools.dbf';
set newname for datafile 6 to 'd:\oracle\users.dbf';
set newname for datafile 7 to 'd:\oracle\DRSYS1.dbf';
set newname for datafile 8 to 'd:\oracle\DRSYS2.dbf';
set newname for datafile 9 to 'd:\oracle\PERF1.dbf';
set newname for datafile 10 to 'd:\oracle\S_PRECISE_DATA_01.dbf';
set newname for datafile 11 to 'd:\oracle\S_PRECISE_INDX_01.dbf';
set newname for datafile 12 to 'd:\oracle\S_SF_DATA_RT1.dbf';
set newname for datafile 13 to 'd:\oracle\1_data1_01.dbf';
set newname for datafile 14 to 'd:\oracle\1_data1_02.dbf';
set newname for datafile 22 to 'd:\oracle\1_indx2_08.dbf';
set newname for datafile 23 to 'd:\oracle\1_indx20_01.dbf';
set newname for datafile 28 to 'd:\oracle\1_indx23_01.dbf';
set newname for datafile 29 to 'd:\oracle\1_indx21_01.dbf';
set newname for datafile 19 to 'd:\oracle\1_data10_01.dbf';
set newname for datafile 20 to 'd:\oracle\1_data10_02.dbf';
set newname for datafile 30 to 'd:\oracle\1_indx25_01.dbf';
set newname for datafile 31 to 'd:\oracle\1_indx27_01.dbf';
set newname for datafile 32 to 'd:\oracle\1_indx30_01.dbf';
set newname for datafile 24 to 'd:\oracle\VERITAS_I3_ORCL.dbf';
set newname for datafile 25 to 'd:\oracle\S_PRECISE_TEMP_01.dbf';
set newname for datafile 26 to 'd:\oracle\1_data12_01.dbf';
set newname for datafile 27 to 'd:\oracle\1_data12_02.dbf';
set newname for datafile 35 to 'd:\oracle\1_indx32_01.dbf';
set newname for datafile 36 to 'd:\oracle\1_indx34_01.dbf';
set newname for datafile 37 to 'd:\oracle\1_indx36_04.dbf';
set newname for datafile 40 to 'd:\oracle\1_indx37_01.dbf';
set newname for datafile 41 to 'd:\oracle\1_indx39_01.dbf';
set newname for datafile 33 to 'd:\oracle\1_data13_01.dbf';
set newname for datafile 34 to 'd:\oracle\1_data13_02.dbf';
set newname for datafile 44 to 'd:\oracle\1_indx4_01.dbf';
set newname for datafile 45 to 'd:\oracle\1_indx41_04.dbf';
set newname for datafile 46 to 'd:\oracle\1_indx5_01.dbf';
set newname for datafile 38 to 'd:\oracle\1_data15_01.dbf';
set newname for datafile 39 to 'd:\oracle\1_data15_02.dbf';
set newname for datafile 47 to 'd:\oracle\1_indx7_01.dbf';
set newname for datafile 50 to 'd:\oracle\1_indx7_10.dbf';
set newname for datafile 42 to 'd:\oracle\1_data17_01.dbf';
set newname for datafile 43 to 'd:\oracle\1_data17_02.dbf';
set newname for datafile 51 to 'd:\oracle\1_indx9_01.dbf';
set newname for datafile 52 to 'd:\oracle\1_data6_03.dbf';
set newname for datafile 53 to 'd:\oracle\1_data6_01.dbf';
set newname for datafile 60 to 'd:\oracle\1_data6_02.dbf';
set newname for datafile 48 to 'd:\oracle\1_data19_01.dbf';
set newname for datafile 49 to 'd:\oracle\1_data19_02.dbf';
set newname for datafile 67 to 'd:\oracle\1_data5_04.dbf';
set newname for datafile 54 to 'd:\oracle\1_data_01.dbf';
set newname for datafile 55 to 'd:\oracle\1_data2_02.dbf';
set newname for datafile 56 to 'd:\oracle\1_data2_03.dbf';
set newname for datafile 57 to 'd:\oracle\f_data22_03.dbf';
set newname for datafile 58 to 'd:\oracle\1_data22_01.dbf';
set newname for datafile 59 to 'd:\oracle\1_data22_02.dbf';
set newname for datafile 61 to 'd:\oracle\1_data24_01.dbf';
set newname for datafile 62 to 'd:\oracle\1_data24_02.dbf';
set newname for datafile 63 to 'd:\oracle\1_data24_03.dbf';
set newname for datafile 64 to 'd:\oracle\1_data24_04.dbf';
set newname for datafile 65 to 'd:\oracle\1_data26_01.dbf';
set newname for datafile 66 to 'd:\oracle\1_data26_02.dbf';
set newname for datafile 69 to 'd:\oracle\1_data28_01.dbf';
set newname for datafile 70 to 'd:\oracle\1_data28_02.dbf';
set newname for datafile 75 to 'd:\oracle\1_data29_01.dbf';
set newname for datafile 76 to 'd:\oracle\1_data29_02.dbf';
set newname for datafile 80 to 'd:\oracle\1_data3_01.dbf';
set newname for datafile 81 to 'd:\oracle\1_data3_02.dbf';
set newname for datafile 85 to 'd:\oracle\1_data31_01.dbf';
set newname for datafile 86 to 'd:\oracle\1_data31_02.dbf';
set newname for datafile 89 to 'd:\oracle\1_data33_01.dbf';
set newname for datafile 90 to 'd:\oracle\1_data33_02.dbf';
set newname for datafile 96 to 'd:\oracle\1_data35_01.dbf';
set newname for datafile 97 to 'd:\oracle\1_data35_02.dbf';
set newname for datafile 100 to 'd:\oracle\1_data38_01.dbf';
set newname for datafile 101 to 'd:\oracle\1_data38_02.dbf';
set newname for datafile 105 to 'd:\oracle\1_data40_01.dbf';
set newname for datafile 106 to 'd:\oracle\1_data40_02.dbf';
set newname for datafile 110 to 'd:\oracle\1_data42_01.dbf';
set newname for datafile 111 to 'd:\oracle\1_data42_02.dbf';
set newname for tempfile 1 to 'd:\oracle\temp01.dbf';
restore database;
recover database noredo;
switch datafile all;
switch tempfile all;
release channel c1;
release channel c2;
}
STEP7: alter database open resetlogs.