企业网站设计开发服务,google图片搜索引擎入口,在重庆_那里可以做诚信网站认证,石家庄的网站建设公司哪家好环境介绍#xff1a;故事发生在Oracle 11.2.0.4 RAC/ Linux 6.8 的数据库集群服务器上。DATA/ ARCH/ 磁盘组空间不足#xff0c;进行扩容。首先#xff0c;如果要在线使用udev方式扩容asm#xff0c;建议先备份两个节点所有在用网卡信息#xff0c;避免bug误删除网卡信息。…环境介绍故事发生在Oracle 11.2.0.4 RAC/ Linux 6.8 的数据库集群服务器上。DATA/ ARCH/ 磁盘组空间不足进行扩容。首先如果要在线使用udev方式扩容asm建议先备份两个节点所有在用网卡信息避免bug误删除网卡信息。备份至/tmp目录下。(包括the ifcfg-eth0 (public), ifcfg-eth1 (private) and ifcfg-eth2 (backup))注意11.2.0.3及以后在linux上的bug见如下官网解释Network interface going down when dynamically adding disks to storage using udev in RHEL 6 (文档 ID 1569028.1)Applies to:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Linux x86-64SymptomsDynamically added new disks to storage using udev rules(as per the docs note 414897.1, 1528148.1, 371814.1 etc).During start_udev, udev has deleted the public network interface and this caused the listener to crash, and clusterware moved all services, scan listeners and the VIP on node 1 to node 2.ChangesTrying to add disk to storage using udevCauseudev has deleted the public network interface.SolutionAs per RHEL you are advised to set HOTPLUGno for the network configuration scripts.Add HOTPLUGno to the ifcfg-eth0 (public), ifcfg-eth1 (private) and ifcfg-eth2 (backup) network config files in /etc/sysconfig/network-scripts directory.建议先做数据库备份1.停止数据库及集群服务su - gridsrvctl stop listenersrvctl stop database -d jyracrac1/rac2su - root/u01/11.2.0/grid/bin/crsctl stop crs####################### rac1/rac2 begin ##############################2.网卡信息修改注意如果是使用网卡绑定比如绑定后的网卡为bond0则要在bond0的配置文件里添加hotplug配置信息在eth0里添加不起作用。(实战中所有在用网卡均添加)备份所有网卡信息至/tmp 目录rac1/rac2cp ifcfg-eth0 /tmp/ifcfg-eth0bakcp ifcfg-bond0 /tmp/ifcfg-bond0bakcp ifcfg-eth1 /tmp/ifcfg-eth1bak...实际[rootjyrac1 network-scripts]# cp * /tmp/wkbak[rootjyrac1 network-scripts]#[rootjyrac2 network-scripts]# cp * /tmp/wkbak/[rootjyrac2 network-scripts]#修改网卡信息HOTPLUGno重启网络服务service network restart[rootjyrac1 network-scripts]# service network restartShutting down interface bond0: [ OK ]Shutting down interface eth0: [ OK ]Shutting down loopback interface: [ OK ]Bringing up loopback interface: [ OK ]Bringing up interface bond0: Determining if ip address 192.168.20.11 is already in use for device bond0...[ OK ]Bringing up interface eth0: Determining if ip address 187.187.2.61 is already in use for device eth0...[ OK ][rootjyrac1 network-scripts]#[rootjyrac2 network-scripts]# service network restartShutting down interface bond0: [ OK ]Shutting down interface eth0: [ OK ]Shutting down loopback interface: [ OK ]Bringing up loopback interface: [ OK ]Bringing up interface bond0: Determining if ip address 192.168.20.12 is already in use for device bond0...[ OK ]Bringing up interface eth0: Determining if ip address 187.187.2.62 is already in use for device eth0...[ OK ][rootjyrac2 network-scripts]#3.修改udev权限文件备份udev文件至/tmp 目录[rootjyrac1 network-scripts]# cp /etc/udev/rules.d/12-dm-permissions.rules /tmp/wkbak/vi /etc/udev/rules.d/12-dm-permissions.rules增加ENV{DM_NAME}arch4, OWNER:grid, GROUP:asmadmin, MODE:660ENV{DM_NAME}data3, OWNER:grid, GROUP:asmadmin, MODE:6604.加载配置文件[rootrac-db1 /]# /sbin/udevadm control reload-rules5.添加udev磁盘(生产库千万别重启udev否则vip会漂移且网卡信息可能会被删除甚至宕库重启监听可解决)udevadm trigger --subsystem-matchblock --actionadd[rootjyrac1 network-scripts]# udevadm control reload-rulesunrecognized commandudevadm[27284]: unrecognized command[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]# /sbin/udevadm control reload-rulesunrecognized commandudevadm[27682]: unrecognized command[rootjyrac1 network-scripts]# find / -name udevadm/sbin/udevadm^C[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]#[rootjyrac1 network-scripts]# cd[rootjyrac1 ~]# /sbin/udevadm control reload-rulesunrecognized commandudevadm[27987]: unrecognized command[rootjyrac1 ~]# ls -la /sbin/udevadm-rwxr-xr-x. 1 root root 137256 Oct 17 2013 /sbin/udevadm[rootjyrac1 ~]# /sbin/udevadm control reload-rulesunrecognized commandudevadm[28151]: unrecognized command[rootjyrac1 ~]# /sbin/start_udevStarting udev: [ OK ][rootjyrac1 ~]#6.检查磁盘属性ll -l /dev/dm*如果有问题可以考虑重启multipath 或者udev试试。/sbin/start_udevorservice multipathd restart再次检查属性确认没问题之后考虑启动集群服务。[rootjyrac1 ~]# ll -l /dev/dm*brw-rw----. 1 root disk 253, 0 Apr 11 18:23 /dev/dm-0brw-rw----. 1 root disk 253, 1 Apr 11 18:23 /dev/dm-1brw-rw----. 1 grid asmadmin 253, 10 Apr 11 18:23 /dev/dm-10brw-rw----. 1 root disk 253, 11 Apr 11 18:23 /dev/dm-11brw-rw----. 1 root disk 253, 12 Apr 11 18:23 /dev/dm-12brw-rw----. 1 grid asmadmin 253, 13 Apr 11 18:23 /dev/dm-13brw-rw----. 1 grid asmadmin 253, 14 Apr 11 18:23 /dev/dm-14brw-rw----. 1 root disk 253, 2 Apr 11 18:23 /dev/dm-2brw-rw----. 1 grid asmadmin 253, 3 Apr 11 18:23 /dev/dm-3brw-rw----. 1 grid asmadmin 253, 4 Apr 11 18:23 /dev/dm-4brw-rw----. 1 grid asmadmin 253, 5 Apr 11 18:23 /dev/dm-5brw-rw----. 1 grid asmadmin 253, 6 Apr 11 18:23 /dev/dm-6brw-rw----. 1 grid asmadmin 253, 7 Apr 11 18:23 /dev/dm-7brw-rw----. 1 grid asmadmin 253, 8 Apr 11 18:23 /dev/dm-8brw-rw----. 1 grid asmadmin 253, 9 Apr 11 18:23 /dev/dm-9[rootjyrac1 ~]#[rootjyrac2 ~]# ll -l /dev/dm*brw-rw---- 1 root disk 253, 0 Apr 11 18:25 /dev/dm-0brw-rw---- 1 root disk 253, 1 Apr 11 18:25 /dev/dm-1brw-rw---- 1 grid asmadmin 253, 10 Apr 11 18:25 /dev/dm-10brw-rw---- 1 root disk 253, 11 Apr 11 18:25 /dev/dm-11brw-rw---- 1 root disk 253, 12 Apr 11 18:25 /dev/dm-12brw-rw---- 1 grid asmadmin 253, 13 Apr 11 18:25 /dev/dm-13brw-rw---- 1 grid asmadmin 253, 14 Apr 11 18:25 /dev/dm-14brw-rw---- 1 root disk 253, 2 Apr 11 18:25 /dev/dm-2brw-rw---- 1 grid asmadmin 253, 3 Apr 11 18:25 /dev/dm-3brw-rw---- 1 grid asmadmin 253, 4 Apr 11 18:25 /dev/dm-4brw-rw---- 1 grid asmadmin 253, 5 Apr 11 18:25 /dev/dm-5brw-rw---- 1 grid asmadmin 253, 6 Apr 11 18:25 /dev/dm-6brw-rw---- 1 grid asmadmin 253, 7 Apr 11 18:25 /dev/dm-7brw-rw---- 1 grid asmadmin 253, 8 Apr 11 18:25 /dev/dm-8brw-rw---- 1 grid asmadmin 253, 9 Apr 11 18:25 /dev/dm-9[rootjyrac2 ~]#7.启动crs集群服务rac1/rac2su - root/u01/11.2.0/grid/bin/crsctl start crs######################## rac1/rac2 end############################8.检查crs服务su - gridcrs_stat -tcrsctl stat res -t9.启动数据库srvctl start database -d jyrac10.检查数据库状态crsctl stat res -t11.检查asm是否识别到未添加的磁盘set linesize 300col name for a20select group_number,name,state,type,total_mb,free_mb,usable_file_mb,allocation_unit_size/1024/1024 unit_mb from v$asm_diskgroup order by 1;GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB USABLE_FILE_MB UNIT_MB------------ -------------------- ---------------------- ------------ ---------- ---------- -------------- ----------1 ARCH MOUNTED EXTERN 614400 120548 120548 12 DATA MOUNTED EXTERN 409600 83773 83773 13 OCR MOUNTED NORMAL 15360 14434 4657 1set linesize 300col path for a50select group_number,name,path,mount_status,state,redundancy,total_mb,free_mb,failgroup,create_date from v$asm_disk order by 1,2;GROUP_NUMBER NAME PATH MOUNT_STATUS STATE REDUNDANCY TOTAL_MB FREE_MB FAILGROUP CREATE_DATE------------ -------------------- -------------------------------------------------- -------------- ---------------- -------------- ---------- ---------- ------------------------------------------------------------ -----------------------0 /dev/mapper/arch4 CLOSED NORMAL UNKNOWN 0 00 /dev/mapper/data3 CLOSED NORMAL UNKNOWN 0 01 ARCH_0000 /dev/mapper/arch1 CACHED NORMAL UNKNOWN 204800 40180 ARCH_0000 21-MAY-2015 11:00:321 ARCH_0001 /dev/mapper/arch2 CACHED NORMAL UNKNOWN 204800 40183 ARCH_0001 21-MAY-2015 11:00:321 ARCH_0002 /dev/mapper/arch3 CACHED NORMAL UNKNOWN 204800 40185 ARCH_0002 21-MAY-2015 11:00:322 DATA_0000 /dev/mapper/data1 CACHED NORMAL UNKNOWN 204800 41879 DATA_0000 21-MAY-2015 10:59:332 DATA_0001 /dev/mapper/data2 CACHED NORMAL UNKNOWN 204800 41894 DATA_0001 21-MAY-2015 10:59:333 OCR_0000 /dev/mapper/crs1 CACHED NORMAL UNKNOWN 5120 4812 OCR_0000 21-MAY-2015 10:16:243 OCR_0001 /dev/mapper/crs2 CACHED NORMAL UNKNOWN 5120 4810 OCR_0001 21-MAY-2015 10:16:243 OCR_0002 /dev/mapper/crs3 CACHED NORMAL UNKNOWN 5120 4812 OCR_0002 21-MAY-2015 10:16:2410 rows selected.12.ASM扩容alter diskgroup DATA add disk /dev/mapper/data3 rebalance power 8;alter diskgroup ARCH add disk /dev/mapper/arch4 rebalance power 8;13.检查进度SQL select * from v$asm_operation;GROUP_NUMBER OPERATION STATE POWER ACTUAL SOFAR EST_WORK EST_RATE EST_MINUTES ERROR_CODE------------ ---------- -------- ---------- ---------- ---------- ---------- ---------- ----------- ----------------------------------------------------------------------------------------1 REBAL WAIT 82 REBAL RUN 8 8 33914 108615 5606 13SQLset linesize 300col path for a50select group_number,name,path,mount_status,state,redundancy,total_mb,free_mb,failgroup,create_date from v$asm_disk order by 1,2;转自邮箱286397146qq.com昵称A这货不是DBA
