2,596
社区成员
发帖
与我相关
我的任务
分享数据库恢复后出现的奇怪问题？急急急！！
我有数据库文件恢复后，刚开始打开数据库都可以，但是后来不知道怎么回事，打开Sybase Cebtral->数据库->hengda(数据库名)出现如下错误：
“数据库hengda被创建用于装载或者状态可以。他不能被打开。”
“数据库hengda被创建用于装载或者状态可以。他不能被打开。”
...全文
请发表友善的回复…
发表回复
n_tianya 2004-04-16
- 打赏
- 举报
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
主要看这段错误信息哈，设备加载错误，可能是设备文件损坏，也可能是操作系统的问题
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
主要看这段错误信息哈，设备加载错误，可能是设备文件损坏，也可能是操作系统的问题
n_tianya 2004-04-16
- 打赏
- 举报
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
主要看这段错误信息哈，设备加载错误，可能是设备文件损坏，也可能是操作系统的问题
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
主要看这段错误信息哈，设备加载错误，可能是设备文件损坏，也可能是操作系统的问题
oldxu 2004-04-15
- 打赏
- 举报
我碰到过这样的问题。你的数据库开始是怎么建起来的？
kevin218 2004-04-15
- 打赏
- 举报
进一步关注中
damangren 2004-04-10
- 打赏
- 举报
其他的数据库都正常启动了，那么你那个数据库因为某些原因无法由sql服务装载进系统，可能是操作系统给sybase服务提供的资源不足。
你load完hengda数据库后，是否使用过，还是一直都不好用？
你load完hengda数据库后，是否使用过，还是一直都不好用？
zhbvictor 2004-04-07
- 打赏
- 举报
已给你发消息了
USA110 2004-04-07
- 打赏
- 举报
错误errorlog文件部分内容如下：
00:00000:00000:2004/04/07 15:16:53.65 kernel *** WARNING ******************
00:00000:00000:2004/04/07 15:16:53.65 kernel Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2004/04/07 15:16:53.65 kernel SQL Server NT process id is 0x308.
00:00000:00000:2004/04/07 15:16:53.65 kernel SQL Server was started as a Service.
00:00000:00000:2004/04/07 15:16:53.67 kernel Network and device connection limit is 99992.
00:00000:00000:2004/04/07 15:16:53.81 server Number of proc buffers allocated: 3086.
00:00000:00000:2004/04/07 15:16:53.93 server Number of blocks left for proc headers: 3048.
00:00000:00000:2004/04/07 15:16:53.98 server Proc header memory allocated 1524 pages for each per engine cache
00:00000:00000:2004/04/07 15:16:53.98 server Memory allocated for the default data cache cachelet 1: 23188 Kb
00:00000:00000:2004/04/07 15:16:53.98 server Size of the 2K memory pool: 23188 Kb
00:00000:00000:2004/04/07 15:16:54.04 kernel Initializing virtual device 0, 'd:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2004/04/07 15:16:54.06 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/04/07 15:16:54.06 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/04/07 15:16:54.06 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2004/04/07 15:16:54.18 kernel engine 0, os pid 248 online
00:00000:00000:2004/04/07 15:16:54.26 server No active traceflags
00:00000:00001:2004/04/07 15:16:54.53 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2004/04/07 15:16:54.53 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2004/04/07 15:16:54.65 server Opening Master Database ...
00:00000:00001:2004/04/07 15:16:55.20 server Loading SQL Server's default sort order and character set
00:00000:00001:2004/04/07 15:16:55.20 server Loaded default Unilib conversion handle.
00:00000:00002:2004/04/07 15:16:55.23 kernel network name dbserver, type ether, port 5000
00:00000:00001:2004/04/07 15:16:55.34 server Recovering database 'master'
00:00000:00001:2004/04/07 15:16:55.62 server Redo pass of recovery has processed 11 committed and 6 aborted transactions.
00:00000:00001:2004/04/07 15:16:56.25 server Checking external objects.
00:00000:00001:2004/04/07 15:16:56.53 server Database 'master' is now online.
00:00000:00001:2004/04/07 15:16:56.54 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:56.56 server This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2004/04/07 15:16:56.60 server 0 dump conditions detected at boot time
00:00000:00001:2004/04/07 15:16:56.65 server server is unnamed
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda_add'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 4, 'D:\sybase\data\hengda_add.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Virtual device 4 started using asynchronous i/o.
00:00000:00001:2004/04/07 15:16:56.76 server Activating disk 'hengda_log'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Initializing virtual device 3, '\\Dbserver\D\sybase\data\hengda_log.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.76 kernel dopen: open '\\Dbserver\D\sybase\data\hengda_log.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.76 kernel udactivate: error starting virtual disk 3
00:00000:00001:2004/04/07 15:16:56.76 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Initializing virtual device 1, 'd:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.82 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/04/07 15:16:57.06 server Recovering database 'sybsystemdb'.
00:00000:00001:2004/04/07 15:16:57.10 server Boot Count: 19
00:00000:00001:2004/04/07 15:16:57.18 server Checking external objects.
00:00000:00001:2004/04/07 15:16:57.20 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:57.23 server Database 'sybsystemdb' is now online.
00:00000:00001:2004/04/07 15:16:57.29 server Recovering database 'model'.
00:00000:00001:2004/04/07 15:16:57.35 server Checking external objects.
00:00000:00001:2004/04/07 15:16:57.37 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:57.39 server Database 'model' is now online.
00:00000:00001:2004/04/07 15:16:57.39 server Resident Node id: cf409d89d138
00:00000:00001:2004/04/07 15:16:57.40 server Transaction coordinator initialized.
00:00000:00001:2004/04/07 15:16:57.42 server Clearing temp db
00:00000:00001:2004/04/07 15:17:03.70 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.18 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.20 server Database 'tempdb' is now online.
00:00000:00001:2004/04/07 15:17:04.21 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.42 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/04/07 15:17:09.87 server Checking external objects.
00:00000:00001:2004/04/07 15:17:09.95 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:10.04 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/04/07 15:17:10.06 server Error: 926, Severity: 14, State: 1
00:00000:00001:2004/04/07 15:17:10.06 server Database 'hengda' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2004/04/07 15:17:10.09 server Unable to proceed with the recovery of dbid <4> because of previous errors. Continuing with the next database.
00:00000:00001:2004/04/07 15:17:10.09 server Recovery complete.
00:00000:00001:2004/04/07 15:17:10.09 server SQL Server's default sort order is:
00:00000:00001:2004/04/07 15:17:10.09 server 'bin_cp850' (ID = 50)
00:00000:00001:2004/04/07 15:17:10.09 server on top of default character set:
00:00000:00001:2004/04/07 15:17:10.09 server 'cp850' (ID = 2).
请高人赐教！！！
00:00000:00000:2004/04/07 15:16:53.65 kernel *** WARNING ******************
00:00000:00000:2004/04/07 15:16:53.65 kernel Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2004/04/07 15:16:53.65 kernel SQL Server NT process id is 0x308.
00:00000:00000:2004/04/07 15:16:53.65 kernel SQL Server was started as a Service.
00:00000:00000:2004/04/07 15:16:53.67 kernel Network and device connection limit is 99992.
00:00000:00000:2004/04/07 15:16:53.81 server Number of proc buffers allocated: 3086.
00:00000:00000:2004/04/07 15:16:53.93 server Number of blocks left for proc headers: 3048.
00:00000:00000:2004/04/07 15:16:53.98 server Proc header memory allocated 1524 pages for each per engine cache
00:00000:00000:2004/04/07 15:16:53.98 server Memory allocated for the default data cache cachelet 1: 23188 Kb
00:00000:00000:2004/04/07 15:16:53.98 server Size of the 2K memory pool: 23188 Kb
00:00000:00000:2004/04/07 15:16:54.04 kernel Initializing virtual device 0, 'd:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2004/04/07 15:16:54.06 kernel Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/04/07 15:16:54.06 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/04/07 15:16:54.06 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2004/04/07 15:16:54.18 kernel engine 0, os pid 248 online
00:00000:00000:2004/04/07 15:16:54.26 server No active traceflags
00:00000:00001:2004/04/07 15:16:54.53 kernel Component Integration Services loaded; version 'Component Integration Services/12.0/P/SWR 8776 ESD 1/NT (IX86)/OS 4.0/1580/32bit/OPT/Mon Dec 06 20:31:23 1999'.
00:00000:00001:2004/04/07 15:16:54.53 kernel Component Integration Services: using 'Sybase Client-Library/12.0/P/PC Intel/1/OPT/Mon Oct 04 15:42:12 1999'
00:00000:00001:2004/04/07 15:16:54.65 server Opening Master Database ...
00:00000:00001:2004/04/07 15:16:55.20 server Loading SQL Server's default sort order and character set
00:00000:00001:2004/04/07 15:16:55.20 server Loaded default Unilib conversion handle.
00:00000:00002:2004/04/07 15:16:55.23 kernel network name dbserver, type ether, port 5000
00:00000:00001:2004/04/07 15:16:55.34 server Recovering database 'master'
00:00000:00001:2004/04/07 15:16:55.62 server Redo pass of recovery has processed 11 committed and 6 aborted transactions.
00:00000:00001:2004/04/07 15:16:56.25 server Checking external objects.
00:00000:00001:2004/04/07 15:16:56.53 server Database 'master' is now online.
00:00000:00001:2004/04/07 15:16:56.54 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:56.56 server This installation was created using a 12.0 or later version of bldmastr.
00:00000:00001:2004/04/07 15:16:56.60 server 0 dump conditions detected at boot time
00:00000:00001:2004/04/07 15:16:56.65 server server is unnamed
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 2, '\\Dbserver\D\sybase\data\hengda.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.75 kernel dopen: open '\\Dbserver\D\sybase\data\hengda.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.75 kernel udactivate: error starting virtual disk 2
00:00000:00001:2004/04/07 15:16:56.75 server Activating disk 'hengda_add'.
00:00000:00001:2004/04/07 15:16:56.75 kernel Initializing virtual device 4, 'D:\sybase\data\hengda_add.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Virtual device 4 started using asynchronous i/o.
00:00000:00001:2004/04/07 15:16:56.76 server Activating disk 'hengda_log'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Initializing virtual device 3, '\\Dbserver\D\sybase\data\hengda_log.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.76 kernel dopen: open '\\Dbserver\D\sybase\data\hengda_log.dat', Windows NT system error 67: Unforseen error.
00:00000:00001:2004/04/07 15:16:56.76 kernel udactivate: error starting virtual disk 3
00:00000:00001:2004/04/07 15:16:56.76 server Activating disk 'sysprocsdev'.
00:00000:00001:2004/04/07 15:16:56.76 kernel Initializing virtual device 1, 'd:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2004/04/07 15:16:56.82 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/04/07 15:16:57.06 server Recovering database 'sybsystemdb'.
00:00000:00001:2004/04/07 15:16:57.10 server Boot Count: 19
00:00000:00001:2004/04/07 15:16:57.18 server Checking external objects.
00:00000:00001:2004/04/07 15:16:57.20 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:57.23 server Database 'sybsystemdb' is now online.
00:00000:00001:2004/04/07 15:16:57.29 server Recovering database 'model'.
00:00000:00001:2004/04/07 15:16:57.35 server Checking external objects.
00:00000:00001:2004/04/07 15:16:57.37 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:16:57.39 server Database 'model' is now online.
00:00000:00001:2004/04/07 15:16:57.39 server Resident Node id: cf409d89d138
00:00000:00001:2004/04/07 15:16:57.40 server Transaction coordinator initialized.
00:00000:00001:2004/04/07 15:16:57.42 server Clearing temp db
00:00000:00001:2004/04/07 15:17:03.70 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.18 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.20 server Database 'tempdb' is now online.
00:00000:00001:2004/04/07 15:17:04.21 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:04.42 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/04/07 15:17:09.87 server Checking external objects.
00:00000:00001:2004/04/07 15:17:09.95 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/04/07 15:17:10.04 server Database 'sybsystemprocs' is now online.
00:00000:00001:2004/04/07 15:17:10.06 server Error: 926, Severity: 14, State: 1
00:00000:00001:2004/04/07 15:17:10.06 server Database 'hengda' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2004/04/07 15:17:10.09 server Unable to proceed with the recovery of dbid <4> because of previous errors. Continuing with the next database.
00:00000:00001:2004/04/07 15:17:10.09 server Recovery complete.
00:00000:00001:2004/04/07 15:17:10.09 server SQL Server's default sort order is:
00:00000:00001:2004/04/07 15:17:10.09 server 'bin_cp850' (ID = 50)
00:00000:00001:2004/04/07 15:17:10.09 server on top of default character set:
00:00000:00001:2004/04/07 15:17:10.09 server 'cp850' (ID = 2).
请高人赐教！！！
