- Oracle管理
解决rac服务ora.DATA1.dg及rac2数据库offline
时间：2015/4/9 20:38:11 作者：solgle 来源：www.solgle.com 查看：4508 评论：2内容摘要：解决rac服务ora.DATA1.dg及ac2数据库关闭offline注：尽管个别服务不正常，但是数据库是可以正常访问，没有断过，下面进行了如下处理[grid@rac1 bin]$ ./crsctl stat res -t-----------------------------...解决rac服务ora.DATA1.dg及ac2数据库关闭offline注：尽管个别服务不正常，但是数据库是可以正常访问，没有断过，下面进行了如下处理[grid@rac1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE OFFLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1ONLINE ONLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE ONLINE rac1 Open2 ONLINE OFFLINE Instance Shutdownora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1---尝试重新启动rac2的服务，可是失败了[grid@rac1 bin]$ ./srvctl stop nodeapps -n rac2PRCR-1065 : 无法停止资源 ora.rac2.vipCRS-2529: Unable to act on 'ora.rac2.vip' because that would require stopping or relocating 'ora.LISTENER.lsnr', but the force option was not specifiedPRCR-1014 : 无法停止资源 ora.net1.networkPRCR-1065 : 无法停止资源 ora.net1.networkCRS-2529: Unable to act on 'ora.net1.network' because that would require stopping or relocating 'ora.rac2.vip', but the force option was not specified----在rac2上扫描磁盘组，均正常[root@rac2 ~]# oracleasm listdisksDISK1DISK2[root@rac2 ~]# oracleasm scandisksReloading disk partitions: doneCleaning any stale ASM disks...Cleaning disk "DISK2"Scanning system for ASM disks...Instantiating disk "DISK2"[root@rac2 ~]# oracleasm listdisksDISK1DISK2---试着重启asm服务[grid@rac1 bin]$ ./srvctl stop asm -n rac2[grid@rac1 bin]$ ./srvctl start asm -n rac2[grid@rac1 bin]$ ./crsctl stat res -t[grid@rac1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1OFFLINE OFFLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE ONLINE rac1 Open2 OFFLINE OFFLINE Instance Shutdownora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1[grid@rac1 bin]$---这样可以了ora.DATA1.dg磁盘组已经online了，可是ons确下线了---在rac2上启动ons服务[root@rac2 bin]# ./onsctl startCRS-2672: Attempting to start 'ora.ons' on 'rac2'CRS-2676: Start of 'ora.ons' on 'rac2' succeeded[root@rac2 bin]# ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1ONLINE ONLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE ONLINE rac1 Open2 OFFLINE OFFLINE Instance Shutdownora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1[root@rac2 bin]#----下面启动rac2数据库[root@rac2 bin]# ./srvctl start instance -d solgle -n rac2 -o open[root@rac2 bin]#-----服务已经恢复[root@rac2 bin]# ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1ONLINE ONLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE ONLINE rac1 Open2 ONLINE ONLINE rac2 Openora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1[root@rac2 bin]#solgle.com 版权所有，欢迎分享！！！
- 相关文章
- 相关评论
- 本类更新
- 本类排行
-
12-2sysaux表空间占用率很高是awr太多？
-
4-8dbca创建数据库时,No protocol specified
-
12-23检查rac服务时，发现ons服务offline
-
4-9解决rac服务ora.DATA1.dg及rac2数据库offline
-
2-1Interval按日期建立了分区,找到某个时间段对应的分区被释放空间
-
9-7Oracle flash_recovery_area满了的解决办法
-
7-8ORA-02303:无法使用类型或表的相关性来删除或取代一个类型
-
12-1asmcmd登陆问题小计
-
8-2[INS-30507] Empty ASM disk group
-
4-11sqlldr数据导入导出案例
-
Copyright © 2013-2028 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
