RAC增删节点操作 报告.docx

RAC增删节点操作 报告.docx

《RAC增删节点操作 报告.docx》由会员分享，可在线阅读，更多相关《RAC增删节点操作 报告.docx（30页珍藏版）》请在冰豆网上搜索。

RAC增删节点操作报告

测试环境RAC

增删节点报告

背景介绍

测试环境RAC打补丁异常，1节点反复重启，oracle官方回复方案为删除1节点再添加回集群，故此进行操作。

删除节点操作

1：

集群状态检查

[grid@ULINBDBOC02~]$crsctlstatres-t

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

NameTargetStateServerStatedetails

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

LocalResources

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

ora.ASMNET1LSNR_ASM.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.CRS.dg

ONLINEONLINEulinbdboc02STABLE

ora.DATA.dg

ONLINEONLINEulinbdboc02STABLE

ora.LISTENER.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.chad

ONLINEONLINEulinbdboc02STABLE

work

ONLINEONLINEulinbdboc02STABLE

ora.ons

ONLINEONLINEulinbdboc02STABLE

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

ClusterResources

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

ora.LISTENER_SCAN1.lsnr

1ONLINEONLINEulinbdboc02STABLE

ora.MGMTLSNR

1ONLINEONLINEulinbdboc02169.254.131.14310.1

0.10.12,STABLE

ora.asm

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Started,STABLE

3OFFLINEOFFLINESTABLE

ora.cpes.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.cvu

1ONLINEONLINEulinbdboc02STABLE

ora.ebank.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankcib.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankuat.db

1ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

2ONLINEOFFLINEInstanceShutdown,ST

ABLE

ora.edraft.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.eteller.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.mgmtdb

1ONLINEONLINEulinbdboc02Open,STABLE

ora.qosmserver

1OFFLINEOFFLINESTABLE

ora.rapidmin.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.scan1.vip

1ONLINEONLINEulinbdboc02STABLE

ora.smt.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.statment.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ulinbdboc01.vip

1ONLINEINTERMEDIATEulinbdboc02FAILEDOVER,STABLE

ora.ulinbdboc02.vip

1ONLINEONLINEulinbdboc02STABLE

ora.utsdb.db

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

2：

删除1节点oracle实例

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNamecpes-instanceNamecpes1-sysDBAUserNamesys-sysDBAPasswordoracle

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameebank-instanceNameebank1-sysDBAUserNamesys-sysDBAPasswordoracle

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameebankcib-instanceNameebankcib1-sysDBAUserNamesys-sysDBAPasswordoracle

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameebankuat-instanceNameebankuat1-sysDBAUserNamesys-sysDBAPasswordoracle

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameedraft-instanceNameedraft1-sysDBAUserNamesys-sysDBAPasswordPassw0rd

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameeteller-instanceNameeteller1-sysDBAUserNamesys-sysDBAPasswordPassw0rd

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNamerapidmin-instanceNamerapidmin1-sysDBAUserNamesys-sysDBAPasswordPassw0rd

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNamesmt-instanceNamesmt1-sysDBAUserNamesys-sysDBAPasswordPassw0rd

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNamestatment-instanceNamestatment1-sysDBAUserNamesys-sysDBAPasswordoracle

dbca-silent-deleteInstance-nodeListulinbdboc01-gdbNameutsdb-instanceNameutsdb1-sysDBAUserNamesys-sysDBAPasswordoracle

3：

停掉1节点监听

srvctldisablelistener-lLISTENER-nULINBDBOC01

srvctlstatuslistener-lLISTENERR-nULINBDBOC01

4：

oracle用户更新节点状态

$ORACLE_HOME/oui/bin/runInstaller-updateNodeListORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1"CLUSTER_NODES={ULINBDBOC02}"

5：

检查集群状态

[grid@ULINBDBOC02~]$crsctlstatres-t

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

NameTargetStateServerStatedetails

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

LocalResources

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

ora.ASMNET1LSNR_ASM.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.CRS.dg

ONLINEONLINEulinbdboc02STABLE

ora.DATA.dg

ONLINEONLINEulinbdboc02STABLE

ora.LISTENER.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.chad

ONLINEONLINEulinbdboc02STABLE

work

ONLINEONLINEulinbdboc02STABLE

ora.ons

ONLINEONLINEulinbdboc02STABLE

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

ClusterResources

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

ora.LISTENER_SCAN1.lsnr

1ONLINEONLINEulinbdboc02STABLE

ora.MGMTLSNR

1ONLINEONLINEulinbdboc02169.254.131.14310.1

0.10.12,STABLE

ora.asm

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Started,STABLE

3OFFLINEOFFLINESTABLE

ora.cpes.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.cvu

1ONLINEONLINEulinbdboc02STABLE

ora.ebank.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankcib.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankuat.db

1ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.edraft.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.eteller.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.mgmtdb

1ONLINEONLINEulinbdboc02Open,STABLE

ora.qosmserver

1OFFLINEOFFLINESTABLE

ora.rapidmin.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.scan1.vip

1ONLINEONLINEulinbdboc02STABLE

ora.smt.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.statment.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ulinbdboc01.vip

1ONLINEINTERMEDIATEulinbdboc02FAILEDOVER,STABLE

ora.ulinbdboc02.vip

1ONLINEONLINEulinbdboc02STABLE

ora.utsdb.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

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

6：

将1节点Unpinned

[grid@ULINBDBOC02~]$olsnodes-s-t

ulinbdboc01InactiveUnpinned

ulinbdboc02ActiveUnpinned

7：

移除1节点vip

[root@ULINBDBOC02~]#cd/u01/app/12.2.0/grid

[root@ULINBDBOC02grid]#cdbintl

[root@ULINBDBOC02bin]#./srvctlstopvip-iULINBDBOC01-VIP-f

[root@ULINBDBOC02bin]#./oifcfggetif

eno110.221.129.0globalpublic

eno210.10.10.0globalcluster_interconnect,asm

[root@ULINBDBOC02bin]#./srvctlremovevip-iULINBDBOC01-VIP-f

[root@ULINBDBOC02bin]#./crsctlstatres-t

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

NameTargetStateServerStatedetails

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

LocalResources

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

ora.ASMNET1LSNR_ASM.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.CRS.dg

ONLINEONLINEulinbdboc02STABLE

ora.DATA.dg

ONLINEONLINEulinbdboc02STABLE

ora.LISTENER.lsnr

ONLINEONLINEulinbdboc02STABLE

ora.chad

ONLINEONLINEulinbdboc02STABLE

work

ONLINEONLINEulinbdboc02STABLE

ora.ons

ONLINEONLINEulinbdboc02STABLE

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

ClusterResources

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

ora.LISTENER_SCAN1.lsnr

1ONLINEONLINEulinbdboc02STABLE

ora.MGMTLSNR

1ONLINEONLINEulinbdboc02169.254.131.14310.1

0.10.12,STABLE

ora.asm

1ONLINEOFFLINEInstanceShutdown,ST

ABLE

2ONLINEONLINEulinbdboc02Started,STABLE

3OFFLINEOFFLINESTABLE

ora.cpes.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.cvu

1ONLINEONLINEulinbdboc02STABLE

ora.ebank.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankcib.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.ebankuat.db

1ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.edraft.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.eteller.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/dbhome_1,STABLE

ora.mgmtdb

1ONLINEONLINEulinbdboc02Open,STABLE

ora.qosmserver

1OFFLINEOFFLINESTABLE

ora.rapidmin.db

2ONLINEONLINEulinbdboc02Open,HOME=/u01/app/o

racle/product/12.2.0

/d