ASM卷加盘

简介: 1.登陆服务器2.登陆到ASM实例su - gridsqlplus '/as sysasm'SQL> SELECT path FROM v$asm_disk WHERE NAME IS NULL;PATH/dev/rdsk/c0t60060E8007C72E000030C72E0000...

1.登陆服务器

2.登陆到ASM实例
su - grid

sqlplus '/as sysasm'

SQL> SELECT path FROM v$asm_disk WHERE NAME IS NULL;

PATH

/dev/rdsk/c0t60060E8007C72E000030C72E000003BFd0s0
/dev/rdsk/c0t60060E8007C72E000030C72E000003C0d0s0
SQL>

3.加盘到DATA_TEST_DG:
alter diskgroup DATA_TEST_DG add disk '/dev/rdsk/c0t60060E8007C72E000030C72E000003BFd0s0' rebalance power 0;
alter diskgroup DATA_TEST_DG add disk '/dev/rdsk/c0t60060E8007C72E000030C72E000003C0d0s0' rebalance power 0;

4.所有盘加完后开启rebalance power 4:
alter diskgroup DATA_TEST_DG rebalance power 4;

观察数据库异常等待事件10min;
select s.inst_id,sw.sid,s.serial#,s.username,sw.event,sw.wait_class,sw.P1,sw.p2,sw.p3,sw.wait_time "WAIT",sw.state,sw.seconds_in_wait sec,s.status,to_char(s.logon_time,'dd/hh24:mi:ss') log_time
from gv$session s,gv$session_wait sw
where s.username is not null and sw.sid =s.sid and s.inst_id=sw.inst_id
and sw.event not like '%SQL*Net%'
and sw.event not like 'PX Deq%'
order by s.inst_id,sw.event;

观察数据库异常等待事件10min;
select event,count() from v$session_wait group by event having count()>10;

查看预估rebalance完需要多少时间,能否在早上6点前rebalance完成。
select * from v$asm_operation;

5.rebalance完成后,检查各磁盘是否均衡:

select name,path,total_mb,free_mb,state,header_status from v$asm_disk where name like 'DATA_TEST_DG%' order by free_mb desc;
是否还有rebalance进程:
select * from v$asm_operation;

6.如在早上6点还未有rebalance完成:
alter diskgroup DATA_TEST_DG rebalance power 0;
检查确保没有rebalance进程:
select * from v$asm_operation;

目录
相关文章
|
存储 Java API
ASM 关键接口 MethodVisitor
ASM 关键接口 MethodVisitor
316 0
ASM 关键接口 MethodVisitor
|
存储 Oracle 网络协议
|
SQL Web App开发 数据库
|
Java 数据库连接 应用服务中间件
|
Oracle 关系型数据库 数据库
|
关系型数据库 Unix Oracle
|
存储 Oracle 关系型数据库
|
存储 Oracle 关系型数据库
【ASM】ASMLIB 系列
【ASM】ASMLIB 系列 使用ASMLIB管理磁盘 在存储管理员给服务器提供磁盘设备后,它们对于服务器来说是可用的并且可以在Linux系统中 的/proc/partitions虚拟文件中可以看到。
2593 0
|
Oracle 关系型数据库 数据库
【ASM】ASMSNMP用户已存在
【ASM】ASMSNMP用户已存在 During Oracle Grid Infrastructure for a cluster installation, the ASMSNMP account is created and its status is set to OPEN.
1028 0