Input
Group:
Erecords:
Copy:
ADC R2:
Replication volumes:
Replication set: RSet 1
Replication size: 50.00GB
SAN Info:
50.00GB DGC VRAID CX4-960 LUN 1040 (1040) 60,06,01,60,32,bb,21,00,84,a0,08,b1,da,ec,df,11 0x96e839c701a4584f
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b203c15 SP-A APM00104200916 32
1 0 500601693b203c15 SP-B APM00104200916 32
1 3 500601613b203c15 SP-A APM00104200916 32
2 3 500601683b203c15 SP-B APM00104200916 32
Replication set: RSet 10
Replication size: 900.00GB
SAN Info:
900.00GB DGC VRAID CX4-960 LUN 1153 (1153) 60,06,01,60,32,bb,21,00,6a,d7,a9,29,f8,65,e0,11 0x447102a705ca7505
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b203c15 SP-A APM00104200916 46
1 0 500601693b203c15 SP-B APM00104200916 46
1 3 500601613b203c15 SP-A APM00104200916 46
2 3 500601683b203c15 SP-B APM00104200916 46
Replication set: RSet 11
Replication size: 50.00GB
SAN Info:
50.00GB DGC VRAID CX4-960 LUN 1114 (1114) 60,06,01,60,32,bb,21,00,36,e8,cb,58,44,ec,df,11 0xe448ff38046c7c02
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b203c15 SP-A APM00104200916 54
1 0 500601693b203c15 SP-B APM00104200916 54
1 3 500601613b203c15 SP-A APM00104200916 54
2 3 500601683b203c15 SP-B APM00104200916 54
Journal volumes:
SAN Info:
20.00GB DGC VRAID CX4-960 LUN 3008 (3008) 60,06,01,60,32,bb,21,00,2c,cb,8d,0d,a0,5b,e0,11 0xfaadda2c7f0b6b38
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b203c15 SP-A APM00104200916 14
1 0 500601693b203c15 SP-B APM00104200916 14
1 3 500601613b203c15 SP-A APM00104200916 14
2 3 500601683b203c15 SP-B APM00104200916 14
CNJ R1:
Replication volumes:
Replication set: RSet 1
Replication size: 50.00GB
SAN Info:
50.00GB DGC VRAID CX4-960 LUN 19 (19) 60,06,01,60,f8,7b,21,00,4e,c0,62,26,45,ec,df,11 0x384ade8bcd121455
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b206fe3 SP-A APM00104000792 6
1 0 500601693b206fe3 SP-B APM00104000792 6
1 2 500601613b206fe3 SP-A APM00104000792 6
2 2 500601683b206fe3 SP-B APM00104000792 6
Replication set: RSet 10
Replication size: 900.00GB
SAN Info:
900.00GB DGC VRAID CX4-960 LUN 153 (153) 60,06,01,60,42,84,1e,00,d2,de,e2,71,69,38,e0,11 0x229fa2716b3bd65c
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b206fe3 SP-A APM00104000792 37
1 0 500601693b206fe3 SP-B APM00104000792 37
1 2 500601613b206fe3 SP-A APM00104000792 37
2 2 500601683b206fe3 SP-B APM00104000792 37
Replication set: RSet 11
Replication size: 50.00GB
SAN Info:
50.00GB DGC VRAID CX4-960 LUN 14 (14) 60,06,01,60,f8,7b,21,00,6e,7c,f4,f5,43,ec,df,11 0x2e110e4a707e364d
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b206fe3 SP-A APM00104000792 39
1 0 500601693b206fe3 SP-B APM00104000792 39
1 2 500601613b206fe3 SP-A APM00104000792 39
2 2 500601683b206fe3 SP-B APM00104000792 39
Journal volumes:
SAN Info:
20.00GB DGC VRAID CX4-960 LUN 3009 (3009) 60,06,01,60,42,84,1e,00,c8,b8,e7,2c,6f,5c,e0,11 0x4271daf012ded464
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b206fe3 SP-A APM00104000792 21
1 0 500601693b206fe3 SP-B APM00104000792 21
1 2 500601613b206fe3 SP-A APM00104000792 21
2 2 500601683b206fe3 SP-B APM00104000792 21
RMAN:
Copy:
ADC R2:
Replication volumes:
Replication set: RSet 1
Replication size: 0.97TB
SAN Info:
0.97TB DGC RAID 5 CX4-960 M 1010 (1010) 60,06,01,60,f9,f6,22,00,1c,e5,9f,b8,90,f4,dd,11 0x6756f6a64c132e15
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601613b20135c SP-A APM00084900375 3
1 0 500601683b20135c SP-B APM00084900375 3
1 3 500601603b20135c SP-A APM00084900375 3
2 3 500601693b20135c SP-B APM00084900375 3
Journal volumes:
SAN Info:
20.00GB DGC VRAID CX4-960 LUN 3002 (3002) 60,06,01,60,01,7b,25,00,16,d0,a1,37,e3,56,e0,11 0xfd88b419c2c2655
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b203c15 SP-A APM00104200916 8
1 0 500601693b203c15 SP-B APM00104200916 8
1 3 500601613b203c15 SP-A APM00104200916 8
2 3 500601683b203c15 SP-B APM00104200916 8
CNJ R1:
Replication volumes:
Replication set: RSet 1
Replication size: 0.97TB
SAN Info:
0.97TB DGC RAID 5 CX4-960 M 10 (10) 60,06,01,60,0d,de,22,00,da,46,be,8c,83,f4,dd,11 0xdfe09df54ca00bcb
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b20148b SP-A FNM00085200014 5
1 0 500601693b20148b SP-B FNM00085200014 5
1 2 500601613b20148b SP-A FNM00085200014 5
2 2 500601683b20148b SP-B FNM00085200014 5
Journal volumes:
SAN Info:
20.00GB DGC VRAID CX4-960 LUN 3011 (3011) 60,06,01,60,42,84,1e,00,cc,b8,e7,2c,6f,5c,e0,11 0xe62c280adfe83332
RPA Port WWN Ctrl Serial LUN
-------------------------------------------------------
1 0 500601603b206fe3 SP-A APM00104000792 23
1 0 500601693b206fe3 SP-B APM00104000792 23
1 2 500601613b206fe3 SP-A APM00104000792 23
2 2 500601683b206fe3 SP-B APM00104000792 23
Ouput needed
APM00104000792,Erecords,CNJ R1,RSet1,LUN 19,50.00GB,APM00104200916,ADC R2,LUN 1040
APM00104000792,Erecords,CNJ R1,RSet10,LUN 153,50.00GB,APM00104200916,ADC R2,LUN 1153
APM00104000792,Erecords,CNJ R1,RSet11,LUN 14,50.00GB,APM00104200916,ADC R2,LUN 1114
FNM00085200014,RMAN,CNJ R1,RSet1,M 10,0.97TB,APM00084900375,ADC R2,M 1010
APM00104000792,Erecords,Journal volumes,LUN 3009,20.00GB
APM00104200916,Erecords,Journal volumes,LUN 3008,20.00GB
APM00104200916,RMAN,Journal volumes,LUN 3002,20.00GB
APM00104000792,RMAN,Journal volumes,LUN 3011,20.00GB
Records i want to grab are in RED .Pls note records like RMAN,Erecords,ADC R2,CNJ R1 may not be same and can change
thx
---------- Post updated 04-20-11 at 10:49 AM ---------- Previous update was 04-19-11 at 10:54 AM ----------
Tried this ..... not getting me the desired result
nawk 'BEGIN{ RS="\n"}
/Group:/ { getline ; grp=$NF ;getline ;getline; ;dee=$0 }
/Replication set:/ { SOU=$3" "$4 }
/Replication size:/ { TGT=$3 }
/DGC/ { STS=$5" "$6 }
/SP-A/ { CLA=$5
printf "%s\n",grp","dee","SOU","TGT","STS
FS=" "
}' file
Erecords:, ADC R2: ,APM00104200916,RSet 1,50.00GB,LUN 1040
Erecords:, ADC R2: ,APM00104200916,RSet 1,50.00GB,LUN 1040
Erecords:, ADC R2: ,APM00104200916,RSet 10,900.00GB,LUN 1153
Erecords:, ADC R2: ,APM00104200916,RSet 10,900.00GB,LUN 1153
Erecords:, ADC R2: ,APM00104200916,RSet 11,50.00GB,LUN 1114
Erecords:, ADC R2: ,APM00104200916,RSet 11,50.00GB,LUN 1114
Erecords:, ADC R2: ,APM00104200916,RSet 11,50.00GB,LUN 3008
Erecords:, ADC R2: ,APM00104200916,RSet 11,50.00GB,LUN 3008
Erecords:, ADC R2: ,APM00104000792,RSet 1,50.00GB,LUN 19
Erecords:, ADC R2: ,APM00104000792,RSet 1,50.00GB,LUN 19
Erecords:, ADC R2: ,APM00104000792,RSet 10,900.00GB,LUN 153
Erecords:, ADC R2: ,APM00104000792,RSet 10,900.00GB,LUN 153
Erecords:, ADC R2: ,APM00104000792,RSet 11,50.00GB,LUN 14
Erecords:, ADC R2: ,APM00104000792,RSet 11,50.00GB,LUN 14
Erecords:, ADC R2: ,APM00104000792,RSet 11,50.00GB,LUN 3009
Erecords:, ADC R2: ,APM00104000792,RSet 11,50.00GB,LUN 3009