ORACLERAC+HPMC停止启动文档

最近项目组做了一次停止启动数据库和双机的操作，记录一下：

背景描述：项目组共有两个数据库，非实时库是两台机器，做成了ORACLE+RAC+HPMC

实时库是两台机器，ORACLE+HPMC

实际操作：

[@more@]

非实时

停止

一、 先停止ORACLERAC

1. 停止数据库服务和实例

查看资源，可以看到RAC正常运行

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application ONLINE ONLINE cpda01

ora.cpda01.gsd application ONLINE ONLINE cpda01

ora.cpda01.ons application ONLINE ONLINE cpda01

ora.cpda01.vip application ONLINE ONLINE cpda01

ora....02.lsnr application ONLINE ONLINE cpda02

ora.cpda02.gsd application ONLINE ONLINE cpda02

ora.cpda02.ons application ONLINE ONLINE cpda02

ora.cpda02.vip application ONLINE ONLINE cpda02

ora....a1.inst application ONLINE ONLINE cpda01

ora....a2.inst application ONLINE ONLINE cpda02

ora.da.db application ONLINE ONLINE cpda01

在任意的机器上以ORACLE用户执行

oracle@cpda02 /oracle $ srvctl stop database -d da

查看资源

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application ONLINE ONLINE cpda01

ora.cpda01.gsd application ONLINE ONLINE cpda01

ora.cpda01.ons application ONLINE ONLINE cpda01

ora.cpda01.vip application ONLINE ONLINE cpda01

ora....02.lsnr application ONLINE ONLINE cpda02

ora.cpda02.gsd application ONLINE ONLINE cpda02

ora.cpda02.ons application ONLINE ONLINE cpda02

ora.cpda02.vip application ONLINE ONLINE cpda02

ora....a1.inst application OFFLINE OFFLINE cpda01

ora....a2.inst application OFFLINE OFFLINE cpda02

ora.da.db application OFFLINE OFFLINE cpda01

可以看到数据库服务和实例已经被停止

2. 停止第一个节点的资源：

oracle@cpda02 /oracle $ srvctl stop nodeapps -n cpda01

查看资源

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application OFFLINE OFFLINE cpda01

ora.cpda01.gsd application OFFLINE OFFLINE cpda01

ora.cpda01.ons application OFFLINE OFFLINE cpda01

ora.cpda01.vip application OFFLINE OFFLINE cpda01

ora....02.lsnr application ONLINE ONLINE cpda02

ora.cpda02.gsd application ONLINE ONLINE cpda02

ora.cpda02.ons application ONLINE ONLINE cpda02

ora.cpda02.vip application ONLINE ONLINE cpda02

ora....a1.inst application OFFLINE OFFLINE cpda01

ora....a2.inst application OFFLINE OFFLINE cpda02

ora.da.db application OFFLINE OFFLINE cpda01

可以看到第一台机器的资源已经停止，对外的服务IP也无法访问了

3. 再停止第二台机器的资源

oracle@cpda02 /oracle $ srvctl stop nodeapps -n cpda02

查看资源

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application OFFLINE OFFLINE cpda01

ora.cpda01.gsd application OFFLINE OFFLINE cpda01

ora.cpda01.ons application OFFLINE OFFLINE cpda01

ora.cpda01.vip application OFFLINE OFFLINE cpda01

ora....02.lsnr application OFFLINE OFFLINE cpda02

ora.cpda02.gsd application OFFLINE OFFLINE cpda02

ora.cpda02.ons application OFFLINE OFFLINE cpda02

ora.cpda02.vip application OFFLINE OFFLINE cpda02

ora....a1.inst application OFFLINE OFFLINE cpda01

ora....a2.inst application OFFLINE OFFLINE cpda02

ora.da.db application OFFLINE OFFLINE cpda01

可以看到第二台机器的资源已经停止，对外的服务IP也无法访问了

4. 最后停止CRS

在两个节点以root用户执行

#cd /sbin/init.d

#./init.crs stop

可以看到CRS成功停止，注意这块CRS如果不停止，则停止MC集群的时候会出现问题

到此，ORACLERAC资源已经全部停止

二、 再停止MC集群

1. 停止集群包

# cmhaltpkg -v da01

One or more packages or package instances have been halted.

cmhaltpkg: Completed successfully on all packages specified

2. 停止集群双机

# cmhaltcl -v

Disabling all packages from starting on nodes to be halted.

Disabling all packages from running on cpda01.

Package da01 is already disabled on node cpda01

Disabling all packages from running on cpda02.

Package da01 is already disabled on node cpda02

Warning: Do not modify or enable packages until the halt operation is completed.

The group member is still running on cpda02.

Use the -f option to forcefully halt the cluster/node including halting group members.

# cmviewcl -v

CLUSTER STATUS

da up

NODE STATUS STATE

cpda01 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

NODE STATUS STATE

cpda02 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

MULTI_NODE_PACKAGES

PACKAGE STATUS STATE AUTO_RUN SYSTEM

da01 down halted enabled no

NODE_NAME STATUS STATE SWITCHING

cpda01 down halted disabled

NODE_NAME STATUS STATE SWITCHING

cpda02 down halted disabled

这块没有关掉CLUSTER包，只好采用强制的方法来关闭(加 -f)

当然下面这块用cmhaltcl –f –v也是可以的

# cmhaltnode -f cpda01

Disabling all packages from starting on nodes to be halted.

Package da01 is already disabled on node cpda01

Warning: Do not modify or enable packages until the halt operation is completed.

Waiting for nodes to halt .... done

Successfully halted all nodes specified.

Halt operation complete.

# cmhaltnode -f cpda02

Disabling all packages from starting on nodes to be halted.

Package da01 is already disabled on node cpda02

Warning: Do not modify or enable packages until the halt operation is completed.

Waiting for nodes to halt ... done

Successfully halted all nodes specified.

Halt operation complete.

# cmviewcl -v

CLUSTER STATUS

da down

NODE STATUS STATE

cpda01 down unknown

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 unknown

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY unknown 1/0/1/1/0/6/0 lan0

PRIMARY unknown 1/0/2/1/0 lan2

STANDBY unknown 1/0/10/1/0 lan3

NODE STATUS STATE

cpda02 down unknown

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 unknown

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY unknown 1/0/1/1/0/6/0 lan0

PRIMARY unknown 1/0/2/1/0 lan2

STANDBY unknown 1/0/10/1/0 lan3

MULTI_NODE_PACKAGES

PACKAGE STATUS STATE AUTO_RUN SYSTEM

da01 down halted enabled no

NODE_NAME STATUS STATE SWITCHING

cpda01 down

NODE_NAME STATUS STATE SWITCHING

cpda02 down

说明集群已经停止成功，至此停止完毕

启动

一、 启动双机及包

# cmruncl -v

cmruncl: Validating network configuration...

cmruncl: Network validation complete

cmruncl: Validating cluster lock disk .... Done

Waiting for cluster to form ...... done

Cluster successfully formed.

Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.

# cmviewcl –v

CLUSTER STATUS

da up

NODE STATUS STATE

cpda01 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

NODE STATUS STATE

cpda02 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c18t2d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

MULTI_NODE_PACKAGES

PACKAGE STATUS STATE AUTO_RUN SYSTEM

da01 up running enabled no

NODE_NAME STATUS STATE SWITCHING

cpda01 up running enabled

NODE_NAME STATUS STATE SWITCHING

cpda02 up running enabled

说明非实时库的集群启动正常

二、 启动ORACLERAC

用命令查看ORACLERAC的资源情况：

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application OFFLINE OFFLINE cpda01

ora.cpda01.gsd application OFFLINE OFFLINE cpda01

ora.cpda01.ons application OFFLINE OFFLINE cpda01

ora.cpda01.vip application OFFLINE OFFLINE cpda01

ora....02.lsnr application OFFLINE OFFLINE cpda02

ora.cpda02.gsd application OFFLINE OFFLINE cpda02

ora.cpda02.ons application OFFLINE OFFLINE cpda02

ora.cpda02.vip application OFFLINE OFFLINE cpda02

ora....a1.inst application OFFLINE OFFLINE cpda01

ora....a2.inst application OFFLINE OFFLINE cpda02

ora.da.db application OFFLINE OFFLINE cpda01

启动ORACLERAC资源：

以root用户在两台机器上执行

#cd /sbin/init.d

#./init.crs start

会出现30 second 后 run的字样

然后查看资源：

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application OFFLINE OFFLINE cpda01

ora.cpda01.gsd application OFFLINE OFFLINE cpda01

ora.cpda01.ons application ONLINE ONLINE cpda01

ora.cpda01.vip application ONLINE ONLINE cpda01

ora....02.lsnr application OFFLINE OFFLINE cpda02

ora.cpda02.gsd application OFFLINE OFFLINE cpda02

ora.cpda02.ons application OFFLINE OFFLINE cpda02

ora.cpda02.vip application ONLINE ONLINE cpda02

ora....a1.inst application OFFLINE OFFLINE cpda01

ora....a2.inst application OFFLINE OFFLINE cpda02

ora.da.db application OFFLINE OFFLINE cpda01

可以看出RAC正在启动

过一分钟再看：

oracle@cpda02 /oracle $ crs_stat -t

Name Type Target State Host

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

ora....01.lsnr application ONLINE ONLINE cpda01

ora.cpda01.gsd application ONLINE ONLINE cpda01

ora.cpda01.ons application ONLINE ONLINE cpda01

ora.cpda01.vip application ONLINE ONLINE cpda01

ora....02.lsnr application ONLINE ONLINE cpda02

ora.cpda02.gsd application ONLINE ONLINE cpda02

ora.cpda02.ons application ONLINE ONLINE cpda02

ora.cpda02.vip application ONLINE ONLINE cpda02

ora....a1.inst application ONLINE ONLINE cpda01

ora....a2.inst application ONLINE ONLINE cpda02

ora.da.db application ONLINE ONLINE cpda01

说明RAC资源已经全部启动，到此，启动完毕

实时

停止

一、 停止集群包

cp-mdb01_root[/]# cmhaltpkg -v mccdb01

Disabling automatic failover for failover packages to be halted.

Halting package mccdb01

Successfully halted package mccdb01

One or more packages or package instances have been halted.

The failover packages have AUTO_RUN disabled and no new instance can start automatically. To allow automatic start, enable AUTO_RUN via cmmodpkg -e

cmhaltpkg: Completed successfully on all packages specified

二、 停止集群双机

cp-mdb01_root[/]# cmhaltcl -v

Disabling all packages from starting on nodes to be halted.

Disabling all packages from running on cp-mdb01.

Disabling all packages from running on cp-mdb02.

Warning: Do not modify or enable packages until the halt operation is completed.

This operation may take some time.

Waiting for nodes to halt ... done

Successfully halted all nodes specified.

Halt operation complete.

cp-mdb01_root[/]# cmviewcl -v

CLUSTER STATUS

mccdb down

NODE STATUS STATE

cp-mdb01 down unknown

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c6t1d5 unknown

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY unknown 1/0/1/1/0/6/0 lan0

PRIMARY unknown 1/0/2/1/0 lan2

STANDBY unknown 1/0/10/1/0 lan3

NODE STATUS STATE

cp-mdb02 down unknown

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c6t1d5 unknown

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY unknown 1/0/1/1/0/6/0 lan0

PRIMARY unknown 1/0/2/1/0 lan2

STANDBY unknown 1/0/10/1/0 lan3

UNOWNED_PACKAGES

PACKAGE STATUS STATE AUTO_RUN NODE

mccdb01 down halted enabled unowned

Policy_Parameters:

POLICY_NAME CONFIGURED_VALUE

Failover configured_node

Failback manual

Script_Parameters:

ITEM STATUS NODE_NAME NAME

Subnet unknown cp-mdb01 10.248.2.0

Subnet unknown cp-mdb02 10.248.2.0

Node_Switching_Parameters:

NODE_TYPE STATUS SWITCHING NAME

Primary down cp-mdb01

Alternate down cp-mdb02

可以看到集群双机都已经停止

启动

实时库的脚本是集群双机启动带动包的启动，而包启动带动数据库的启动，所以只启动集群双机就行了

cp-mdb01_oracle[/]# cmruncl -v

cmruncl: Validating network configuration...

cmruncl: Network validation complete

cmruncl: Validating cluster lock disk .... Done

Waiting for cluster to form ...... done

Cluster successfully formed.

Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.

cp-mdb01_oracle[/]# cmviewcl -v

CLUSTER STATUS

mccdb up

NODE STATUS STATE

cp-mdb01 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c6t1d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

PACKAGE STATUS STATE AUTO_RUN NODE

mccdb01 starting starting enabled cp-mdb01

Policy_Parameters:

POLICY_NAME CONFIGURED_VALUE

Failover configured_node

Failback manual

Script_Parameters:

ITEM STATUS MAX_RESTARTS RESTARTS NAME

Service unknown 0 0 mccdb

Subnet up 10.248.2.0

Node_Switching_Parameters:

NODE_TYPE STATUS SWITCHING NAME

Primary up enabled cp-mdb01 (current)

Alternate up enabled cp-mdb02

NODE STATUS STATE

cp-mdb02 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c6t1d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

说明还没有启动完

cp-mdb01_oracle[/]# cmviewcl -v

CLUSTER STATUS

mccdb up

NODE STATUS STATE

cp-mdb01 up running

Cluster_Lock_LVM:

VOLUME_GROUP PHYSICAL_VOLUME STATUS

/dev/vglock /dev/dsk/c6t1d5 up

Network_Parameters:

INTERFACE STATUS PATH NAME

PRIMARY up 1/0/1/1/0/6/0 lan0

PRIMARY up 1/0/2/1/0 lan2

STANDBY up 1/0/10/1/0 lan3

PACKAGE STATUS STATE AUTO_RUN NODE

mccdb01 up running enabled cp-mdb01

Policy_Parameters:

POLICY_NAME CONFIGURED_VALUE

Failover configured_node

Failback manual

Script_Parameters:

ITEM STATUS MAX_RESTARTS RESTARTS NAME

Service up 0 0 mccdb

Subnet up 10.248.2.0

Node_Switching_Parameters:

NODE_TYPE STATUS SWITCHING NAME

Primary up enabled cp-mdb01 (current)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7490392/viewspace-1040045/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7490392/viewspace-1040045/