oracle rac一次shutdown instance之后重启没法自动启动实例

来源：互联网发布：ubuntu安装flash命令编辑：程序博客网时间：2024/06/06 01:02

在11gR2中如果直接shutdown会导致重启crs无法自动启动instance

[grid@csicn20db02 ~]$ crsctl status res -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.CRS.dg

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.DATA.dg

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.LISTENER.lsnr

OFFLINE OFFLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.asm

ONLINE ONLINE csicn20db01 Started

ONLINE ONLINE csicn20db02 Started

ora.gsd

OFFLINE OFFLINE csicn20db01

OFFLINE OFFLINE csicn20db02

ora.net1.network

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.ons

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.registry.acfs

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE csicn20db01

ora.csicn20db01.vip

1 OFFLINE OFFLINE

ora.csicn20db02.vip

1 ONLINE ONLINE csicn20db02

ora.cvu

1 OFFLINE OFFLINE

ora.mycim.db

1 OFFLINE OFFLINE Instance Shutdown

2 OFFLINE OFFLINE Instance Shutdown

ora.oc4j

1 OFFLINE OFFLINE

ora.scan1.vip

1 ONLINE ONLINE csicn20db01

Note：可以看到，两个instance都是shutdown的状态

2：允许自动启动

[grid@csicn20db02 ~]$ srvctl enable database -d mycim

[grid@csicn20db01 ~]$ srvctl enable instance -d mycim -i mycim1

[grid@csicn20db01 ~]$ srvctl enable instance -d mycim -i mycim2

[grid@csicn20db01 ~]$ srvctl start database -d mycim

[grid@csicn20db01 ~]$ crsctl status res -t

3：重启

4：查看集群资源是否自动启动

[grid@csicn20db01 ~]$ crsctl status res -t

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

NAME TARGET STATE SERVER STATE_DETAILS

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

Local Resources

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

ora.CRS.dg

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.DATA.dg

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.LISTENER.lsnr

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.asm

ONLINE ONLINE csicn20db01 Started

ONLINE ONLINE csicn20db02 Started

ora.gsd

OFFLINE OFFLINE csicn20db01

OFFLINE OFFLINE csicn20db02

ora.net1.network

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.ons

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

ora.registry.acfs

ONLINE ONLINE csicn20db01

ONLINE ONLINE csicn20db02

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE csicn20db02

ora.csicn20db01.vip

1 ONLINE ONLINE csicn20db01

ora.csicn20db02.vip

1 ONLINE ONLINE csicn20db02

ora.cvu

1 OFFLINE OFFLINE

ora.mycim.db

1 ONLINE ONLINE csicn20db01 Open

2 ONLINE ONLINE csicn20db02 Open

ora.oc4j

1 OFFLINE OFFLINE

ora.scan1.vip

1 ONLINE ONLINE csicn20db02

Note：重启之后，数据库资源自动启动了。在rac环境下，不要在sqlplus直接shutdown的方式关闭数据实例，这样可能导致集群无法正常db和instance资源

5：关闭数据库资源方式

srvctl status database -d mycim

阅读全文

0 0