ASM扩容步骤.TXT - 墨天轮文档

ASM扩容步骤.TXT

漫步者

156

4页

3次

2025-04-28

5墨值下载

Oracle RAC 环境下 ASM 磁盘组扩容步骤：

1.检查各个节点 database、asm 及 grid

su - grid

sqlplus / as sysasm

select instance_name,host_name,startup_time,status from gv$instance;

su - oracle

sqlplus / as sysdba

select instance_name,host_name,startup_time,status from gv$instance;

select * from gv$asm_client order by 1,2;

select

group_number,name,state,type,total_mb,free_mb,usable_file_mb,allocation_unit_siz

e/1024/1024 unit_mb from v$asm_diskgroup order by 1;

select

group_number,name,path,mount_status,state,redundancy,total_mb,free_mb,failgroup,

create_date from v$asm_disk order by 1,2;

###########################################

停前台业务，停数据库

一、关闭过程（CRS 集群关闭－>关闭数据库）

--以下命令只能关闭当前节点的 CRS 服务，因此需要在 RAC 的所有节点上执行，启动也一样。has 与 crs 等

同

a.停止 HAS(High Availability Services)，必须以 root 用户操作

[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin

[root@rac1 bin]# ./crsctl stop has -f

[root@rac1 bin]# ./crsctl stop crs -f

b.停止节点集群服务，必须以 root 用户：

[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin

[root@rac1 bin]# ./crsctl stop cluster ----停止本节点集群服务

[root@rac1 bin]# ./crsctl stop cluster -all ---停止所有节点服务

[root@rac1 bin]# crsctl stop cluster -n rac1 rac2

检查集群进程状态

crsctl check cluster

crs_stat -t -v

crsctl check crs---只检查本节点的集群状态

c.关闭数据库：

srvctl stop database -d stitvdb

查看状态：

srvctl status database -d racdb

###########################################

2.修改 UDEV

cat /etc/udev/rules.d/99-oracle-asmdisks.rules

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500c4ed7e0783ca6", NAME="asm-

diska", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500618db6f246515", NAME="asm-

diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="350037e6abb7dca57", NAME="asm-

diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="35000955db0097784", NAME="asm-

diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500e381f34b0ca48", NAME="asm-

diske", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500d48b4e9c2367c", NAME="asm-

diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500d7981eaba5a13", NAME="asm-

diskg", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500a0175456385e0", NAME="asm-

diskh", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="35003b8f9db6a67a4", NAME="asm-

diski", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500c9088e5869ae7", NAME="asm-

diskj", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500e287d665f8916", NAME="asm-

diskk", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="35004f69285d332ae", NAME="asm-

diskl", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="350007205d4fbcb42", NAME="asm-

diskm", OWNER="grid", GROUP="asmadmin", MODE="0660"

-----以下为新增---

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500ace458c39eafc", NAME="asm-

diskn", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500ed3001eef0a35", NAME="asm-

disko", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="35006667f8f0c3606", NAME="asm-

diskp", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500b4cd3e433d608", NAME="asm-

diskq", OWNER="grid", GROUP="asmadmin", MODE="0660"

3.重启 udev

[root@ora32 ~]# /sbin/udevcontrol reload_rules

[root@ora32 ~]# /sbin/start_udev

[root@ora32 ~]# ll /dev/asm*

4.启动数据库

################################################################

a.启动数据库：

srvctl start database -d stitvdb

查看状态：

srvctl status database -d racdb

b.启动集群：

以下令只能生效当前节点的 CRS 服务，因此需要在 RAC 的所有节点上执行

b1.启动 HAS(High Availability Services)，必须以 root 用户操作

[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin

Oracle RAC 环境下 ASM 磁盘组扩容步骤：

1.检查各个节点 database、asm 及 grid

su - grid

sqlplus / as sysasm

select instance_name,host_name,startup_time,status from gv$instance;

su - oracle

sqlplus / as sysdba

select instance_name,host_name,startup_time,status from gv$instance;

select * from gv$asm_client order by 1,2;

select

group_number,name,state,type,total_mb,free_mb,usable_file_mb,allocation_unit_siz

e/1024/1024 unit_mb from v$asm_diskgroup order by 1;

select

group_number,name,path,mount_status,state,redundancy,total_mb,free_mb,failgroup,

create_date from v$asm_disk order by 1,2;

###########################################

停前台业务，停数据库

一、关闭过程（CRS 集群关闭－>关闭数据库）

--以下命令只能关闭当前节点的 CRS 服务，因此需要在 RAC 的所有节点上执行，启动也一样。has 与 crs 等

同

a.停止 HAS(High Availability Services)，必须以 root 用户操作

[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin

[root@rac1 bin]# ./crsctl stop has -f

[root@rac1 bin]# ./crsctl stop crs -f

b.停止节点集群服务，必须以 root 用户：

[root@rac1 oracle]# cd /u01/grid/11.2.0/grid/bin

[root@rac1 bin]# ./crsctl stop cluster ----停止本节点集群服务

[root@rac1 bin]# ./crsctl stop cluster -all ---停止所有节点服务

[root@rac1 bin]# crsctl stop cluster -n rac1 rac2

检查集群进程状态

crsctl check cluster

crs_stat -t -v

crsctl check crs---只检查本节点的集群状态

c.关闭数据库：

srvctl stop database -d stitvdb

查看状态：

srvctl status database -d racdb

###########################################

2.修改 UDEV

cat /etc/udev/rules.d/99-oracle-asmdisks.rules

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500c4ed7e0783ca6", NAME="asm-

diska", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

--device=/dev/mapper/$env{DM_NAME}", RESULT=="3500618db6f246515", NAME="asm-

diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="dm-*", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace

of 4

5墨值下载

asm扩容

关注

评论