Oracle ASM操作管理

查看ASM磁盘情况SQL> select group_number,disk_number,mount_status,header_status,mode_status,state,failgroup,total_mb,free_mb,name,path from v$asm_disk;查看ASM磁盘组情况
SQL> select group_number,block_size,name,allocation_unit_size,state,type,total_mb,free_mb,offline_disks from v$asm_diskgroup;创建ASM磁盘[root@b1 RedHat 5.4-64]#/usr/sbin/Oracleasm createdisk disk1 /dev/sdb1

[root@b1 redhat 5.4-64]#/usr/sbin/oracleasm createdisk disk2 /dev/sdb2

[root@b1 redhat 5.4-64]#/usr/sbin/oracleasm querydisk /dev/sdb*
Device "/dev/sdb" is not marked as an ASM disk
Device "/dev/sdb1" is marked an ASM disk with the label "DISK1"
Device "/dev/sdb2" is marked an ASM disk with the label "DISK2"

[root@b1 redhat 5.4-64]#/usr/sbin/oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@b1 redhat 5.4-64]#/usr/sbin/oracleasm listdisks
DISK1
DISK2 删除ASM磁盘[root@b1 ~]#/usr/sbin/oracleasm deletedisk disk4
Clearing disk header: done创建ASM磁盘组a、创建外包冗余磁盘组create diskgroup dg1 external redundancy disk "ORCL:disk3","ORCL:disk4";b、创建普通冗余磁盘组（至少两块磁盘）create diskgroup dg1 normal redundancy failgroup fg1 disk "ORCL:disk3" failgroup fg2 disk "ORCL:disk4";c、创建高冗余磁盘组（至少三块磁盘）create diskgroup dg1 high redundancy
failgroup fg1 disk "ORCL:disk3" name dg1_a
failgroup fg2 disk "ORCL:disk4" name dg1_b
failgroup fg3 disk "ORCL:disk5" name dg1_c;删除ASM磁盘组drop diskgroup dg1;drop diskgroup dg1 including contents; 向ASM磁盘组中增加磁盘 a、向高冗余磁盘组中添加磁盘成员alter diskgroup dg1
add failgroup fg1 disk "ORCL:diskd1"
add failgroup fg2 disk "ORCL:diskd2"
add failgroup fg3 disk "ORCL:diskd3";b、向外部冗余磁盘组中添加磁盘成员alter diskgroup dg2 add disk "ORCL:diske2"; 从ASM磁盘组中删除磁盘alter diskgroup dg1 drop disk diskd1,diskd2,diskd3; --删除的时候注意冗余模式，视情况而删除alter diskgroup dg2 drop disk diske2 add disk "ORCL:DISKE3"; --删除磁盘时同时添加磁盘，可减少重平衡次数删除故障组（即删除故障组中的所有磁盘）alter diskgroup dg1 drop disks in failgroup fg3;添加故障组alter diskgroup dg1 add failgroup fg3 disk "ORCL:disk5";删除磁盘时同时添加故障组alter diskgroup dg1 drop disks in failgroup fg3 add failgroup fg4 disk "ORCL:disk6";停止磁盘从一个磁盘组中删除‘ALTER DISKGROUP dgroup_01 UNDROP DISKS;推荐阅读：如何修改ASM的sys密码 http://www.linuxidc.com/Linux/2013-09/89744.htm如何将ASM中的数据文件复制到操作系统中 http://www.linuxidc.com/Linux/2013-08/88418.htmOracle 11g RAC ASM磁盘全部丢失后的恢复 http://www.linuxidc.com/Linux/2013-07/87000.htmOracle 11g从入门到精通 PDF+光盘源代码 http://www.linuxidc.com/Linux/2013-06/85670.htmRHEL6 ASM方式安装Oracle 11g R2 http://www.linuxidc.com/Linux/2013-06/86002.htmOracle 10g 手工创建ASM数据库 http://www.linuxidc.com/Linux/2013-01/78229.htmUbuntu 12.04（amd64）安装完Oracle 11gR2后各种问题解决方法 http://www.linuxidc.com/Linux/2013-06/86155.htm如何修改Oracle 10g ASM的sys密码 http://www.linuxidc.com/Linux/2012-11/75163.htm

Linux+Eclipse+GDB调试PostgreSQL源码ORA-00257-归档日志所在磁盘空间使用100%出错解决相关资讯 Oracle asm

Oracle ASM异常dismount磁盘组（04月10日）
Oracle ASM 如何添加新磁盘到磁盘（01/13/2015 22:52:11）
对Oracle ASM磁盘组进行检查（08/08/2014 10:54:50）

Oracle中的ASM文化（08/20/2015 20:51:26）
用Oracle AMDU 抽取ASM磁盘组的数（08/08/2014 10:58:55）
Oracle ASM错误之--ORA-15031、ORA （07/24/2014 14:40:33）

本文评论查看全部评论（0）