oracle 11gR2 RAC的一致性停库和启库

最新推荐文章于 2024-05-22 11:44:02 发布

conggangdian4456

最新推荐文章于 2024-05-22 11:44:02 发布

阅读量151

点赞数

文章标签：数据库

一. 停监听（任一节点）

[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node2
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
ora.ractest.srvtest.svc
1 ONLINE ONLINE node1
2 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2

[grid@node1 ~]$ srvctl stop scan_listener
[grid@node1 ~]$ srvctl stop listener

grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 ONLINE ONLINE node1 Open
2 ONLINE ONLINE node2 Open
ora.ractest.srvtest.svc
1 ONLINE ONLINE node1
2 ONLINE ONLINE node2
ora.scan1.vip
1 ONLINE ONLINE node2

二. 杀会话（两个节点）

select 'alter system disconnect session ''' ||sid||','||serial#||''' immediate;' from v$session where type='USER';

三. 做检查点操作（两个节点）

alter system switch logfile;
alter system checkpoint;

四. 关闭数据库和CRS

（1）关库（任一节点）
[grid@node1 ~]$ srvctl stop database -d ractest -o immediate

[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.OCRDG.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.registry.acfs
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.cvu
1 ONLINE ONLINE node2
ora.node1.vip
1 ONLINE ONLINE node1
ora.node2.vip
1 ONLINE ONLINE node2
ora.oc4j
1 ONLINE ONLINE node2
ora.ractest.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.ractest.srvtest.svc
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE node2

（2）关CRS（两个节点）

root用户：

[root@node1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
[root@node2 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs

五. 停ASM（两个节点）
如果要停ASM，root用户下：
[root@node1 ~]# /etc/init.d/oracleasm stop

[root@node2 ~]# /etc/init.d/oracleasm stop

六. 启库
与停库顺序相反

注意：11gR2的RAC，如果是用shutdown immediate而不是用srvctl stop database -d xxx -o immediate停库，那么在启CRS后也需要手动把库启起来

如果手动把实例启起来后，在crsctl status res -t显示某个实例还是Instance Shutdown的话，但实际上实例是已经启起来了，可用命令 srvctl start instance -d xxx -n xxx解决。

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

转载于:http://blog.itpub.net/25465866/viewspace-1210363/