sybase双机热备切机后数据库设备无法加载,该怎么解决
发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
sybase双机热备切机后数据库设备无法加载,急!
各位大牛,请帮帮小弟吧,都快急死了!非常感谢!
我们有两台sun服务器a和b,共用一个磁盘阵列,sybase ASE12.5。以前磁盘阵列挂在a上,由于cpu风扇有问题,停了a机(在关机过程中忘了关数据库),数据库自动cluster到b机后几个设备无法初始化,报sybase 840错误。
我是初学者,照着网上的资料查了一下,现在数据库的情况如下:
1.重新把磁盘阵列挂到a机上数据库仍能正常运行
2.我们的所有库文件都在磁盘阵列上(master也在)
3.以前在a机上对数据库进行扩容,但好像b机的.cfg文件也相应修改过
4.其中出问题的scbjhdb库的status为64
5.在sysdevices中出问题的设备都能看到
6.曾在b机上用 fsck -y 检查磁盘阵列文件,但由于时间不够,最后修复中断了
敬请各位大牛给我看看,有啥好办法没有。
b机sybase日志另帖
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data47'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 47, '/disk/sybsystem/data47.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data47.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 47
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data48'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 48, '/disk/sybsystem/data48.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data48.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 48
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data49'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 49, '/disk/sybsystem/data49.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data49.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 49
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data50'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 50, '/disk/sybsystem/data50.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data50.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 50
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data51'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 51, '/disk/sybsystem/data51.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data51.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 51
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data52'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 52, '/disk/sybsystem/data52.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data52.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 52
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data53'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 53, '/disk/sybsystem/data53.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data53.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 53
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'data54'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 54, '/disk/sybsystem/data54.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel dopen: open '/disk/sybsystem/data54.dat', Permission denied
00:00000:00001:2010/01/24 18:25:51.60 kernel udactivate: error starting virtual disk 54
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'pdrdata'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 9, '/disk/sybsystem/pdrdata.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Virtual device 9 started using asynchronous i/o.
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。
其他相似内容:
-
unix 下操作sybase 问题.各位大虾不吝赐教
在hp-ux下通过shell连接数据库.
通过一个查询语句如下:
select count(*) ct from t1
un...
-
询问关于sybase advantage的字体对齐问题。
Windows 下的 Sybase SQL Advantage
文件版本 11.5.1.3
在返回信息窗口,只有宋体字...
-
数据导入问题
linux 下将每天将最新生成的文件导入到sybase anywhere 11数据库
如何实现????
------解决方案--------------------
...
-
Sybase [ASE]版发贴提问的智慧和技巧
发贴时,标题包含数据库名称操作系统以及相应版本号,
e.g. Windows XP下ASE15.0.3安装出错
...
-
求sybase15for x86
那位大侠有给传一个
------解决方案--------------------
正传给你QQ.......
-
请问sysbase中 sp_extendsegment 和 alterbase 有什么不同?
我知道sp_extendsegment 是将某个段扩到设备上,但是alterdabse不也有这...
-
求帮忙将一个sybase里的数据导入sqlite和SqlServer
有一个很老的管理系统好像是用pb+sybase asa7 做的,目前仍在用,
现在要升级新的...
-
有没有电话面试时候数据库的面试题目可以参考的啊?
有没有电话面试时候数据库的面试题目可以参考的啊?
------解决方案---------...
-
sybase master服务启动时发生段错误怎么办?
下面是errlog:
Directory is not a suitable Sybase directory.
Building Adaptiv...
-
sybase的int型数字时间,如何转换?
sybase有一字段存储的是时间,但为INT型,如值为1265856544,即2010-02-11 10:49:04
在SYBASE的SQL中,...