11g Rac 切换
来源:互联网 发布:股票数据查询 编辑:程序博客网 时间:2024/05/01 23:29
<pre name="code" class="sql">[grid@devrac1 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac1 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2######################################################################################################################################################################[grid@devrac2 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac1 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 ----开始连在devrac1节点上SQL> select distinct username from v$session;USERNAME------------------------------HZMCASSETCZCISSYSCBSRUN[grid@devrac1 ~]$ crsctl stop crsCRS-4563: Insufficient user privileges.CRS-4000: Command Stop failed, or completed with errors.[grid@devrac1 ~]$ exitlogout[root@devrac1 grid]# crsctl stop crsCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'devrac1'CRS-2673: Attempting to stop 'ora.crsd' on 'devrac1'CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'devrac1'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'devrac1'CRS-2673: Attempting to stop 'ora.devrac.devrun1.svc' on 'devrac1'CRS-2677: Stop of 'ora.devrac.devrun1.svc' on 'devrac1' succeededCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.devrac1.vip' on 'devrac1'CRS-2677: Stop of 'ora.devrac1.vip' on 'devrac1' succeededCRS-2672: Attempting to start 'ora.devrac1.vip' on 'devrac2'CRS-2676: Start of 'ora.devrac1.vip' on 'devrac2' succeededCRS-2672: Attempting to start 'ora.devrac.devrun1.svc' on 'devrac2'CRS-2676: Start of 'ora.devrac.devrun1.svc' on 'devrac2' succeededCRS-2673: Attempting to stop 'ora.OCRVOT.dg' on 'devrac1'CRS-2673: Attempting to stop 'ora.devrac.db' on 'devrac1'CRS-2677: Stop of 'ora.devrac.db' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.DATA.dg' on 'devrac1'CRS-2677: Stop of 'ora.DATA.dg' on 'devrac1' succeededCRS-2677: Stop of 'ora.OCRVOT.dg' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'devrac1'CRS-2677: Stop of 'ora.asm' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.ons' on 'devrac1'CRS-2677: Stop of 'ora.ons' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.net1.network' on 'devrac1'CRS-2677: Stop of 'ora.net1.network' on 'devrac1' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'devrac1' has completedCRS-2677: Stop of 'ora.crsd' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.mdnsd' on 'devrac1'CRS-2673: Attempting to stop 'ora.ctssd' on 'devrac1'CRS-2673: Attempting to stop 'ora.evmd' on 'devrac1'CRS-2673: Attempting to stop 'ora.asm' on 'devrac1'CRS-2677: Stop of 'ora.evmd' on 'devrac1' succeededCRS-2677: Stop of 'ora.mdnsd' on 'devrac1' succeededCRS-2677: Stop of 'ora.asm' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'devrac1'CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'devrac1' succeededCRS-2677: Stop of 'ora.ctssd' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'devrac1'CRS-2677: Stop of 'ora.cssd' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.crf' on 'devrac1'CRS-2677: Stop of 'ora.crf' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'devrac1'CRS-2677: Stop of 'ora.gipcd' on 'devrac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'devrac1'CRS-2677: Stop of 'ora.gpnpd' on 'devrac1' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'devrac1' has completedCRS-4133: Oracle High Availability Services has been stopped.[grid@devrac2 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE OFFLINE Instance Shutdown 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac2 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE INTERMEDIATE devrac2 FAILED OVER ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 启动CRS:[grid@devrac1 ~]$ crsctl status res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS --------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 --------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac2 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 crsctl stop crs 方式停止数据库,启动后数据库会自动打开
0 0
- 11g Rac 切换
- oracle 10g 11g rac 虚拟环境切换
- ORACLE 11G RAC下的归档切换
- 11g rac 切换备库 SCAN IP不会漂移
- oracle 11g rac undo表空间切换
- 10G RAC 切换到归档模式
- oracle 10g rac归档模式切换
- 11G RAC 卸载
- Deinstall 11g RAC
- Oracle 11g RAC management.
- oracle rac 11g 文档
- 管理oracle 11g RAC
- 卸载oracle 11g & rac
- ORACLE 11G RAC 常用命令
- 11g Rac 服务介绍
- oracle 11G rac搭建
- oracle 11g rac 搭建
- linux安装11g rac
- JAVA调用支付宝直充接口
- 判断DATASET是否为空
- 驻衡阳某军械仓库发生爆炸事故 17名官兵遇难
- 黑马程序员——学习日志6面向对象(多态,内部类,异常,访问权限)
- 百度文库实现方案 openoffice.org 3 + swftools+flexpaper+java
- 11g Rac 切换
- java短信接口调用
- tcpdump网络抓包工具
- Software - Alitum Designer 14 安装
- HttpComponents入门解析
- HTTP协议详解
- STL用法总结
- 可靠多播技术
- 黑马程序员 交通等管理系统