ASM数据平衡验证

最新推荐文章于 2022-05-20 14:31:09 发布

原创最新推荐文章于 2022-05-20 14:31:09 发布 · 1.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#allocation #磁盘 #disk #oracle #数据库 #sql

RAC 专栏收录该内容

6 篇文章

订阅专栏

本文详细介绍了在Oracle ASM中进行磁盘管理，包括添加磁盘、创建磁盘组、验证数据平衡和处理磁盘故障的过程。通过查询v$asm_diskgroup和v$asm_operation等视图，展示如何确保ASM实例的健康状态和数据一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.涉及到的视图
  v$asm_operation v$asm_diskgroup v$asm_disk

2.添加一块磁盘，并给fdisk磁盘
  fdisk sdf
  fdisk sdg

3. 创建磁盘
/etc/init.d/oracleasm createdisk VOL5 sdf1
/etc/init.d/oracleasm createdisk VOL6 sdg1

4.启动asm实例和asm数据库

5.登录到asm实例中
export ORACLE_SID=+ASM
sqlplus / nolog
conn / as sysdba

6.查看视图
select name,state, MOUNT_STATUS from v$asm_disk; ----找到磁盘
NAME STATE MOUNT_S
------------------------------ -------- -------
   NORMAL CLOSED
   NORMAL CLOSED
VOL1 NORMAL CACHED
VOL2 NORMAL CACHED
VOL3 NORMAL CACHED
VOL4 NORMAL CACHED

7.将磁盘加入到磁盘组中
SQL> alter diskgroup dgroup1 add failgroup fgroup1 disk 'ORCL:VOL5' failgroup fgroup2 disk 'ORCL:VOL6';

Diskgroup altered.

SQL> select name,state, MOUNT_STATUS from v$asm_disk;

NAME STATE MOUNT_S
------------------------------ -------- -------
VOL1 NORMAL CACHED
VOL2 NORMAL CACHED
VOL3 NORMAL CACHED
VOL4 NORMAL CACHED
VOL5 NORMAL CACHED
VOL6 NORMAL CACHED

8.验证数据平衡
a.
SQL> select group_number,operation,state,est_work,sofar,est_rate,est_minutes from v$asm_operation;
如果没有数据，则表示平衡结束。

SQL> select name,allocation_unit_size, total_mb from v$asm_diskgroup;

NAME ALLOCATION_UNIT_SIZE TOTAL_MB
------------------------------ -------------------- ----------
DGROUP1 1048576 5098 -----增大一个G

b.
  进入asm数据库
export ORACLE_SID=asmdemo
sqplus /nolog
conn / as sysdba
c.
创建表空间
create tablespace ts_test datafile '+DGROUP1' size 200M;
创建用户
create user asmuser identified by asmuser default tablespace ts_test;
grant dba to asmuser;
conn asmuser/asmuser;
create table t_test as select * from dba_objects;

验证删除磁盘
9.进入asm实例
export ORACLE_SID=+ASM
sqlplus /nolog
conn / as sysdba

10.drop掉磁盘4
  alter diskgroup dgroup1 drop disk VOL4;

11.验证
select group_number,operation,state,est_work,sofar,est_rate,est_minutes from v$asm_operation;
SQL> select name,state, MOUNT_STATUS from v$asm_disk;

NAME STATE MOUNT_S
------------------------------ -------- -------
VOL1 NORMAL CACHED
VOL2 NORMAL CACHED
VOL3 NORMAL CACHED
VOL4 HUNG CACHED
VOL5 NORMAL CACHED
VOL6 NORMAL CACHED

select name,allocation_unit_size, total_mb from v$asm_diskgroup;
alter diskgroup dgroup1 rebalance;
select name,allocation_unit_size, total_mb from v$asm_diskgroup;