开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4084-11g管理类OCP认证班第八期（WDP提速） › 课程第23次
返回列表 发新帖
查看: 1694|回复: 0

课程第23次

[复制链接]
secoug

27

主题

27

帖子

183

积分

超级版主

Rank: 8Rank: 8

积分
183
发表于 2019-11-20 20:24:49 | 显示全部楼层 |阅读模式
Notice: This blog is written by Bo Tang.

1. 颗粒化（AU可以在磁盘组的磁盘间自由流动）

2. 镜像化
3. 条带化
  1. select  * from v$asm_diskgroup;
复制代码
A1.png

  1. select  * from v$asm_file  where  group_number=1
  2. order by
  3.   2,4 ;
复制代码

A2.png

  1. select  * from v$asm_alias
  2.   where group_number=1 and file_number=277;
复制代码

A3.png

  1. [oracle@station79 ~]$ asmcmd ls +data/orcl/datafile |sort -t . -k 3 -n
  2. SYSAUX.257.1017747273
  3. SYSTEM.256.1017747273
  4. USERS.259.1017747273
  5. EXAMPLE.265.1017747369
  6. TBS1.267.1017789135
  7. TBS2.268.1022104451
  8. TBS4.269.1022107971
  9. TBS5.270.1022108063
  10. TBS4.271.1022108093
  11. TBS16K.272.1022119203
  12. TBS_NOCOMPRESSION.273.1022129913
  13. TBS_BASIC.274.1022129945
  14. TBS_OLTP.275.1022129967
  15. TBS6.276.1022136411
  16. TBSAUDIT.277.1022182039
  17. UNDOTBS1.264.1022254567
复制代码

A4.png




HIGH DISKGROUP得有多少个fail_group(顺便定2M AU)？  ：between  3   and  disk number

  1. [root@station79 ~]# dd if=/dev/zero of=highdata1.img  bs=150M  count=1
  2. 1+0 records in
  3. 1+0 records out
  4. 157286400 bytes (157 MB) copied, 0.941926 s, 167 MB/s
  5. [root@station79 ~]# dd if=/dev/zero of=highdata2.img  bs=150M  count=1
  6. 1+0 records in
  7. 1+0 records out
  8. 157286400 bytes (157 MB) copied, 0.320499 s, 491 MB/s
  9. <div>[root@station79 ~]# dd if=/dev/zero of=highdata3.img  bs=150M  count=1</div><div>.......</div>
复制代码
  1. [root@station79 ~]# losetup /dev/loop0  /root/highdata1.img
  2. [root@station79 ~]# losetup /dev/loop1  /root/highdata2.img   
  3. [root@station79 ~]# losetup /dev/loop2  /root/highdata3.img
复制代码
  1. [root@station79 ~]# oracleasm createdisk  ASMDISK06   /dev/loop0
  2. Writing disk header: done
  3. Instantiating disk: done
  4. [root@station79 ~]# oracleasm createdisk  ASMDISK07   /dev/loop1
  5. Writing disk header: done
  6. Instantiating disk: done
  7. [root@station79 ~]# oracleasm createdisk  ASMDISK08   /dev/loop2
  8. Writing disk header: done
  9. .......
  10. [root@station79 ~]# oracleasm scandisks
  11. Reloading disk partitions: done
  12. Cleaning any stale ASM disks...
  13. Scanning system for ASM disks...
复制代码
  1. select  * from v$asm_disk;
复制代码
  1. create diskgroup highdata high redundancy  
  2. failgroup failgroup1  disk 'ORCL:ASMDISK06' , 'ORCL:ASMDISK07'
  3. failgroup failgroup2  disk 'ORCL:ASMDISK08' , 'ORCL:ASMDISK09'
  4. failgroup failgroup3  disk 'ORCL:ASMDISK10' , 'ORCL:ASMDISK11'
  5. attribute  'au_size'='2M';
复制代码
  1. select  * from v$asm_disk;
复制代码

A5.png

  1. select  * from  v$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

  1. select  * from  v$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


  1. select * from v$asm_diskgroup;
复制代码
A6.png


A7.png

  1. alter diskgroup highdata  set attribute  'compatible.asm'='11.2';
复制代码
  1. select  * from  v$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

  1. select  * from  v$asm_template
  2. 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

A8.png







回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-5-9 23:32 , Processed in 0.053127 second(s), 27 queries .

快速回复 返回顶部 返回列表