环境:
Linux Server 5.4, Oracle 11.2.0.2, 单实例
这里的测试是参考了ASM hands-on training。
1. 创建normal redundancy asm磁盘组
点击(此处)折叠或打开
- CREATE DISKGROUP DATA NORMAL REDUNDANCY
- FAILGROUP FG1 DISK
- 'ORCL:DATAVOL1' NAME DATAVOL1,
- 'ORCL:DATAVOL2' NAME DATAVOL2,
- FAILGROUP FG2 DISK
- 'ORCL:DATAVOL3' NAME DATAVOL3,
- 'ORCL:DATAVOL4' NAME DATAVOL4,
- ATTRIBUTE 'au_size'='1M',
- 'compatible.asm' = '11.2',
- 'compatible.rdbms' = '11.2',
- 'compatible.advm' = '11.2';
2. 模拟损坏磁盘
点击(此处)折叠或打开
- [root@dbs4 ~]# dd if=/dev/zero f=/dev/i2o/hda7 bs=4096 count=1
- 1+0 records in
- 1+0 records out
- 4096 bytes (4.1 kB) copied, 8.5159e-05 seconds, 48.1 MB/s
- [root@dbs4 ~]#
3. 检查asm的磁盘视图:
点击(此处)折叠或打开
- select name, header_status, state, path, failgroup from v$asm_disk;
- NAME HEADER_STATU STATE PATH FAILGROUP
- ------------------------------ ------------ -------- -------------------- --------------------
- DATAVOL1 MEMBER NORMAL ORCL:DATAVOL1 FG1
- DATAVOL2 MEMBER NORMAL ORCL:DATAVOL2 FG1
- DATAVOL3 CANDIDATE NORMAL ORCL:DATAVOL3C FG2
- DATAVOL4 MEMBER NORMAL ORCL:DATAVOL4 FG2
- FRAVOL1 MEMBER NORMAL ORCL:FRAVOL1 FRAVOL1
asm磁盘文件头的状态变成了CANDIDATE,而不再是MEMBER。
4. 在asm实例中删除磁盘。
点击(此处)折叠或打开
- SQL> alter diskgroup data drop disk DATAVOL3;
- Diskgroup altered.
5. 在操作系统中删除asm磁盘。
点击(此处)折叠或打开
- [root@dbs4 ~]# /etc/init.d/oracleasm deletedisk DATAVOL3C
- Removing ASM disk "DATAVOL3C": [ OK ]
6. 在操作系统中加回asm磁盘。
点击(此处)折叠或打开
- [root@dbs4 ~]# /etc/init.d/oracleasm createdisk DATAVOL3 /dev/i2o/hda7
- Marking ASM disk "DATAVOL3" as an ASM disk: [ OK ]
7. 在asm实例中加回asm磁盘。
点击(此处)折叠或打开
- alter diskgroup data add failgroup FG2 disk 'ORCL:DATAVOL3';
8. 检查rebalance操作
点击(此处)折叠或打开
- 1 select operation, power, actual, sofar, est_minutes
- 2* from v$asm_operation
NOTE:
必须要在实例中删除asm磁盘,不然系统认为磁盘被使用,不能再被加为系统的asm磁盘。
[root@dbs4 ~]# /etc/init.d/oracleasm createdisk DATAVOL3 /dev/i2o/hda7
Marking ASM disk "DATAVOL3" as an ASM disk: [FAILED]
总结:
测试发现有些操作和hands-on的training有些不一样。比如需要先在asm实例中
删除asm磁盘。Oracle认为存储应该由DBA来管理。ASM就是Oracle推荐的存储。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25105315/viewspace-695165/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25105315/viewspace-695165/