Oracle ASM扩容

2022 年 02 月 24 日

306 次浏览

3783字数

一查看 ASM 空间使用情况

SQL> select group_number,name,total_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB
1  DATADG 1039
2  SYSTEDG 4096

二停止数据库

[oracle@ogg1 ~]$ lsnrctl stop
[oracle@ogg1 ~]$ sqlplus / as sysdba
SQL> shutdown immediate
[grid@ogg1 ~]$ sqlplus / as sysasm
SQL> shutdown immediate

三停止服务器，添加磁盘

[root@ogg1 ~]# init 0
虚拟机-- 设置-- 存储-- 创建新的虚拟盘--1G-- 启动虚拟机

四启动服务器

[grid@ogg1 ~]$ sqlplus / as sysasm
SQL> startup
[oracle@ogg1 ~]$ sqlplus / as sysdba
SQL> startup
[oracle@ogg1 ~]$ lsnrctl start

五为新磁盘添加盘符

[root@ogg1 ~]# fdisk -l
......
Disk /dev/sdi: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
[root@ogg1 ~]# cd /dev/
[root@ogg1 dev]# ls -l sd*
brw-rw---- 1 root disk 8, 0 Jul 21 13:51 sda
brw-rw---- 1 root disk 8, 1 Jul 21 13:51 sda1
brw-rw---- 1 root disk 8, 2 Jul 21 13:51 sda2
brw-rw---- 1 root disk 8, 3 Jul 21 13:51 sda3
brw-rw---- 1 root disk 8, 16 Jul 21 13:56 sdb
brw-rw---- 1 root disk 8, 32 Jul 21 13:56 sdc
brw-rw---- 1 root disk 8, 48 Jul 21 13:56 sdd
brw-rw---- 1 root disk 8, 64 Jul 21 13:56 sde
brw-rw---- 1 root disk 8, 80 Jul 21 13:56 sdf
brw-rw---- 1 root disk 8, 96 Jul 21 13:56 sdg
brw-rw---- 1 root disk 8, 112 Jul 21 13:56 sdh
brw-rw---- 1 root disk 8, 128 Jul 21 13:51 sdi

[root@ogg1 dev]# for i in i;
> do
> echo "KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`", NAME="asm-disk$i", OWNER="grid", GROUP="asmadmin", MODE="0660"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules
> done
[root@ogg1 dev]# /sbin/start_udev
Starting udev: [ OK ]
[root@ogg1 dev]# ls -l asm*
brw-rw---- 1 grid asmadmin 8, 16 Jul 21 14:02 asm-diskb
brw-rw---- 1 grid asmadmin 8, 32 Jul 21 14:02 asm-diskc
brw-rw---- 1 grid asmadmin 8, 48 Jul 21 14:02 asm-diskd
brw-rw---- 1 grid asmadmin 8, 64 Jul 21 14:02 asm-diske
brw-rw---- 1 grid asmadmin 8, 80 Jul 21 14:02 asm-diskf
brw-rw---- 1 grid asmadmin 8, 96 Jul 21 14:02 asm-diskg
brw-rw---- 1 grid asmadmin 8, 112 Jul 21 14:02 asm-diskh
brw-rw---- 1 grid asmadmin 8, 128 Jul 21 14:02 asm-diski

六将新磁盘加入到 ASM 磁盘组

[grid@ogg1 ~]$ sqlplus / as sysasm
SQL> col name for a20
SQL> select group_number,name,total_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB

1 DATADG 1039
2 SYSTEDG 4096
SQL> alter diskgroup SYSTEDG add disk '/dev/asm-diski';

七查看 ASM 空间使用情况

SQL> select group_number,name,total_mb from v$asm_diskgroup;
GROUP_NUMBER NAME TOTAL_MB

1 DATADG 1039
2 SYSTEDG 5120
SQL> select group_number,name,path,os_mb,free_mb from v$asm_disk order by 1 desc;
GROUP_NUMBER NAME PATH OS_MB FREE_MB
2 SYSTEDG_0000 /dev/asm-diskg 2048 594
2 SYSTEDG_0001 /dev/asm-diskh 2048 590
2 SYSTEDG_0002 /dev/asm-diski 1024 131
1 DATADG_0000 /dev/asm-diskb 208 172
1 DATADG_0003 /dev/asm-diske 210 172
1 DATADG_0001 /dev/asm-diskc 210 175
1 DATADG_0002 /dev/asm-diskd 211 173
1 DATADG_0004 /dev/asm-diskf 200 164
[grid@ogg1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 4096 1048576 1039 856 211 322 0 N DATADG/
MOUNTED NORMAL N 512 4096 1048576 5120 1295 2048 -376 0 N SYSTEDG/

转载自chenoracle

Oracle ASM扩容