Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖
楼主: swgsw
查看: 9930| 回复: 53
51#
发表于 2013-1-25 21:33:26
klrqrac01->crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.klrqrac.db application    ONLINE    ONLINE    klrqrac01   
ora....c1.inst application    ONLINE    OFFLINE               
ora....c2.inst application    ONLINE    ONLINE    klrqrac02   
ora....SM1.asm application    ONLINE    ONLINE    klrqrac01   
ora....01.lsnr application    ONLINE    ONLINE    klrqrac01   
ora....c01.gsd application    ONLINE    ONLINE    klrqrac01   
ora....c01.ons application    ONLINE    ONLINE    klrqrac01   
ora....c01.vip application    ONLINE    ONLINE    klrqrac01   
ora....SM2.asm application    ONLINE    ONLINE    klrqrac02   
ora....02.lsnr application    ONLINE    ONLINE    klrqrac02   
ora....c02.gsd application    ONLINE    ONLINE    klrqrac02   
ora....c02.ons application    ONLINE    ONLINE    klrqrac02   
ora....c02.vip application    ONLINE    ONLINE    klrqrac02   
klrqrac01->crs_stat |grep inst
NAME=ora.klrqrac.klrqrac1.inst
NAME=ora.klrqrac.klrqrac2.inst
klrqrac01->crs_stop -f ora.klrqrac.klrqrac1.inst
Target set to OFFLINE for `ora.klrqrac.klrqrac1.inst`
klrqrac01->srvctl start instance -i klrqrac1 -d klrqrac
PRKP-1001 : Error starting instance klrqrac1 on node klrqrac01
CRS-0215: Could not start resource 'ora.klrqrac.klrqrac1.inst'.

回复 只看该作者 道具 举报

52#
发表于 2013-1-25 21:34:48


alert.log !!!!

回复 只看该作者 道具 举报

53#
发表于 2013-1-25 21:36:16
2013-01-25 20:51:21.487
[cssd(11936)]CRS-1605:CSSD voting file is online: /dev/raw/raw2. Details in /u01/oracle/product/10.2.0.1/crs/log/klrqrac01/cssd/ocssd.log.
[cssd(11936)]CRS-1601:CSSD Reconfiguration complete. Active nodes are klrqrac01 klrqrac02 .
2013-01-25 20:51:22.792
[evmd(11118)]CRS-1401:EVMD started on node klrqrac01.
2013-01-25 20:51:22.970
[crsd(11214)]CRS-1012:The OCR service started on node klrqrac01.
2013-01-25 20:51:25.113
[crsd(11214)]CRS-1201:CRSD started on node klrqrac01.
2013-01-25 20:51:57.884
[crsd(11214)]CRS-1205:Auto-start failed for the CRS resource . Details in klrqrac01.
2013-01-25 21:24:17.249
[cssd(11280)]CRS-1605:CSSD voting file is online: /dev/raw/raw2. Details in /u01/oracle/product/10.2.0.1/crs/log/klrqrac01/cssd/ocssd.log.
[cssd(11280)]CRS-1601:CSSD Reconfiguration complete. Active nodes are klrqrac01 klrqrac02 .
2013-01-25 21:24:24.746
[crsd(10751)]CRS-1005:The OCR upgrade was completed. Version has changed from 169870336 to 169870336. Details in /u01/oracle/product/10.2.0.1/crs/log/klrqrac01/crsd/crsd.log.
2013-01-25 21:24:24.746
[crsd(10751)]CRS-1012:The OCR service started on node klrqrac01.
2013-01-25 21:24:24.777
[evmd(10705)]CRS-1401:EVMD started on node klrqrac01.
2013-01-25 21:24:28.895
[crsd(10751)]CRS-1201:CRSD started on node klrqrac01.
2013-01-25 21:25:35.588
[crsd(10751)]CRS-1205:Auto-start failed for the CRS resource . Details in klrqrac01.

回复 只看该作者 道具 举报

54#
发表于 2013-1-25 21:54:48

能解决问题是因为有 诊断的流程! 流程很重要!

回复 只看该作者 道具 举报

12
返回列表
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-16 08:18 , Processed in 0.058053 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569