96 积分	0 好友	4 主题

发消息

[物理/逻辑坏块] 启动报 ERROR: failed to establish dependency

1^#

发表于 2013-3-14 15:13:59 | 查看: 5537| 回复: 5

os：redhat 6.3 x64
db: 11.2.0.3.5 x64 单节点

数据库后台日志报
NOTE: MARK has subscribed
Thu Mar 14 15:09:09 2013
NOTE: Loaded library: System
Thu Mar 14 15:09:09 2013
SUCCESS: diskgroup DATADG was mounted
Thu Mar 14 15:09:09 2013
ERROR: failed to establish dependency between database logdg and diskgroup resource ora.DATADG.dg
Thu Mar 14 15:09:14 2013
SUCCESS: diskgroup DATADG was dismounted

也没有trace 文件等。就这样的一条信息。
问这个ERROR是什么原因造成的。谢谢

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-3-14 15:20:51

SUCCESS: diskgroup DATADG was dismounted

明显datadg没mount

crsctl stat res -t

su - grid
sqlplus / as sysasm

alter diskgroup datadg mount ;

show parameter backgroud

把ASM的alert.log上传

回复只看该作者道具举报

seedog123

3^#

发表于 2013-3-14 22:11:01

Maclean Liu(刘相兵发表于 2013-3-14 15:20
SUCCESS: diskgroup DATADG was dismounted

明显datadg没mount

disgroup 肯定是mount的

--------------------------------------------------------------------------------
NAME          TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
            ONLINE  ONLINE    logdg
ora.LISTENER.lsnr
            ONLINE  ONLINE    logdg
ora.asm
            ONLINE  ONLINE    logdg                Started
ora.ons
            ONLINE  ONLINE    logdg
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
   1       ONLINE  ONLINE    logdg
ora.diskmon
   1       OFFLINE OFFLINE
ora.evmd
   1       ONLINE  ONLINE    logdg
ora.log.db
   1       ONLINE  ONLINE    logdg                Open,Readonly

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2013-3-14 22:31:29

请严格follow 上面的 action plan

回复只看该作者道具举报

seedog123

5^#

发表于 2013-3-14 22:45:09

本帖最后由 seedog123 于 2013-3-15 10:38 编辑

Maclean Liu(刘相兵发表于 2013-3-14 22:31
请严格follow 上面的 action plan

--------------------------------------------------------------------------------
NAME          TARGET  STATE       SERVER                STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
            ONLINE  ONLINE    logdg
ora.LISTENER.lsnr
            ONLINE  ONLINE    logdg
ora.asm
            ONLINE  ONLINE    logdg                Started
ora.ons
            ONLINE  ONLINE    logdg
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
   1       ONLINE  ONLINE    logdg
ora.diskmon
   1       OFFLINE OFFLINE
ora.evmd
   1       ONLINE  ONLINE    logdg
ora.log.db
   1       ONLINE  ONLINE    logdg                Open,Readonly

SQL>  alter diskgroup datadg mount;
alter diskgroup datadg mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATADG" cannot be mounted
ORA-15013: diskgroup "DATADG" is already mounted

SQL>  show parameter backgroud
SQL>

后台日志报
SQL>  alter diskgroup datadg mount
WARNING: Disk Group DATADG containing spfile for this instance is not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATADG" cannot be mounted
ORA-15013: diskgroup "DATADG" is already mounted
ERROR:  alter diskgroup datadg mount

asm.zip

8.43 KB, 下载次数: 1136

回复只看该作者道具举报

低调小马哥

6^#

发表于 2013-3-15 13:48:11

10g的rac好像是有个小bug的，db的alert日子里经常有这样的报错，归档日志一段时间不写，dg一空闲就umount了，一写往磁盘组里写日志就mount，11g好像没这个问题了，最好在mos里看看是不是什么bug

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册