通过udev创建ASM共享磁盘(RAC)(2)

安装完RAC环境后,突然觉得之前配置的ASM磁盘不够用,于是打算再添加一块大容量的ASM磁盘;前面操作都无差异,这里补充后续操作。

查看asm disks:

[root@rac01 rules.d]# ls -l /dev/asm*

[root@rac01 rules.d]# ls -l /dev/asm*

brw-rw---- 1 grid asmadmin 8, 21 Nov 25 11:22 /dev/asm_disk1

brw-rw---- 1 grid asmadmin 8, 22 Nov 25 11:22 /dev/asm_disk2

brw-rw---- 1 grid asmadmin 8, 23 Nov 25 11:22 /dev/asm_disk3

brw-rw---- 1 grid asmadmin 8, 24 Nov 25 11:22 /dev/asm_disk4

brw-rw---- 1 grid asmadmin 8, 25 Nov 25 11:22 /dev/asm_disk5

brw-rw---- 1 grid asmadmin 8, 26 Nov 25 11:22 /dev/asm_disk6

brw-rw---- 1 grid asmadmin 8, 33 Nov 25 09:42 /dev/asm_disk7

在节点1中,使用grid用户运行asmca:

通过udev创建ASM共享磁盘(RAC)

成功弹出ASM设置界面,选择Create

输入磁盘组名,选择External(外部冗余)(因为已经存在常规冗余磁盘组,为了省事儿这里选择外部冗余),选择磁盘:

通过udev创建ASM共享磁盘(RAC)

点击OK

通过udev创建ASM共享磁盘(RAC)

点击OK回到初始界面,点击右下角Exit,然后选择Yes保留操作并退出

使用oracle 账户登录数据库并查询ASM磁盘组信息:

[root@rac01 ~]# su - oracle

[oracle@rac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 25 13:09:54 2016

   

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select name,total_mb from v$asm_diskgroup;

   

NAME                                TOTAL_MB

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

DATA_DB                         16378

DATA                                6144

CY                                102398

七、额外问题

完成上面的操作后,发现节点2出现了一些问题

[oracle@rac02 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 25 13:13:45 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> select name,total_mb from v$asm_diskgroup;

select name,total_mb from v$asm_diskgroup

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

   

实例似乎被关闭了,重启实例后,发现新加的ASM磁盘组挂载异常

SQL> startup

ORACLE instance started.

   

Total System Global Area 1603411968 bytes

Fixed Size                2253664 bytes

Variable Size                1056967840 bytes

Database Buffers        536870912 bytes

Redo Buffers                7319552 bytes

Database mounted.

Database opened.

SQL> select name,total_mb from v$asm_diskgroup;

   

NAME                                TOTAL_MB

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

DATA_DB                         16378

DATA                                6144

CY                                        0

   

[grid@rac02 admin]$ ocrcheck

Status of Oracle Cluster Registry is as follows :

Version : 3

Total space (kbytes) : 262120

Used space (kbytes) : 3072

Available space (kbytes) : 259048

ID : 277519239

Device/File Name : +DATA

Device/File integrity check succeeded

   

Device/File not configured

   

Device/File not configured

   

Device/File not configured

   

Device/File not configured

   

Cluster registry integrity check succeeded

   

Logical corruption check bypassed due to non-privileged user

   

手动挂载:

[grid@rac02 admin]$ sqlplus / as sysasm

   

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 25 13:30:30 2016

   

Copyright (c) 1982, 2013, Oracle. All rights reserved.

   

   

Connected to:

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

With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup CY mount;

   

Diskgroup altered.

   

SQL> select GROUP_NUMBER,NAME,TYPE,ALLOCATION_UNIT_SIZE,STATE from v$asm_diskgroup;

   

GROUP_NUMBER NAME                        TYPE ALLOCATION_UNIT_SIZE STATE

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

1 DATA_DB                        NORMAL                1048576 MOUNTED

   

2 DATA                        NORMAL                1048576 MOUNTED

   

3 CY                         EXTERN                1048576 MOUNTED

再次查询ASM磁盘组信息:

[oracle@rac02 admin]$ sqlplus / as sysdba

   

SQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 25 13:40:10 2016

   

Copyright (c) 1982, 2013, Oracle. All rights reserved.

   

   

Connected to:

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

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

   

SQL> select name,total_mb from v$asm_diskgroup;

   

NAME                                TOTAL_MB

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

DATA_DB                         16378

DATA                                6144

CY                                102398

   

完成后发现CRS服务异常:

[grid@rac02 admin]$ crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4535: Cannot communicate with Cluster Ready Services

CRS-4529: Cluster Synchronization Services is online

CRS-4534: Cannot communicate with Event Manager

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/65280df01970cf8fa4f5b9012b7d9606.html