ITPub博客

首页 > 数据库 > Oracle > oracle数据库服务切换

oracle数据库服务切换

原创 Oracle 作者:tangyunoracle 时间:2012-05-13 00:43:20 0 删除 编辑
oracle数据库的服务切换其实也是一个很简单的过程,不过因为很多地方都不使用服务,所以很多刚开始接触oracle的兄弟都对这个东西不是很熟悉,前以前还有一个开发商的同事问起这个东西。所以这里就把之前做的一个实际例子贴一下供一些刚接触的朋友参考。[@more@]

-------节点1
bash-2.05$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gddb21
ora.gddb21.gsd application ONLINE ONLINE gddb21
ora.gddb21.ons application ONLINE ONLINE gddb21
ora.gddb21.vip application ONLINE ONLINE gddb21
ora....SM2.asm application ONLINE ONLINE gddb22
ora.gddb22.gsd application ONLINE ONLINE gddb22
ora.gddb22.ons application ONLINE ONLINE gddb22
ora.gddb22.vip application ONLINE ONLINE gddb22
ora.uwnms2.db application ONLINE ONLINE gddb22
ora....nms2.cs application ONLINE ONLINE gddb22
ora....s21.srv application ONLINE ONLINE gddb21
ora....s22.srv application ONLINE ONLINE gddb22
ora....ms21.cs application ONLINE ONLINE gddb22
ora....21.inst application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....ms22.cs application ONLINE ONLINE gddb22
ora....22.inst application ONLINE ONLINE gddb22
ora....s22.srv application ONLINE ONLINE gddb22

SQL> show parameter service
NAME TYPE VALUE
------------------------------------ -----------
service_names string uwnms21, suwnms2, uwnms2
SQL>
------------节点2----
bash-2.05$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gddb21
ora.gddb21.gsd application ONLINE ONLINE gddb21
ora.gddb21.ons application ONLINE ONLINE gddb21
ora.gddb21.vip application ONLINE ONLINE gddb21
ora....SM2.asm application ONLINE ONLINE gddb22
ora.gddb22.gsd application ONLINE ONLINE gddb22
ora.gddb22.ons application ONLINE ONLINE gddb22
ora.gddb22.vip application ONLINE ONLINE gddb22
ora.uwnms2.db application ONLINE ONLINE gddb22
ora....nms2.cs application ONLINE ONLINE gddb22
ora....s21.srv application ONLINE ONLINE gddb21
ora....s22.srv application ONLINE ONLINE gddb22
ora....ms21.cs application ONLINE ONLINE gddb22
ora....21.inst application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....ms22.cs application ONLINE ONLINE gddb22
ora....22.inst application ONLINE ONLINE gddb22
ora....s22.srv application ONLINE ONLINE gddb22

SQL> show parameter service

NAME TYPE VALUE
------------------------------------ -----------
service_names string uwnms2, suwnms2, uwnms22
------把服务切到节点1上
bash-2.05$srvctl relocate service -d uwnms2 -s uwnms22 -i uwnms22 -t uwnms21
-------------节点1-------
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ -----------
service_names string uwnms21, suwnms2, uwnms2, uwnms22
----------节点2-------------
---接着先停掉agent
---接着停掉监听
---杀掉LOCAL=NO的进程
---停掉实例
---停掉ASM
---停掉其他资源
---停掉CRS
bash-2.05$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gddb21
ora.gddb21.gsd application ONLINE ONLINE gddb21
ora.gddb21.ons application ONLINE ONLINE gddb21
ora.gddb21.vip application ONLINE ONLINE gddb21
ora....SM2.asm application OFFLINE OFFLINE
ora.gddb22.gsd application OFFLINE OFFLINE
ora.gddb22.ons application OFFLINE OFFLINE
ora.gddb22.vip application OFFLINE OFFLINE
ora.uwnms2.db application ONLINE ONLINE gddb21
ora....nms2.cs application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....s22.srv application ONLINE OFFLINE
ora....ms21.cs application ONLINE ONLINE gddb21
ora....21.inst application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....ms22.cs application ONLINE ONLINE gddb21
ora....22.inst application OFFLINE OFFLINE
ora....s22.srv application ONLINE ONLINE gddb21
-------启动CRS,其他资源会自动启动
bash-2.05$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gddb21
ora.gddb21.gsd application ONLINE ONLINE gddb21
ora.gddb21.ons application ONLINE ONLINE gddb21
ora.gddb21.vip application ONLINE ONLINE gddb21
ora....SM2.asm application ONLINE ONLINE gddb22
ora.gddb22.gsd application ONLINE ONLINE gddb22
ora.gddb22.ons application ONLINE ONLINE gddb22
ora.gddb22.vip application ONLINE ONLINE gddb22
ora.uwnms2.db application ONLINE ONLINE gddb21
ora....nms2.cs application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....s22.srv application ONLINE OFFLINE
ora....ms21.cs application ONLINE ONLINE gddb21
ora....21.inst application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....ms22.cs application ONLINE ONLINE gddb21
ora....22.inst application ONLINE ONLINE gddb22
ora....s22.srv application ONLINE ONLINE gddb22
-------在节点1上把服务切回来
bash-2.05$ srvctl relocate service -d uwnms2 -s uwnms22 -i uwnms21 -t uwnms22
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ -----------
service_names string uwnms2, suwnms2, uwnms22
bash-2.05$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE gddb21
ora.gddb21.gsd application ONLINE ONLINE gddb21
ora.gddb21.ons application ONLINE ONLINE gddb21
ora.gddb21.vip application ONLINE ONLINE gddb21
ora....SM2.asm application ONLINE ONLINE gddb22
ora.gddb22.gsd application ONLINE ONLINE gddb22
ora.gddb22.ons application ONLINE ONLINE gddb22
ora.gddb22.vip application ONLINE ONLINE gddb22
ora.uwnms2.db application ONLINE ONLINE gddb21
ora....nms2.cs application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....s22.srv application ONLINE ONLINE gddb22
ora....ms21.cs application ONLINE ONLINE gddb21
ora....21.inst application ONLINE ONLINE gddb21
ora....s21.srv application ONLINE ONLINE gddb21
ora....ms22.cs application ONLINE ONLINE gddb21
ora....22.inst application ONLINE ONLINE gddb22
ora....s22.srv application ONLINE ONLINE gddb22
---------检查监听是否正常
---------启动agent
---------检查gc状态
srvctl relocate service -d -s -I -t
将当前运行在DGDB2的SDG服务切换回DGDB1实例
srvctl relocate service -d dgdb -s sdg -i dgdb2 -t dgdb1(如没有用户连接,可在30秒内完成操作)
执行该操作会自动中止用户连接,建议服务切换时,先通知开发商停止用户,同时使用以下服务启停方式进行切换。
启动服务:srvctl start service -d dgdb -s sdg -i dgdb1
停止服务:srvctl stop service -d dgdb -s sdg

其实运行一下 srvctl -help 一切操作都很清楚了。

---------End-----------------------------------------

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

请登录后发表评论 登录
全部评论
有空写写一写,没空看一看。。。 微信号:tangyun0925
  • 博文量
    116
  • 访问量
    1839878