课程第23次
Notice: This blog is written by Bo Tang.1. 颗粒化（AU可以在磁盘组的磁盘间自由流动）
2. 镜像化
3. 条带化
select* from v$asm_diskgroup;
select* from v$asm_filewheregroup_number=1
order by
2,4 ;
select* from v$asm_alias
where group_number=1 and file_number=277;
$ asmcmd ls +data/orcl/datafile |sort -t . -k 3 -n
SYSAUX.257.1017747273
SYSTEM.256.1017747273
USERS.259.1017747273
EXAMPLE.265.1017747369
TBS1.267.1017789135
TBS2.268.1022104451
TBS4.269.1022107971
TBS5.270.1022108063
TBS4.271.1022108093
TBS16K.272.1022119203
TBS_NOCOMPRESSION.273.1022129913
TBS_BASIC.274.1022129945
TBS_OLTP.275.1022129967
TBS6.276.1022136411
TBSAUDIT.277.1022182039
UNDOTBS1.264.1022254567
HIGH DISKGROUP得有多少个fail_group(顺便定2M AU)？：between3 anddisk number
# dd if=/dev/zero of=highdata1.imgbs=150Mcount=1
1+0 records in
1+0 records out
157286400 bytes (157 MB) copied, 0.941926 s, 167 MB/s
# dd if=/dev/zero of=highdata2.imgbs=150Mcount=1
1+0 records in
1+0 records out
157286400 bytes (157 MB) copied, 0.320499 s, 491 MB/s
<div># dd if=/dev/zero of=highdata3.imgbs=150Mcount=1</div><div>.......</div># losetup /dev/loop0/root/highdata1.img
# losetup /dev/loop1/root/highdata2.img
# losetup /dev/loop2/root/highdata3.img# oracleasm creatediskASMDISK06 /dev/loop0
Writing disk header: done
Instantiating disk: done
# oracleasm creatediskASMDISK07 /dev/loop1
Writing disk header: done
Instantiating disk: done
# oracleasm creatediskASMDISK08 /dev/loop2
Writing disk header: done
.......
# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
select* from v$asm_disk;
create diskgroup highdata high redundancy
failgroup failgroup1disk 'ORCL:ASMDISK06' , 'ORCL:ASMDISK07'
failgroup failgroup2disk 'ORCL:ASMDISK08' , 'ORCL:ASMDISK09'
failgroup failgroup3disk 'ORCL:ASMDISK10' , 'ORCL:ASMDISK11'
attribute'au_size'='2M';select* from v$asm_disk;
select* fromv$asm_client;
GROUP_NUMBERINSTANCE_NAMEDB_NAMESTATUSSOFTWARE_VERSIONCOMPATIBLE_VERSION
11+ASM+ASMCONNECTED11.2.0.4.011.2.0.4.0
21orclorclCONNECTED11.2.0.4.011.2.0.4.0
32orclorclCONNECTED11.2.0.4.011.2.0.4.0
select* fromv$asm_attribute;
NAMEVALUEGROUP_NUMBERATTRIBUTE_INDEXATTRIBUTE_INCARNATIONREAD_ONLYSYSTEM_CREATED
1disk_repair_time3.6h101NY
2au_size1048576151YY
3sector_size512161YY
4compatible.asm11.2.0.0.01201NY
5compatible.rdbms10.1.0.0.01211NY
6cell.smart_scan_capableFALSE1301NN
7access_control.enabledFALSE1401NY
8access_control.umask0661411NY
9template_version1866465281501NY
10template.PARAMETERFILE.stripe01711NY
11template.PARAMETERFILE.redundancy181741NY
12template.PARAMETERFILE.primary_region01751NY
13template.PARAMETERFILE.mirror_region01761NY
14template.ASMPARAMETERFILE.stripe01811NY
15template.ASMPARAMETERFILE.redundancy181841NY
16template.ASMPARAMETERFILE.primary_region01851NY
17template.ASMPARAMETERFILE.mirror_region01861NY
18template.DUMPSET.stripe011011NY
19template.DUMPSET.redundancy1811041NY
20template.DUMPSET.primary_region011051NY
21template.DUMPSET.mirror_region011061NY
22template.CONTROLFILE.stripe111111NY
23template.CONTROLFILE.redundancy1911141NY
24template.CONTROLFILE.primary_region011151NY
25template.CONTROLFILE.mirror_region011161NY
26template.FLASHFILE.stripe011211NY
27template.FLASHFILE.redundancy1811241NY
28template.FLASHFILE.primary_region011251NY
29template.FLASHFILE.mirror_region011261NY
30template.ARCHIVELOG.stripe011311NY
31template.ARCHIVELOG.redundancy1811341NY
32template.ARCHIVELOG.primary_region011351NY
33template.ARCHIVELOG.mirror_region011361NY
34template.ONLINELOG.stripe011411NY
35template.ONLINELOG.redundancy1811441NY
36template.ONLINELOG.primary_region011451NY
37template.ONLINELOG.mirror_region011461NY
38template.DATAFILE.stripe011511NY
39template.DATAFILE.redundancy1811541NY
40template.DATAFILE.primary_region011551NY
41template.DATAFILE.mirror_region011561NY
42template.TEMPFILE.stripe011611NY
43template.TEMPFILE.redundancy1811641NY
44template.TEMPFILE.primary_region011651NY
45template.TEMPFILE.mirror_region011661NY
46template.BACKUPSET.stripe011811NY
47template.BACKUPSET.redundancy1811841NY
48template.BACKUPSET.primary_region011851NY
49template.BACKUPSET.mirror_region011861NY
50template.XTRANSPORT BACKUPSET.stripe011911NY
51template.XTRANSPORT BACKUPSET.redundancy1811941NY
52template.XTRANSPORT BACKUPSET.primary_region011951NY
53template.XTRANSPORT BACKUPSET.mirror_region011961NY
54template.AUTOBACKUP.stripe012011NY
55template.AUTOBACKUP.redundancy1812041NY
56template.AUTOBACKUP.primary_region012051NY
57template.AUTOBACKUP.mirror_region012061NY
58template.XTRANSPORT.stripe012111NY
59template.XTRANSPORT.redundancy1812141NY
60template.XTRANSPORT.primary_region012151NY
61template.XTRANSPORT.mirror_region012161NY
62template.CHANGETRACKING.stripe012211NY
63template.CHANGETRACKING.redundancy1812241NY
64template.CHANGETRACKING.primary_region012251NY
65template.CHANGETRACKING.mirror_region012261NY
66template.FLASHBACK.stripe012311NY
67template.FLASHBACK.redundancy1812341NY
68template.FLASHBACK.primary_region012351NY
69template.FLASHBACK.mirror_region012361NY
70template.DATAGUARDCONFIG.stripe012411NY
71template.DATAGUARDCONFIG.redundancy1812441NY
72template.DATAGUARDCONFIG.primary_region012451NY
73template.DATAGUARDCONFIG.mirror_region012461NY
74template.OCRFILE.stripe012511NY
75template.OCRFILE.redundancy1812541NY
76template.OCRFILE.primary_region012551NY
77template.OCRFILE.mirror_region012561NY
78disk_repair_time3.6h201NY
79au_size1048576251YY
80sector_size512261YY
81compatible.asm11.2.0.0.02201NY
82compatible.rdbms10.1.0.0.02211NY
83cell.smart_scan_capableFALSE2301NN
84access_control.enabledFALSE2401NY
85access_control.umask0662411NY
86template_version1866465282501NY
87template.PARAMETERFILE.stripe02711NY
88template.PARAMETERFILE.redundancy172741NY
89template.PARAMETERFILE.primary_region02751NY
90template.PARAMETERFILE.mirror_region02761NY
91template.ASMPARAMETERFILE.stripe02811NY
92template.ASMPARAMETERFILE.redundancy172841NY
93template.ASMPARAMETERFILE.primary_region02851NY
94template.ASMPARAMETERFILE.mirror_region02861NY
95template.DUMPSET.stripe021011NY
96template.DUMPSET.redundancy1721041NY
97template.DUMPSET.primary_region021051NY
98template.DUMPSET.mirror_region021061NY
99template.CONTROLFILE.stripe121111NY
100template.CONTROLFILE.redundancy1721141NY
101template.CONTROLFILE.primary_region021151NY
102template.CONTROLFILE.mirror_region021161NY
103template.FLASHFILE.stripe021211NY
104template.FLASHFILE.redundancy1721241NY
105template.FLASHFILE.primary_region021251NY
106template.FLASHFILE.mirror_region021261NY
107template.ARCHIVELOG.stripe021311NY
108template.ARCHIVELOG.redundancy1721341NY
109template.ARCHIVELOG.primary_region021351NY
110template.ARCHIVELOG.mirror_region021361NY
111template.ONLINELOG.stripe021411NY
112template.ONLINELOG.redundancy1721441NY
113template.ONLINELOG.primary_region021451NY
114template.ONLINELOG.mirror_region021461NY
115template.DATAFILE.stripe021511NY
116template.DATAFILE.redundancy1721541NY
117template.DATAFILE.primary_region021551NY
118template.DATAFILE.mirror_region021561NY
119template.TEMPFILE.stripe021611NY
120template.TEMPFILE.redundancy1721641NY
121template.TEMPFILE.primary_region021651NY
122template.TEMPFILE.mirror_region021661NY
123template.BACKUPSET.stripe021811NY
124template.BACKUPSET.redundancy1721841NY
125template.BACKUPSET.primary_region021851NY
126template.BACKUPSET.mirror_region021861NY
127template.XTRANSPORT BACKUPSET.stripe021911NY
128template.XTRANSPORT BACKUPSET.redundancy1721941NY
129template.XTRANSPORT BACKUPSET.primary_region021951NY
130template.XTRANSPORT BACKUPSET.mirror_region021961NY
131template.AUTOBACKUP.stripe022011NY
132template.AUTOBACKUP.redundancy1722041NY
133template.AUTOBACKUP.primary_region022051NY
134template.AUTOBACKUP.mirror_region022061NY
135template.XTRANSPORT.stripe022111NY
136template.XTRANSPORT.redundancy1722141NY
137template.XTRANSPORT.primary_region022151NY
138template.XTRANSPORT.mirror_region022161NY
139template.CHANGETRACKING.stripe022211NY
140template.CHANGETRACKING.redundancy1722241NY
141template.CHANGETRACKING.primary_region022251NY
142template.CHANGETRACKING.mirror_region022261NY
143template.FLASHBACK.stripe022311NY
144template.FLASHBACK.redundancy1722341NY
145template.FLASHBACK.primary_region022351NY
146template.FLASHBACK.mirror_region022361NY
147template.DATAGUARDCONFIG.stripe022411NY
148template.DATAGUARDCONFIG.redundancy1722441NY
149template.DATAGUARDCONFIG.primary_region022451NY
150template.DATAGUARDCONFIG.mirror_region022461NY
151template.OCRFILE.stripe022511NY
152template.OCRFILE.redundancy1722541NY
153template.OCRFILE.primary_region022551NY
154template.OCRFILE.mirror_region022561NY
select * from v$asm_diskgroup;
alter diskgroup highdataset attribute'compatible.asm'='11.2';select* fromv$asm_attribute;
NAMEVALUEGROUP_NUMBERATTRIBUTE_INDEXATTRIBUTE_INCARNATIONREAD_ONLYSYSTEM_CREATED
1disk_repair_time3.6h101NY
2au_size1048576151YY
3sector_size512161YY
4compatible.asm11.2.0.0.01201NY
5compatible.rdbms10.1.0.0.01211NY
6cell.smart_scan_capableFALSE1301NN
7access_control.enabledFALSE1401NY
8access_control.umask0661411NY
9template_version1866465281501NY
10template.PARAMETERFILE.stripe01711NY
11template.PARAMETERFILE.redundancy181741NY
12template.PARAMETERFILE.primary_region01751NY
13template.PARAMETERFILE.mirror_region01761NY
14template.ASMPARAMETERFILE.stripe01811NY
15template.ASMPARAMETERFILE.redundancy181841NY
16template.ASMPARAMETERFILE.primary_region01851NY
17template.ASMPARAMETERFILE.mirror_region01861NY
18template.DUMPSET.stripe011011NY
19template.DUMPSET.redundancy1811041NY
20template.DUMPSET.primary_region011051NY
21template.DUMPSET.mirror_region011061NY
22template.CONTROLFILE.stripe111111NY
23template.CONTROLFILE.redundancy1911141NY
24template.CONTROLFILE.primary_region011151NY
25template.CONTROLFILE.mirror_region011161NY
26template.FLASHFILE.stripe011211NY
27template.FLASHFILE.redundancy1811241NY
28template.FLASHFILE.primary_region011251NY
29template.FLASHFILE.mirror_region011261NY
30template.ARCHIVELOG.stripe011311NY
31template.ARCHIVELOG.redundancy1811341NY
32template.ARCHIVELOG.primary_region011351NY
33template.ARCHIVELOG.mirror_region011361NY
34template.ONLINELOG.stripe011411NY
35template.ONLINELOG.redundancy1811441NY
36template.ONLINELOG.primary_region011451NY
37template.ONLINELOG.mirror_region011461NY
38template.DATAFILE.stripe011511NY
39template.DATAFILE.redundancy1811541NY
40template.DATAFILE.primary_region011551NY
41template.DATAFILE.mirror_region011561NY
42template.TEMPFILE.stripe011611NY
43template.TEMPFILE.redundancy1811641NY
44template.TEMPFILE.primary_region011651NY
45template.TEMPFILE.mirror_region011661NY
46template.BACKUPSET.stripe011811NY
47template.BACKUPSET.redundancy1811841NY
48template.BACKUPSET.primary_region011851NY
49template.BACKUPSET.mirror_region011861NY
50template.XTRANSPORT BACKUPSET.stripe011911NY
51template.XTRANSPORT BACKUPSET.redundancy1811941NY
52template.XTRANSPORT BACKUPSET.primary_region011951NY
53template.XTRANSPORT BACKUPSET.mirror_region011961NY
54template.AUTOBACKUP.stripe012011NY
55template.AUTOBACKUP.redundancy1812041NY
56template.AUTOBACKUP.primary_region012051NY
57template.AUTOBACKUP.mirror_region012061NY
58template.XTRANSPORT.stripe012111NY
59template.XTRANSPORT.redundancy1812141NY
60template.XTRANSPORT.primary_region012151NY
61template.XTRANSPORT.mirror_region012161NY
62template.CHANGETRACKING.stripe012211NY
63template.CHANGETRACKING.redundancy1812241NY
64template.CHANGETRACKING.primary_region012251NY
65template.CHANGETRACKING.mirror_region012261NY
66template.FLASHBACK.stripe012311NY
67template.FLASHBACK.redundancy1812341NY
68template.FLASHBACK.primary_region012351NY
69template.FLASHBACK.mirror_region012361NY
70template.DATAGUARDCONFIG.stripe012411NY
71template.DATAGUARDCONFIG.redundancy1812441NY
72template.DATAGUARDCONFIG.primary_region012451NY
73template.DATAGUARDCONFIG.mirror_region012461NY
74template.OCRFILE.stripe012511NY
75template.OCRFILE.redundancy1812541NY
76template.OCRFILE.primary_region012551NY
77template.OCRFILE.mirror_region012561NY
78disk_repair_time3.6h201NY
79au_size1048576251YY
80sector_size512261YY
81compatible.asm11.2.0.0.02201NY
82compatible.rdbms10.1.0.0.02211NY
83cell.smart_scan_capableFALSE2301NN
84access_control.enabledFALSE2401NY
85access_control.umask0662411NY
86template_version1866465282501NY
87template.PARAMETERFILE.stripe02711NY
88template.PARAMETERFILE.redundancy172741NY
89template.PARAMETERFILE.primary_region02751NY
90template.PARAMETERFILE.mirror_region02761NY
91template.ASMPARAMETERFILE.stripe02811NY
92template.ASMPARAMETERFILE.redundancy172841NY
93template.ASMPARAMETERFILE.primary_region02851NY
94template.ASMPARAMETERFILE.mirror_region02861NY
95template.DUMPSET.stripe021011NY
96template.DUMPSET.redundancy1721041NY
97template.DUMPSET.primary_region021051NY
98template.DUMPSET.mirror_region021061NY
99template.CONTROLFILE.stripe121111NY
100template.CONTROLFILE.redundancy1721141NY
101template.CONTROLFILE.primary_region021151NY
102template.CONTROLFILE.mirror_region021161NY
103template.FLASHFILE.stripe021211NY
104template.FLASHFILE.redundancy1721241NY
105template.FLASHFILE.primary_region021251NY
106template.FLASHFILE.mirror_region021261NY
107template.ARCHIVELOG.stripe021311NY
108template.ARCHIVELOG.redundancy1721341NY
109template.ARCHIVELOG.primary_region021351NY
110template.ARCHIVELOG.mirror_region021361NY
111template.ONLINELOG.stripe021411NY
112template.ONLINELOG.redundancy1721441NY
113template.ONLINELOG.primary_region021451NY
114template.ONLINELOG.mirror_region021461NY
115template.DATAFILE.stripe021511NY
116template.DATAFILE.redundancy1721541NY
117template.DATAFILE.primary_region021551NY
118template.DATAFILE.mirror_region021561NY
119template.TEMPFILE.stripe021611NY
120template.TEMPFILE.redundancy1721641NY
121template.TEMPFILE.primary_region021651NY
122template.TEMPFILE.mirror_region021661NY
123template.BACKUPSET.stripe021811NY
124template.BACKUPSET.redundancy1721841NY
125template.BACKUPSET.primary_region021851NY
126template.BACKUPSET.mirror_region021861NY
127template.XTRANSPORT BACKUPSET.stripe021911NY
128template.XTRANSPORT BACKUPSET.redundancy1721941NY
129template.XTRANSPORT BACKUPSET.primary_region021951NY
130template.XTRANSPORT BACKUPSET.mirror_region021961NY
131template.AUTOBACKUP.stripe022011NY
132template.AUTOBACKUP.redundancy1722041NY
133template.AUTOBACKUP.primary_region022051NY
134template.AUTOBACKUP.mirror_region022061NY
135template.XTRANSPORT.stripe022111NY
136template.XTRANSPORT.redundancy1722141NY
137template.XTRANSPORT.primary_region022151NY
138template.XTRANSPORT.mirror_region022161NY
139template.CHANGETRACKING.stripe022211NY
140template.CHANGETRACKING.redundancy1722241NY
141template.CHANGETRACKING.primary_region022251NY
142template.CHANGETRACKING.mirror_region022261NY
143template.FLASHBACK.stripe022311NY
144template.FLASHBACK.redundancy1722341NY
145template.FLASHBACK.primary_region022351NY
146template.FLASHBACK.mirror_region022361NY
147template.DATAGUARDCONFIG.stripe022411NY
148template.DATAGUARDCONFIG.redundancy1722441NY
149template.DATAGUARDCONFIG.primary_region022451NY
150template.DATAGUARDCONFIG.mirror_region022461NY
151template.OCRFILE.stripe022511NY
152template.OCRFILE.redundancy1722541NY
153template.OCRFILE.primary_region022551NY
154template.OCRFILE.mirror_region022561NY
155disk_repair_time3.6h301NY
156au_size2097152351YY
157sector_size512361YY
158compatible.asm11.2.0.0.03201NY
159compatible.rdbms10.1.0.0.03211NY
160cell.smart_scan_capableFALSE3301NN
161access_control.enabledFALSE3401NY
162access_control.umask0663411NY
select* fromv$asm_template
where group_number=3;
GROUP_NUMBERENTRY_NUMBERREDUNDANCYSTRIPESYSTEMNAMEPRIMARY_REGIONMIRROR_REGION
130HIGHCOARSEYPARAMETERFILECOLDCOLD
231HIGHCOARSEYASMPARAMETERFILECOLDCOLD
333HIGHCOARSEYDUMPSETCOLDCOLD
434HIGHFINEYCONTROLFILECOLDCOLD
535HIGHCOARSEYFLASHFILECOLDCOLD
636HIGHCOARSEYARCHIVELOGCOLDCOLD
737HIGHCOARSEYONLINELOGCOLDCOLD
838HIGHCOARSEYDATAFILECOLDCOLD
939HIGHCOARSEYTEMPFILECOLDCOLD
10310HIGHCOARSEYBACKUPSETCOLDCOLD
11311HIGHCOARSEYXTRANSPORT BACKUPSETCOLDCOLD
12312HIGHCOARSEYAUTOBACKUPCOLDCOLD
13313HIGHCOARSEYXTRANSPORTCOLDCOLD
14314HIGHCOARSEYCHANGETRACKINGCOLDCOLD
15315HIGHCOARSEYFLASHBACKCOLDCOLD
16316HIGHCOARSEYDATAGUARDCONFIGCOLDCOLD
17317HIGHCOARSEYOCRFILECOLDCOLD
页:
[1]