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

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

8

积分

0

好友

2

主题
1#
发表于 2012-5-28 19:47:09 | 查看: 8260| 回复: 5
报asm磁盘组不能识别,但是我检查asm磁盘组的状态没问题。(我只用oracle一个用户创建rac)
请大家帮我看看,如何解决!!!

[root@grape1 disks]# ll
total 0
brw-rw---- 1 oracle asmadmin 8, 33 May 28 18:53 DATA
brw-rw---- 1 oracle asmadmin 8, 49 May 28 18:53 FRA
brw-rw---- 1 oracle asmadmin 8, 17 May 28 19:39 OCR_VOTE

[root@grape1 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
[root@grape1 ~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  INTERMEDIATE grape1                   Startup Initiated   
ora.crsd
      1        ONLINE  OFFLINE                                                   
ora.cssd
      1        ONLINE  ONLINE       grape1                                       
ora.cssdmonitor
      1        ONLINE  ONLINE       grape1                                       
ora.ctssd
      1        ONLINE  ONLINE       grape1                   ACTIVE:0            
ora.diskmon
      1        ONLINE  ONLINE       grape1                                       
ora.drivers.acfs
      1        ONLINE  OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       grape1                                       
ora.gipcd
      1        ONLINE  ONLINE       grape1                                       
ora.gpnpd
      1        ONLINE  ONLINE       grape1                                       
ora.mdnsd
      1        ONLINE  ONLINE       grape1      

[root@grape1 ~]# /u01/app/11.2.0/grid/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

crsd.log如下:

2012-05-28 18:55:30.267: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3897] Init gpnp local security key proveders 2 of 2: OLR wallet (LSKP-CLSW-OLR)
[   CLWAL][3046242000]clsw_Initialize: OLR initlevel [30000]
2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3919] Init gpnp local security key provider 2 of 2: OLR wallet (LSKP-CLSW-OLR) OK
2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1950] <Get gpnp security keys (wallet) for id:1,typ;7. (2 providers - fatal if all fail)
2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnpkwf_getWalletPath: [at clsgpnpkwf.c:498] req_id=1 ck_prov_id=1 wallet path: /u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/
2012-05-28 18:55:30.284: [    GPnP][3046242000]clsgpnpwu_walletfopen: [at clsgpnpwu.c:494] Opened SSO wallet: '/u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/cwallet.sso'
2012-05-28 18:55:30.284: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1965] Result: (0) CLSGPNP_OK. Get gpnp wallet - provider 1 of 2 (LSKP-FSW(1))
2012-05-28 18:55:30.285: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1982] Got gpnp security keys (wallet).>
2012-05-28 18:55:30.288: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1950] <Get gpnp security keys (wallet) for id:1,typ;4. (2 providers - fatal if all fail)
2012-05-28 18:55:30.288: [    GPnP][3046242000]clsgpnpkwf_getWalletPath: [at clsgpnpkwf.c:498] req_id=1 ck_prov_id=1 wallet path: /u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/
2012-05-28 18:55:30.299: [    GPnP][3046242000]clsgpnpwu_walletfopen: [at clsgpnpwu.c:494] Opened SSO wallet: '/u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/cwallet.sso'
2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1965] Result: (0) CLSGPNP_OK. Get gpnp wallet - provider 1 of 2 (LSKP-FSW(1))
2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1982] Got gpnp security keys (wallet).>
2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_Init: [at clsgpnp0.c:837] GPnP client pid=4422, tl=3, f=0
2012-05-28 18:55:30.324: [GIPCXCPT][3046242000] gipcShutdownF: skipping shutdown, count 2, from [ clsinet.c : 1732], ret gipcretSuccess (0)
2012-05-28 18:55:30.325: [GIPCXCPT][3046242000] gipcShutdownF: skipping shutdown, count 1, from [ clsgpnp0.c : 1021], ret gipcretSuccess (0)
2012-05-28 18:55:30.338: [  OCRASM][3046242000]proprasmo: Error in open/create file in dg [OCR_VOTE]
[  OCRASM][3046242000]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
ORA-15077: could not locate ASM instance serving a required diskgroup

2012-05-28 18:55:30.339: [  OCRASM][3046242000]proprasmo: kgfoCheckMount returned [7]
2012-05-28 18:55:30.339: [  OCRASM][3046242000]proprasmo: The ASM instance is down
2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprioo: Failed to open [+OCR_VOTE]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprioo: No OCR/OLR devices are usable
2012-05-28 18:55:30.340: [  OCRASM][3046242000]proprasmcl: asmhandle is NULL
2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprinit: Could not open raw device
2012-05-28 18:55:30.340: [  OCRASM][3046242000]proprasmcl: asmhandle is NULL
2012-05-28 18:55:30.340: [  OCRAPI][3046242000]a_init:16!: Backend init unsuccessful : [26]
2012-05-28 18:55:30.341: [  CRSOCR][3046242000] OCR context init failure.  Error: PROC-26: Error while accessing the physical storage ASM error [SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
ORA-15077: could not locate ASM instance serving a required diskgroup
] [7]
2012-05-28 18:55:30.341: [    CRSD][3046242000][PANIC] CRSD exiting: Could not init OCR, code: 26
2012-05-28 18:55:30.341: [    CRSD][3046242000] Done.
2#
发表于 2012-5-28 19:52:03
查了半天也不知道哪里有问题

crsd.log.txt

2 MB, 下载次数: 1597

回复 只看该作者 道具 举报

3#
发表于 2012-5-28 19:54:55
这个rac环境是通过rman恢复成功后,所有状态都是正常的,然后重启os报的错

回复 只看该作者 道具 举报

4#
发表于 2012-5-28 19:57:14
redhat linux 5.4  
oracle 11.2.0.1

回复 只看该作者 道具 举报

5#
发表于 2012-5-28 21:17:50
  1. 2012-05-28 18:55:28.261: [  OCRASM][3046409936]proprasmo: kgfoCheckMount returned [7]
  2. 2012-05-28 18:55:28.261: [  OCRASM][3046409936]proprasmo: The ASM instance is down
  3. 2012-05-28 18:55:28.261: [  OCRRAW][3046409936]proprioo: Failed to open [+OCR_VOTE]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
  4. 2012-05-28 18:55:28.261: [  OCRRAW][3046409936]proprioo: No OCR/OLR devices are usable
  5. 2012-05-28 18:55:28.261: [  OCRASM][3046409936]proprasmcl: asmhandle is NULL
  6. 2012-05-28 18:55:28.262: [  OCRRAW][3046409936]proprinit: Could not open raw device
  7. 2012-05-28 18:55:28.262: [  OCRASM][3046409936]proprasmcl: asmhandle is NULL
  8. 2012-05-28 18:55:28.262: [  OCRAPI][3046409936]a_init:16!: Backend init unsuccessful : [26]
  9. 2012-05-28 18:55:28.262: [  CRSOCR][3046409936] OCR context init failure.  Error: PROC-26: Error while accessing the physical storage ASM error [SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
  10. ORA-15077: could not locate ASM instance serving a required diskgroup
  11. ] [7]
  12. 2012-05-28 18:55:28.262: [    CRSD][3046409936][PANIC] CRSD exiting: Could not init OCR, code: 26
  13. 2012-05-28 18:55:28.262: [    CRSD][3046409936] Done.

  14. [  clsdmt][3045948304]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=grape1DBG_CRSD))
  15. 2012-05-28 18:55:29.432: [  clsdmt][3045948304]PID for the Process [4422], connkey 1
  16. 2012-05-28 18:55:29.432: [  clsdmt][3045948304]Creating PID [4422] file for home /u01/app/11.2.0/grid host grape1 bin crs to /u01/app/11.2.0/grid/crs/init/
  17. 2012-05-28 18:55:29.432: [  clsdmt][3045948304]Writing PID [4422] to the file [/u01/app/11.2.0/grid/crs/init/grape1.pid]
  18. 2012-05-28 18:55:30.240: [ default][3046242000] CRS Daemon Starting
  19. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: AGENT  1
  20. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: AGFW  0
  21. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CLSFRAME  0
  22. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CLSVER  0
  23. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CLUCLS  0
  24. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: COMMCRS  0
  25. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: COMMNS  0
  26. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CRSAPP  0
  27. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CRSCCL  0
  28. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CRSCEVT  0
  29. 2012-05-28 18:55:30.241: [ default][3046242000] ENV Logging level for Module: CRSCOMM  0
  30. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSD  0
  31. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSEVT  0
  32. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSMAIN  0
  33. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSOCR  0
  34. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSPE  0
  35. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSPLACE  0
  36. 2012-05-28 18:55:30.241: [    CRSD][3046242000] ENV Logging level for Module: CRSRES  0
  37. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSRPT  0
  38. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSRTI  0
  39. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSSE  0
  40. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSSEC  0
  41. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSTIMER  0
  42. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CRSUI  0
  43. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: CSSCLNT  0
  44. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRAPI  1
  45. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRASM  1
  46. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRCAC  1
  47. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRCLI  1
  48. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRMAS  1
  49. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRMSG  1
  50. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCROSD  1
  51. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRRAW  1
  52. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRSRV  1
  53. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: OCRUTL  1
  54. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: SuiteTes  1
  55. 2012-05-28 18:55:30.242: [    CRSD][3046242000] ENV Logging level for Module: UiServer  0
  56. 2012-05-28 18:55:30.242: [ CRSMAIN][3046242000] Checking the OCR device
  57. 2012-05-28 18:55:30.243: [ CRSMAIN][3046242000] Connecting to the CSS Daemon
  58. 2012-05-28 18:55:30.253: [ CRSMAIN][3046242000] Initializing OCR
  59. 2012-05-28 18:55:30.254: [  OCRAPI][3046242000]clsu_get_private_ip_addr: Calling clsu_get_private_ip_addresses to get first private ip
  60. 2012-05-28 18:55:30.254: [  OCRAPI][3046242000]Check namebufs
  61. 2012-05-28 18:55:30.254: [  OCRAPI][3046242000]Finished checking namebufs
  62. 2012-05-28 18:55:30.255: [    GIPC][3046242000] gipcCheckInitialization: possible incompatible non-threaded init from [clsinet.c : 3229], original from [clsss.c : 5011]
  63. 2012-05-28 18:55:30.256: [    GPnP][3046242000]clsgpnp_Init: [at clsgpnp0.c:404] gpnp tracelevel 3, component tracelevel 0
  64. 2012-05-28 18:55:30.256: [    GPnP][3046242000]clsgpnp_Init: [at clsgpnp0.c:534] '/u01/app/11.2.0/grid' in effect as GPnP home base.
  65. 2012-05-28 18:55:30.264: [    GIPC][3046242000] gipcCheckInitialization: possible incompatible non-threaded init from [clsgpnp0.c : 680], original from [clsss.c : 5011]
  66. 2012-05-28 18:55:30.266: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3866] Init gpnp local security key providers (2) fatal if both fail
  67. 2012-05-28 18:55:30.267: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3869] Init gpnp local security key proveders 1 of 2: file wallet (LSKP-FSW)
  68. 2012-05-28 18:55:30.267: [    GPnP][3046242000]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:398] Using FS Wallet Location : /u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/

  69. 2012-05-28 18:55:30.267: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3891] Init gpnp local security key provider 1 of 2: file wallet (LSKP-FSW) OK
  70. 2012-05-28 18:55:30.267: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3897] Init gpnp local security key proveders 2 of 2: OLR wallet (LSKP-CLSW-OLR)
  71. [   CLWAL][3046242000]clsw_Initialize: OLR initlevel [30000]
  72. 2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnp_InitCKProviders: [at clsgpnp0.c:3919] Init gpnp local security key provider 2 of 2: OLR wallet (LSKP-CLSW-OLR) OK
  73. 2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1950] <Get gpnp security keys (wallet) for id:1,typ;7. (2 providers - fatal if all fail)
  74. 2012-05-28 18:55:30.271: [    GPnP][3046242000]clsgpnpkwf_getWalletPath: [at clsgpnpkwf.c:498] req_id=1 ck_prov_id=1 wallet path: /u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/
  75. 2012-05-28 18:55:30.284: [    GPnP][3046242000]clsgpnpwu_walletfopen: [at clsgpnpwu.c:494] Opened SSO wallet: '/u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/cwallet.sso'
  76. 2012-05-28 18:55:30.284: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1965] Result: (0) CLSGPNP_OK. Get gpnp wallet - provider 1 of 2 (LSKP-FSW(1))
  77. 2012-05-28 18:55:30.285: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1982] Got gpnp security keys (wallet).>
  78. 2012-05-28 18:55:30.288: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1950] <Get gpnp security keys (wallet) for id:1,typ;4. (2 providers - fatal if all fail)
  79. 2012-05-28 18:55:30.288: [    GPnP][3046242000]clsgpnpkwf_getWalletPath: [at clsgpnpkwf.c:498] req_id=1 ck_prov_id=1 wallet path: /u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/
  80. 2012-05-28 18:55:30.299: [    GPnP][3046242000]clsgpnpwu_walletfopen: [at clsgpnpwu.c:494] Opened SSO wallet: '/u01/app/11.2.0/grid/gpnp/grape1/wallets/peer/cwallet.sso'
  81. 2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1965] Result: (0) CLSGPNP_OK. Get gpnp wallet - provider 1 of 2 (LSKP-FSW(1))
  82. 2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_getCK: [at clsgpnp0.c:1982] Got gpnp security keys (wallet).>
  83. 2012-05-28 18:55:30.300: [    GPnP][3046242000]clsgpnp_Init: [at clsgpnp0.c:837] GPnP client pid=4422, tl=3, f=0
  84. 2012-05-28 18:55:30.324: [GIPCXCPT][3046242000] gipcShutdownF: skipping shutdown, count 2, from [ clsinet.c : 1732], ret gipcretSuccess (0)
  85. 2012-05-28 18:55:30.325: [GIPCXCPT][3046242000] gipcShutdownF: skipping shutdown, count 1, from [ clsgpnp0.c : 1021], ret gipcretSuccess (0)
  86. 2012-05-28 18:55:30.338: [  OCRASM][3046242000]proprasmo: Error in open/create file in dg [OCR_VOTE]
  87. [  OCRASM][3046242000]SLOS : SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
  88. ORA-15077: could not locate ASM instance serving a required diskgroup

  89. 2012-05-28 18:55:30.339: [  OCRASM][3046242000]proprasmo: kgfoCheckMount returned [7]
  90. 2012-05-28 18:55:30.339: [  OCRASM][3046242000]proprasmo: The ASM instance is down
  91. 2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprioo: Failed to open [+OCR_VOTE]. Returned proprasmo() with [26]. Marking location as UNAVAILABLE.
  92. 2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprioo: No OCR/OLR devices are usable
  93. 2012-05-28 18:55:30.340: [  OCRASM][3046242000]proprasmcl: asmhandle is NULL
  94. 2012-05-28 18:55:30.340: [  OCRRAW][3046242000]proprinit: Could not open raw device
  95. 2012-05-28 18:55:30.340: [  OCRASM][3046242000]proprasmcl: asmhandle is NULL
  96. 2012-05-28 18:55:30.340: [  OCRAPI][3046242000]a_init:16!: Backend init unsuccessful : [26]
  97. 2012-05-28 18:55:30.341: [  CRSOCR][3046242000] OCR context init failure.  Error: PROC-26: Error while accessing the physical storage ASM error [SLOS: cat=7, opn=kgfoAl06, dep=15077, loc=kgfokge
  98. ORA-15077: could not locate ASM instance serving a required diskgroup
  99. ] [7]
  100. 2012-05-28 18:55:30.341: [    CRSD][3046242000][PANIC] CRSD exiting: Could not init OCR, code: 26
  101. 2012-05-28 18:55:30.341: [    CRSD][3046242000] Done.
复制代码
ODM DATA:
proprinit: Could not open raw device


可以确认是因为raw device 存在问题 导致 ocr 和 votedisk 无法访问, 建议你检查 ASM DISK LUN是否存在问题。


压缩后上传 cssd.log 可以获得更多信息

回复 只看该作者 道具 举报

6#
发表于 2012-5-29 17:14:52
是的,感谢maclean
raw dev配置权限有问题

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-11-15 20:09 , Processed in 0.061502 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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