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

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

9

主题
1#
发表于 2014-12-3 09:47:42 | 查看: 3648| 回复: 1
oel6.3 11.2.0.4 rac双节点,其中一个节点服务器os损坏,已剔除节点,在增加cluster节点的时候执行cluvfy check,提示CRS is not found to be installed on node "rac1"
  1. [grid@rac1 bin]$ cluvfy stage -pre nodeadd -n rac2 -fixup -verbose

  2. Performing pre-checks for node addition

  3. Checking node reachability...

  4. Check: Node reachability from node "rac1"
  5.   Destination Node                      Reachable?              
  6.   ------------------------------------  ------------------------
  7.   rac2                                  yes                     
  8. Result: Node reachability check passed from node "rac1"


  9. Checking user equivalence...

  10. Check: User equivalence for user "grid"
  11.   Node Name                             Status                  
  12.   ------------------------------------  ------------------------
  13.   rac2                                  passed                  
  14. Result: User equivalence check passed for user "grid"

  15. ERROR:
  16. PRVF-7593 : CRS is not found to be installed on node "rac1"
  17. Verification cannot proceed


  18. Pre-check for node addition was unsuccessful on all the nodes.

  19. crs正常.
  20. [root@rac1 crsd]# crsctl check crs
  21. CRS-4638: Oracle High Availability Services is online
  22. CRS-4537: Cluster Ready Services is online
  23. CRS-4529: Cluster Synchronization Services is online
  24. CRS-4533: Event Manager is online

  25. [root@rac1 crsd]# crsctl status res -t
  26. --------------------------------------------------------------------------------
  27. NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
  28. --------------------------------------------------------------------------------
  29. Local Resources
  30. --------------------------------------------------------------------------------
  31. ora.DATA.dg
  32.                ONLINE  ONLINE       rac1                                         
  33. ora.FLASHBACK_AREA.dg
  34.                ONLINE  ONLINE       rac1                                         
  35. ora.LISTENER.lsnr
  36.                ONLINE  ONLINE       rac1                                         
  37. ora.MSDRAC_LISTENER.lsnr
  38.                ONLINE  ONLINE       rac1                                         
  39. ora.OCR.dg
  40.                ONLINE  ONLINE       rac1                                         
  41. ora.REDO1.dg
  42.                ONLINE  ONLINE       rac1                                         
  43. ora.REDO2.dg
  44.                ONLINE  ONLINE       rac1                                         
  45. ora.asm
  46.                ONLINE  ONLINE       rac1                     Started            
  47. ora.gsd
  48.                OFFLINE OFFLINE      rac1                                         
  49. ora.net1.network
  50.                ONLINE  ONLINE       rac1                                         
  51. ora.ons
  52.                ONLINE  ONLINE       rac1                                         
  53. ora.registry.acfs
  54.                ONLINE  ONLINE       rac1                                         
  55. --------------------------------------------------------------------------------
  56. Cluster Resources
  57. --------------------------------------------------------------------------------
  58. ora.LISTENER_SCAN1.lsnr
  59.       1        ONLINE  ONLINE       rac1                                         
  60. ora.LISTENER_SCAN2.lsnr
  61.       1        ONLINE  ONLINE       rac1                                         
  62. ora.cvu
  63.       1        ONLINE  ONLINE       rac1                                         
  64. ora.msdrac.db
  65.       2        ONLINE  ONLINE       rac1                     Open               
  66. ora.oc4j
  67.       1        ONLINE  ONLINE       rac1                                         
  68. ora.rac1.vip
  69.       1        ONLINE  ONLINE       rac1                                         
  70. ora.scan1.vip
  71.       1        ONLINE  ONLINE       rac1                                         
  72. ora.scan2.vip
  73.       1        ONLINE  ONLINE       rac1                                         

复制代码
大家帮忙看一下,谢谢!
你不放弃希望,希望就不会放弃你.
2#
发表于 2014-12-3 10:22:35
本帖最后由 Leo 于 2014-12-3 10:27 编辑

[grid@rac1 log]$ vi /g01/11ggrid/app/11.2.0/grid/cv/log/cvutrace.log.1
  1. [30611@rac1] [main] [ 2014-12-03 09:22:30.275 CST ] [Version$VersionEnum.getEnumMember:200]  Version Match Successful: returning version object 11.2.0.4
  2. [30611@rac1] [main] [ 2014-12-03 09:22:30.277 CST ] [VerificationUtil.getDestLoc:2717]  ==== CV_DESTLOC(pre-fetched value): '/tmp/'
  3. [30611@rac1] [main] [ 2014-12-03 09:22:30.277 CST ] [UnixSystem.copyFile:660]  Copy file localnode:/etc/oracle/olr.loc to localnode:/tmp/localnode.olr.loc
  4. [30611@rac1] [main] [ 2014-12-03 09:22:30.277 CST ] [UnixSystem.copyFile:686]  UnixSystem: /bin/cp -p /etc/oracle/olr.loc /tmp/localnode.olr.loc
  5. [30611@rac1] [main] [ 2014-12-03 09:22:30.277 CST ] [RuntimeExec.runCommand:75]  Calling Runtime.exec() with the command
  6. [30611@rac1] [main] [ 2014-12-03 09:22:30.277 CST ] [RuntimeExec.runCommand:77]  /bin/cp
  7. [30611@rac1] [main] [ 2014-12-03 09:22:30.278 CST ] [RuntimeExec.runCommand:77]  -p
  8. [30611@rac1] [main] [ 2014-12-03 09:22:30.278 CST ] [RuntimeExec.runCommand:77]  /etc/oracle/olr.loc
  9. [30611@rac1] [main] [ 2014-12-03 09:22:30.278 CST ] [RuntimeExec.runCommand:77]  /tmp/localnode.olr.loc
  10. [30611@rac1] [Thread-67] [ 2014-12-03 09:22:30.288 CST ] [StreamReader.run:61]  In StreamReader.run
  11. [30611@rac1] [main] [ 2014-12-03 09:22:30.288 CST ] [RuntimeExec.runCommand:142]  runCommand: Waiting for the process
  12. [30611@rac1] [Thread-68] [ 2014-12-03 09:22:30.288 CST ] [StreamReader.run:61]  In StreamReader.run
  13. [30611@rac1] [main] [ 2014-12-03 09:22:30.293 CST ] [RuntimeExec.runCommand:144]  runCommand: process returns 0
  14. [30611@rac1] [main] [ 2014-12-03 09:22:30.294 CST ] [RuntimeExec.runCommand:161]  RunTimeExec: output>
  15. [30611@rac1] [main] [ 2014-12-03 09:22:30.294 CST ] [RuntimeExec.runCommand:170]  RunTimeExec: error>
  16. [30611@rac1] [main] [ 2014-12-03 09:22:30.294 CST ] [RuntimeExec.runCommand:192]  Returning from RunTimeExec.runCommand
  17. [30611@rac1] [main] [ 2014-12-03 09:22:30.294 CST ] [NativeSystem.isCmdScv:502]  isCmdScv: cmd=[/bin/cp -p /etc/oracle/olr.loc /tmp/localnode.olr.loc]
  18. [30611@rac1] [main] [ 2014-12-03 09:22:30.295 CST ] [NativeSystem.isCmdScv:571]  isCmdScv: returned false
  19. [30611@rac1] [main] [ 2014-12-03 09:22:30.295 CST ] [NativeSystem.rununixcmd:1152]  NativeSystem.rununixcmd: RetString 1| :successful
  20. [30611@rac1] [main] [ 2014-12-03 09:22:30.295 CST ] [Utils.getPropertyValue:242]  keyName=olrconfig_loc props.val=/g01/11ggrid/app/11.2.0/grid/cdata/rac1.olr propValue=/g01/11ggrid/app/11.2.0/grid/cdata/rac1.olr
  21. [30611@rac1] [main] [ 2014-12-03 09:22:30.296 CST ] [Utils.getPropertyValue:242]  keyName=crs_home props.val=/g01/11ggrid/app/11.2.0/grid propValue=/g01/11ggrid/app/11.2.0/grid
  22. [30611@rac1] [main] [ 2014-12-03 09:22:30.296 CST ] [Utils.getPropertyValue:302]  propName=crs_home propValue=/g01/11ggrid/app/11.2.0/grid
  23. [30611@rac1] [main] [ 2014-12-03 09:22:30.296 CST ] [RuntimeExec.runCommand:75]  Calling Runtime.exec() with the command
  24. [30611@rac1] [main] [ 2014-12-03 09:22:30.297 CST ] [RuntimeExec.runCommand:77]  /bin/rm
  25. [30611@rac1] [main] [ 2014-12-03 09:22:30.297 CST ] [RuntimeExec.runCommand:77]  -f
  26. [30611@rac1] [main] [ 2014-12-03 09:22:30.297 CST ] [RuntimeExec.runCommand:77]  /tmp/localnode.olr.loc
  27. [30611@rac1] [Thread-70] [ 2014-12-03 09:22:30.304 CST ] [StreamReader.run:61]  In StreamReader.run
  28. [30611@rac1] [main] [ 2014-12-03 09:22:30.304 CST ] [RuntimeExec.runCommand:142]  runCommand: Waiting for the process
  29. [30611@rac1] [Thread-69] [ 2014-12-03 09:22:30.304 CST ] [StreamReader.run:61]  In StreamReader.run
  30. [30611@rac1] [main] [ 2014-12-03 09:22:30.308 CST ] [RuntimeExec.runCommand:144]  runCommand: process returns 0
  31. [30611@rac1] [main] [ 2014-12-03 09:22:30.308 CST ] [RuntimeExec.runCommand:161]  RunTimeExec: output>
  32. [30611@rac1] [main] [ 2014-12-03 09:22:30.309 CST ] [RuntimeExec.runCommand:170]  RunTimeExec: error>
  33. [30611@rac1] [main] [ 2014-12-03 09:22:30.309 CST ] [RuntimeExec.runCommand:192]  Returning from RunTimeExec.runCommand
  34. [30611@rac1] [main] [ 2014-12-03 09:22:30.309 CST ] [NativeSystem.isCmdScv:502]  isCmdScv: cmd=[/bin/rm -f /tmp/localnode.olr.loc]
  35. [30611@rac1] [main] [ 2014-12-03 09:22:30.310 CST ] [NativeSystem.isCmdScv:571]  isCmdScv: returned false
  36. [30611@rac1] [main] [ 2014-12-03 09:22:30.310 CST ] [NativeSystem.rununixcmd:1152]  NativeSystem.rununixcmd: RetString 1| :successful
  37. [30611@rac1] [main] [ 2014-12-03 09:22:30.311 CST ] [sVerificationUtil.getOLRPropertyValue:1667]  crs_home=/g01/11ggrid/app/11.2.0/grid
  38. [30611@rac1] [main] [ 2014-12-03 09:22:30.312 CST ] [OUIData.readInventoryData:505]  ==== ORACLE home added: Oracle home properties:
  39. Name     : OraDb11g_home1
  40. Type     : ORACLE-HOME
  41. Location : /s01/oracle/product/11.2.0/dbhome_1
  42. Node list: [rac1]
复制代码
[30611@rac1] [main] [ 2014-12-03 09:22:30.313 CST ] [OUIData.readInventoryData:467]  ==== ORACLE home marked 'removed'. Skipping : /g01/11ggrid/app/11.2.0/grid
[30611@rac1] [main] [ 2014-12-03 09:22:30.313 CST ] [VerificationUtil.isCRSInstalled:3536]  CRS wasn't found installed  on node: rac1
[30611@rac1] [main] [ 2014-12-03 09:22:30.313 CST ] [NodeAddStage.checkSetup:308]  ==== CRS NOT INSTALLED ON LOCAL HOST.
[30611@rac1] [main] [ 2014-12-03 09:22:30.314 CST ] [NodeAddStage.checkSetup:315]  == Parameters:

nodeList: rac2
validNodeList: rac2
newClusterNodes: rac1,rac2
validClusterNodes: rac1
validNewClusterNodes: rac1,rac2

[30611@rac1] [main] [ 2014-12-03 09:22:30.314 CST ] [ResultSet.traceResultSet:359]

After return from  checkSetup
        Overall Status->OPERATION_FAILED

        rac2-->OPERATION_FAILED


[30611@rac1] [main] [ 2014-12-03 09:22:30.315 CST ] [ReportUtil.printReportFooter:1626]  stageMsgID: node addition
[30611@rac1] [main] [ 2014-12-03 09:22:30.315 CST ] [CluvfyDriver.main:371]  ==== cluvfy exiting normally.

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-5-19 06:20 , Processed in 0.047687 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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