清理diskgroup,重建

--测试读取速度 
dd if=/dev/rdisk/disk3413 of=/dev/null bs=8192 count=200
dd if=/dev/rdisk/disk3493 of=/dev/null bs=8192 count=200
          
      
       
--清理磁盘头
dd if=/dev/zero of=/dev/rdisk/disk3538 bs=8192 count=128000

--查看状态
srvctl status diskgroup -g dg8400

oracle@node1 > sqlplus / as sysasm
SQL> sqlplus / as sysasm


同下面例子
SQL> ! srvctl status diskgroup -g DATA
Disk Group DATA is running on node1,node2,node3

SQL> ! srvctl stop diskgroup -g DATA -n node2,node3

SQL> DROP DISKGROUP DATA;

SQL > ! srvctl remove diskgroup -g DATA
CREATE DISKGROUP DG6400DATA EXTERNAL REDUNDANCY DISK 
'/dev/rdisk/disk3493',
'/dev/rdisk/disk3538',
'/dev/rdisk/disk3539'
ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='64M','COMPATIBLE.RDBMS'='11.2.0.0.0';
 
 
 CREATE DISKGROUP DG6400 EXTERNAL REDUNDANCY DISK 
'/dev/rdisk/disk3540'
ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='64M','COMPATIBLE.RDBMS'='11.2.0.0.0';
 
 ALTER DISKGROUP DG6400DATA ADD DISK '/dev/rdisk/disk3542'


删除磁盘(先dismount,alter diskgroup dg8400 dismount;

SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME                           STATE         TOTAL_MB    FREE_MB
------------------------------ ----------- ---------- ----------
DG01DATA                       MOUNTED      198656000   92069328
DGCRS                          MOUNTED          30720      29698
DGREDO01                       MOUNTED         839151     829038
DGREDO02                       MOUNTED         839151     829038
DG8400                         DISMOUNTED           0          0
DG8400DATA                     MOUNTED       32417792   32415040
DG6400DATA                     MOUNTED       20480000   20478208

7 rows selected.

SQL> drop diskgroup DG8400 force including contents;

Diskgroup dropped.

SQL>  select name,state,total_mb,free_mb from v$asm_diskgroup;

NAME                           STATE         TOTAL_MB    FREE_MB
------------------------------ ----------- ---------- ----------
DG01DATA                       MOUNTED      198656000   92069328
DGCRS                          MOUNTED          30720      29698
DGREDO01                       MOUNTED         839151     829038
DGREDO02                       MOUNTED         839151     829038
DG8400DATA                     MOUNTED       32417792   32415040
DG6400DATA                     MOUNTED       20480000   20478208

6 rows selected.

SQL> 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值