Normal 0 false false false EN-US ZH-CN X-NONE一次AIX 操作系统ASM添加磁盘的操作日志

数据库版本： oracle 11.2.0.2

操作系统版本：AIX 6.1

本次做了两种操作，一是把新PV加入到ASM中，二是删除不再使用的VG，把释放的磁盘加入到ASM中

一.把还未使用的磁盘加入到ASM中

由于这套系统安装时我没有参与，在这之前不知道磁带情况，下面为确认步骤，防止误操作

1.查看ASM path对应磁盘

SQL> set linesize 5000

SQL> select t.GROUP_NUMBER,t.OS_MB,t.TOTAL_MB,t.FREE_MB,t.PATH from v$asm_disk t;

GROUP_NUMBER OS_MB TOTAL_MB FREE_MB PATH

------------ ---------- ---------- ---------- -----------------------------------------------------------------------------------

3 256000 256000 113 /dev/archdisk1

2 307200 307200 130 /dev/asmdisk1

2 307200 307200 135 /dev/asmdisk2

2 307200 307200 130 /dev/asmdisk3

2 307200 307200 134 /dev/asmdisk4

1 1024 1024 964 /dev/ocrdisk1

1 1024 1024 964 /dev/votedisk1

1 1024 1024 965 /dev/votedisk2

2.查看对应的设备号：

设置类型22 ，设备号分别为2-10（其中9没有）

bash-3.00# ls -lrt /dev/asm*

crw-rw---- 1 grid asmdba 22, 6 Jun 06 14:28 /dev/asmdisk2

crw-rw---- 1 grid asmdba 22, 8 Jun 06 14:37 /dev/asmdisk4

crw-rw---- 1 grid asmdba 22, 7 Jun 06 14:41 /dev/asmdisk3

crw-rw---- 1 grid asmdba 22, 5 Jun 06 14:52 /dev/asmdisk1

bash-3.00# ls -lrt archdisk1

crw-rw---- 1 grid asmdba 22, 10 Jun 06 14:57 /dev/archdisk1

bash-3.00# ls -lrt /dev/ocrdisk1

crw-rw---- 1 grid asmdba 22, 2 Jun 20 2011 /dev/ocrdisk1

bash-3.00# ls -lrt /dev/votedisk*

crw-rw---- 1 grid asmdba 22, 4 Jun 20 2011 /dev/votedisk2

crw-rw---- 1 grid asmdba 22, 3 Jun 20 2011 /dev/votedisk1

3.再看一下对应的磁盘，可以看到ASM使用了下面磁盘

ASM使用了disk2至disk10(其中9没用)

bash-3.00# ls -lrt /dev/rhdisk*

crw------- 1 root system 22, 1 Mar 12 2010 /dev/rhdisk1

crw------- 2 root system 22, 0 Mar 12 2010 /dev/rhdisk0

crw------- 1 root system 22, 2 Jun 08 2011 /dev/rhdisk2

crw------- 1 root system 22, 3 Jun 08 2011 /dev/rhdisk3

crw------- 1 root system 22, 4 Jun 08 2011 /dev/rhdisk4

crw------- 1 root system 22, 5 Jun 08 2011 /dev/rhdisk5

crw------- 1 root system 22, 6 Jun 08 2011 /dev/rhdisk6

crw------- 1 root system 22, 7 Jun 08 2011 /dev/rhdisk7

crw------- 1 root system 22, 8 Jun 08 2011 /dev/rhdisk8

crw------- 1 root system 22, 9 Jun 08 2011 /dev/rhdisk9

crw------- 1 root system 22, 10 Jun 08 2011 /dev/rhdisk10

crw------- 1 root system 22, 11 Jun 08 2011 /dev/rhdisk11

crw------- 1 root system 22, 23 Jun 08 2011 /dev/rhdisk23

crw------- 1 root system 22, 22 Jun 08 2011 /dev/rhdisk22

crw------- 1 root system 22, 21 Jun 08 2011 /dev/rhdisk21

crw------- 1 root system 22, 20 Jun 08 2011 /dev/rhdisk20

crw------- 1 root system 22, 19 Jun 08 2011 /dev/rhdisk19

crw------- 1 root system 22, 18 Jun 08 2011 /dev/rhdisk18

crw------- 1 root system 22, 17 Jun 08 2011 /dev/rhdisk17

crw------- 1 root system 22, 16 Jun 08 2011 /dev/rhdisk16

crw------- 1 root system 22, 15 Jun 08 2011 /dev/rhdisk15

crw------- 1 root system 22, 14 Jun 08 2011 /dev/rhdisk14

crw------- 1 root system 22, 13 Jun 08 2011 /dev/rhdisk13

crw------- 1 root system 22, 12 Jun 08 2011 /dev/rhdisk12

4.查看操作系统使用的磁盘

操作系统只用了disk0和disk11，其中disk1,disk0为本地磁盘

bash-3.00# lspv

hdisk0 00c71c94516e6053 rootvg active

hdisk1 none None

hdisk2 none None

hdisk3 none None

hdisk4 none None

hdisk5 none None

hdisk6 none None

hdisk7 none None

hdisk8 none None

hdisk9 none None

hdisk10 none None

hdisk11 00c71c946e2767c5 bkvg active

hdisk12 none None

hdisk13 none None

hdisk14 none None

hdisk15 none None

hdisk16 none None

hdisk17 none None

hdisk18 none None

hdisk19 none None

hdisk20 none None

hdisk21 none None

hdisk22 none None

hdisk23 none None

hdisk12 之后的磁盘都可以使用还有disk9没有使用

再次确认22，9磁盘是否使用

bash-3.00# ls -lrt|grep '22, 9'

crw------- 1 root system 22, 9 Jun 08 2011 rhdisk9

brw------- 1 root system 22, 9 Jun 08 2011 hdisk9

确认asmdisk5没有使用

SQL> select t.GROUP_NUMBER,t.OS_MB,t.TOTAL_MB,t.FREE_MB,t.PATH from v$asm_disk t where t.path like '%asmdisk5%';

no rows selected

5.创建设备文件并赋权

bash-3.00# mknod /dev/asmdisk5 c 22 9

bash-3.00# chown grid:asmdba /dev/asmdisk5

bash-3.00# chmod 660 /dev/asmdisk5

查看结果

bash-3.00# ls -lrt|grep '22, 9'

crw------- 1 root system 22, 9 Jun 08 2011 rhdisk9

brw------- 1 root system 22, 9 Jun 08 2011 hdisk9

crw-rw---- 1 grid asmdba 22, 9 Jun 06 16:13 asmdisk5

6.把磁盘加入到disk group中

这次要加到DATADG里面

登陆到grid用户

bash-3.00$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jun 6 16:21:57 2012

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Automatic Storage Management option

SQL> alter diskgroup DATADG add disk '/dev/asmdisk5';

Diskgroup altered.

查看各磁盘使用情况

select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

二.删除已经不使用的VG，并把释放的PV添加至ASM

Bakvg原来用于存放备份文件，现在不需要了，决定把这个VG删除，释放磁盘加入到ASM中

1.删除VG对应的LV

使用lsvg –l vgname查看对应的文件系统，在删除VG之前需要先删除逻辑卷(LV),删除LV之前需要把文件系统卸载掉, 防止下次重启机器找不到相关的文件系统，一定要删除filesystem中对应的/backup启动参数

bash-3.00# umount /backup/

bash-3.00# vi /etc/filesystems

删除下面部分

/backup:

dev = /dev/bklv01

vfs = jfs2

log = /dev/loglv00

mount = true

options = rw

account = false

2.删除VG操作

bash-3.00# smit reducevg

选择 Remove a Physical Volume from a Volume Group，确认进入下一步

Move cursor to desired item and press Enter.

Remove a Physical Volume from a Volume Group

Remove a Volume Group

在各项中按F4选择 VOLUME GROUP name 和PHYSICAL VOLUME names，FORCE deallocation of all partitions on 选择为yes,也就是清除所有数据，回车后会有一些提示，全部选择yes

Remove a Physical Volume from a Volume Group

Type or select values in entry fields.

Press Enter AFTER making all desired changes.

[Entry Fields]

* VOLUME GROUP name bkvg

* PHYSICAL VOLUME names [hdisk11] +

FORCE deallocation of all partitions on yes +

this physical volume?

Before command completion, additional instructions may appear below.

0516-914 rmlv: Warning, all data belonging to logical volume

bklv01 on physical volume hdisk11 will be destroyed.

rmlv: Do you wish to continue? y(es) n(o)? rmlv: Logical volume bklv01 is removed.

0516-914 rmlv: Warning, all data belonging to logical volume

loglv00 on physical volume hdisk11 will be destroyed.

rmlv: Do you wish to continue? y(es) n(o)? rmlv: Logical volume loglv00 is removed.

ldeletepv: Volume Group deleted since it contains no physical volumes.

最后的状态为Command: OK stdout: yes stderr: no

3.清除释放的磁盘的PVID

bash-3.00# lspv|grep hdisk11

hdisk11 00c71c946e2767c5 None

bash-3.00#chdev -l hdisk11 -a pv=clear

hdisk11 changed

bash-3.00# lspv|grep hdisk11

hdisk11 none None

4.建立设备链接和赋权

查看原来磁盘对应的别名，计划把新的磁盘hidisk11命名为asmdisk6

SQL> select t.PATH from v$asm_disk t where t.path like '%asmdisk%';

PATH

--------------------------------------------------------------------------------

/dev/asmdisk1

/dev/asmdisk2

/dev/asmdisk3

/dev/asmdisk4

/dev/asmdisk5

bash-3.00# ls -lrt|grep hdisk11

brw------- 1 root system 22, 11 Jun 08 2011 hdisk11

crw------- 1 root system 22, 11 Jul 03 15:18 rhdisk11

bash-3.00# mknod /dev/asmdisk6 c 22 11

bash-3.00# chown grid:asmdba /dev/asmdisk6

bash-3.00# chmod 660 /dev/asmdisk6

查看结果

bash-3.00# ls -lrt|grep '22, 11'

brw------- 1 root system 22, 11 Jun 08 2011 hdisk11

crw------- 1 root system 22, 11 Jul 03 15:18 rhdisk11

crw-rw---- 1 grid asmdba 22, 11 Jul 03 15:29 asmdisk6

5.把磁盘加入到disk group中

这次要加到DATADG里面

登陆到grid用户

bash-3.00$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jun 6 16:21:57 2012

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Automatic Storage Management option

SQL> alter diskgroup DATADG add disk '/dev/asmdisk6';

Diskgroup altered.

6.查看各磁盘使用情况

select group_number, name, TOTAL_MB, FREE_MB from V$asm_disk_stat;

ITPub博客

一次AIX 操作系统ASM添加磁盘的操作日志

最新文章