首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Sybase >

sybase双机热备切机后数据库设备无法加载,该怎么解决

2012-02-24 
sybase双机热备切机后数据库设备无法加载,急!各位大牛,请帮帮小弟吧,都快急死了!非常感谢!我们有两台sun服

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.


00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'sysprocsdev'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 1, '/disk/sybsystem/systemproc.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2010/01/24 18:25:51.60 server Activating disk 'tmpdata'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Initializing virtual device 4, '/disk/sybsystem/tmpdata.dat' with dsync 'on'.
00:00000:00001:2010/01/24 18:25:51.60 kernel Virtual device 4 started using asynchronous i/o.
00:00000:00001:2010/01/24 18:25:51.83 server Recovering database 'sybsystemdb'.
00:00000:00001:2010/01/24 18:25:51.84 server Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2010/01/24 18:25:52.08 server Boot Count: 141
00:00000:00001:2010/01/24 18:25:52.17 server Checking external objects.
00:00000:00001:2010/01/24 18:25:52.18 server The transaction log in the database 'sybsystemdb' will use I/O size of 4 Kb.
00:00000:00001:2010/01/24 18:25:52.29 server Database 'sybsystemdb' is now online.
00:00000:00001:2010/01/24 18:25:52.36 server Recovering database 'model'.
00:00000:00001:2010/01/24 18:25:52.61 server Checking external objects.
00:00000:00001:2010/01/24 18:25:52.61 server The transaction log in the database 'model' will use I/O size of 4 Kb.
00:00000:00001:2010/01/24 18:25:52.76 server Database 'model' is now online.
00:00000:00001:2010/01/24 18:25:52.76 server The logical pagesize of the server is 2 Kb.
00:00000:00001:2010/01/24 18:25:52.76 server 0 dump conditions detected at boot time
00:00000:00001:2010/01/24 18:25:52.78 server Resident Node id: a9d3a8702b82
00:00000:00001:2010/01/24 18:25:52.78 server Transaction coordinator initialized.
00:00000:00001:2010/01/24 18:25:52.79 server Clearing temp db 
00:00000:00001:2010/01/24 18:26:47.17 server The transaction log in the database 'tempdb' will use I/O size of 4 Kb.
00:00000:00001:2010/01/24 18:26:47.29 server Database 'tempdb' is now online.
00:00000:00001:2010/01/24 18:26:47.35 server Recovering database 'sybsystemprocs'.
00:00000:00001:2010/01/24 18:26:47.39 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2010/01/24 18:26:48.35 server Checking external objects.
00:00000:00001:2010/01/24 18:26:48.36 server The transaction log in the database 'sybsystemprocs' will use I/O size of 4 Kb.
00:00000:00001:2010/01/24 18:26:48.49 server Database 'sybsystemprocs' is now online. 
00:00000:00002:2010/01/24 18:26:48.52 kernel network name cluster, type ether, port 4100, filter NONE
00:00000:00003:2010/01/24 18:26:48.53 kernel network name scadab, type ether, port 4100, filter NONE
00:00000:00004:2010/01/24 18:26:48.53 kernel network name clustera, type ether, port 4100, filter NONE
00:00000:00001:2010/01/24 18:26:48.62 server Recovering database 'scbjdb'.
00:00000:00001:2010/01/24 18:26:48.65 server Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2010/01/24 18:26:49.45 server Checking external objects.
00:00000:00001:2010/01/24 18:26:49.45 server The transaction log in the database 'scbjdb' will use I/O size of 4 Kb.
00:00000:00001:2010/01/24 18:26:49.57 server Database 'scbjdb' is now online.
00:00000:00001:2010/01/24 18:26:49.65 server Recovering database 'scbjhdb'.
00:00000:00001:2010/01/24 18:26:49.65 server Error: 840, Severity: 17, State: 2
00:00000:00001:2010/01/24 18:26:49.65 server Device 'data47' (with physical name '/disk/sybsystem/data47.dat', and virtual device number 47) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
00:00000:00001:2010/01/24 18:26:49.65 server Error: 3414, Severity: 17, State: 3
00:00000:00001:2010/01/24 18:26:49.65 server Database 'scbjhdb' (dbid 5): Recovery failed. Check the SQL Server errorlog for further information as to the cause.


00:00000:00001:2010/01/24 18:26:49.66 server Recovery complete.
00:00000:00001:2010/01/24 18:26:49.66 server SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2010/01/24 18:26:49.66 server SQL Server's default sort order is:
00:00000:00001:2010/01/24 18:26:49.66 server 'bin_eucgb' (ID = 50)
00:00000:00001:2010/01/24 18:26:49.66 server on top of default character set:
00:00000:00001:2010/01/24 18:26:49.66 server 'eucgb' (ID = 170).
00:00000:00001:2010/01/24 18:26:49.66 server Master device size: 200 megabytes, or 102400 virtual pages. (A virtual page is 2048 bytes.)

[解决办法]
Permission denied

查看sybase用户对设备文件的权限???

热点排行