一、首先查看底层磁盘
[root@adg2 bp0]# fdisk -l /dev/vdb
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
磁盘 /dev/vdb：16106.1 GB, 16106127360000 字节，31457280000 个扇区
Units = 扇区 of 1 * 512 = 512 bytes
扇区大小(逻辑/物理)：512 字节 / 512 字节
I/O 大小(最小/最佳)：512 字节 / 512 字节
磁盘标签类型：gpt
Disk identifier: 8446B269-2DD9-4907-B0DD-DE4E9E2AC371
# Start End Size Type Name
1 20480 1953124351 931.3G Microsoft basic primary
2 1953124352 5859375103 1.8T Microsoft basic primary
3 5859375104 9765625855 1.8T Microsoft basic primary
4 9765625856 17578125311 3.7T Microsoft basic primary
5 17578125312 25390624767 3.7T Microsoft basic primary
6 25390624768 31457277951 2.8T Microsoft basic primary
大于2T的看下
[root@adg2 install]# parted /dev/vdb print
Model: Virtio Block Device (virtblk)
Disk /dev/vdb: 16.1TB
Sector size (logical/physical): 512B/512B
Partition Table: gpt
Disk Flags:
Number Start End Size File system Name 标志
1 10.5MB 1000GB 1000GB primary
2 1000GB 3000GB 2000GB primary
3 3000GB 5000GB 2000GB primary
4 5000GB 9000GB 4000GB primary
5 9000GB 13.0TB 4000GB primary
6 13.0TB 16.1TB 3106GB primary
[root@adg2 install]#
如果没有分区需要分区
[root@adg2 install]# parted /dev/vdb mkpart primary 5T 9T
信息: You may need to update /etc/fstab.
[root@adg2 install]# parted /dev/vdb mkpart primary 9T 13T
信息: You may need to update /etc/fstab.
[root@adg2 install]# parted /dev/vdb mkpart primary 13T 100%
信息: You may need to update /etc/fstab.
二、创建ASM磁盘
[root@adg2 install]# oracleasm createdisk DATA03 /dev/vdb4
Writing disk header: done
Instantiating disk: done
[root@adg2 install]# oracleasm createdisk DATA04 /dev/vdb5
Writing disk header: done
Instantiating disk: done
[root@adg2 install]# oracleasm listdisks
DATA01
DATA02
DATA03
DATA04
[root@adg2 install]# oracleasm createdisk DATA05 /dev/vdb6
Writing disk header: done
Instantiating disk: done
[root@adg2 install]# oracleasm listdisks
DATA01
DATA02
DATA03
DATA04
DATA05
[root@adg2 install]# oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
[root@adg2 install]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
[root@adg2 install]#
三、进入ASM查看磁盘情况
[root@adg2 bp0]# su - grid
上一次登录：三 9月 21 18:45:47 CST 2022pts/2 上
[grid@adg2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 21 19:44:02 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> set time on timing on
19:45:32 SQL> col path for a90
19:46:07 SQL> set linesize 1000
19:46:27 SQL> select name,path from v$asm_disk;
NAME PATH
------------------------------ ------------------------------------------------------------------------------------------
/dev/oracleasm/disks/DATA05
/dev/oracleasm/disks/DATA04
DATAC1_0000 /dev/oracleasm/disks/DATA03
RECOC1_0000 /dev/oracleasm/disks/DATA02
CRS_0000 /dev/oracleasm/disks/DATA01
Elapsed: 00:00:00.04
19:46:32 SQL> select name,total_mb, free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATAC1 3814656 1711680
RECOC1 1907328 1905600
CRS 1907349 1907255
Elapsed: 00:00:08.13
四、开始加入磁盘组
19:52:08 SQL> alter diskgroup DATAC1 add disk '/dev/oracleasm/disks/DATA04' rebalance power 10;
alter diskgroup DATAC1 add disk '/dev/oracleasm/disks/DATA04' rebalance power 10
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
Elapsed: 00:00:00.01
19:54:01 SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
*******权限为什么不够呢，没注意，ASM磁盘组扩容要用sysasm,用sysdba权限不够************
[grid@adg2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 21 19:55:29 2022
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option
SQL> alter diskgroup DATAC1 add disk '/dev/oracleasm/disks/DATA04' rebalance power 10;
Diskgroup altered.
SQL> select name,total_mb, free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATAC1 7629312 5526144
RECOC1 1907328 1905600
CRS 1907349 1907255
SQL> select name,path from v$asm_disk;
NAME PATH
------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/dev/oracleasm/disks/DATA05
DATAC1_0001 /dev/oracleasm/disks/DATA04
DATAC1_0000 /dev/oracleasm/disks/DATA03
RECOC1_0000 /dev/oracleasm/disks/DATA02
CRS_0000 /dev/oracleasm/disks/DATA01
