需要急救！！！前辈们帮忙看看！！！

NoGame

打开数据库报错

Msg 921, Level 14, State 1:
Line1:
Database 'DName' has not been revovered yet - Please wait and try again

无法打开数据库！！！

请指点！！！


Errorlog 记录

00:00000:00001:2004/03/12 08:33:49.45 server Database 'tempdb' is now online.
00:00000:00001:2004/03/12 08:33:49.84 server Recovering database 'sybsystemprocs'.
00:00000:00001:2004/03/12 08:33:50.06 server Checking external objects.
00:00000:00001:2004/03/12 08:33:50.08 server The transaction log in the database

'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 08:33:50.16 server Database 'sybsystemprocs' is now online.
00:00000:00002:2004/03/12 08:33:50.20 kernel network name 192.168.70.2, type ether, port

5000, filter NONE
00:00000:00001:2004/03/12 08:33:50.75 server Recovering database 'dbname'.
00:00000:00001:2004/03/12 08:33:56.48 server Redo pass: 6000 records done (16%); 30698

records left.
00:00000:00001:2004/03/12 08:33:56.66 server Redo pass: 12000 records done (32%); 24698

records left.
00:00000:00001:2004/03/12 08:33:57.03 server Redo pass: 18000 records done (49%); 18698

records left.
00:00000:00001:2004/03/12 08:33:57.23 server Redo pass: 24000 records done (65%); 12698

records left.
00:00000:00001:2004/03/12 08:33:57.44 server Redo pass: 30000 records done (81%); 6698

records left.
00:00000:00001:2004/03/12 08:33:57.69 server Redo pass: 36000 records done (98%); 698

records left.
00:00000:00001:2004/03/12 08:33:57.81 server Error: 3474, Severity: 21, State: 1
00:00000:00001:2004/03/12 08:33:57.81 server During redo the page timestamp value is less

than old timestamp from log. Page #=3167, object id = 23, page timestamp=0000 03491be0. Log

old timestamp=0000 034bf28f.
00:00000:00001:2004/03/12 08:33:57.82 server Error: 3414, Severity: 21, State: 1
00:00000:00001:2004/03/12 08:33:57.82 server Database 'dbname' (dbid 4): Recovery failed.

Check the SQL Server errorlog for further information as to the cause.
00:00000:00001:2004/03/12 08:33:57.82 server Recovery complete.
00:00000:00001:2004/03/12 08:33:57.82 server SQL Server's default unicode sort order is

'binary'.
00:00000:00001:2004/03/12 08:33:57.82 server SQL Server's default sort order is:
00:00000:00001:2004/03/12 08:33:57.82 server 'altnoacc_cp850' (ID = 39)
00:00000:00001:2004/03/12 08:33:57.82 server on top of default character set:
00:00000:00001:2004/03/12 08:33:57.82 server 'cp850' (ID = 2).
00:00000:00001:2004/03/12 08:33:57.82 server Master device size: 30 megabytes, or 15360

virtual pages. (A virtual page is 2048 bytes.)


服务能正常启动，但数据库无法启动！

RS9000

你的数据库没有恢复成功
1、旁路掉恢复
2、备份数据库，（BCP）
3、DUMP TRAN清除日志
4、重新启动SERVER
5、DBCC检查数据库
如果有问题重新倒入数据
***不知道是否有风险，因为我也没做过***

NoGame

我是新手，请问如何旁路恢复？

heulw

两种情况：一是数据库还没有完全启动，你过一会儿试；而是数据库由于其他问题变成了suspect状态，你看一下是否是sunspect状态，如果是，从论坛查一下恢复的方法

ywtmh

是不是数据库在前面就出现了问题，而你没有注意啊！先查一下前面的错误日志吧！！

NoGame

我都试过了，不行

我看到人说过有一种单用户模式，请问那怎么进？

solofeng

这情况怎么备份数据，数据库都没有起来

RS9000

把数据库状态设成-32768，启动服务，看数据库能起来不，如果起来了，备份数据

ywtmh

可以用BCP备份的

NoGame

我试过把数据库状态设成-32768，启动服务，看数据库能起来不，如果起来了，备份数据的，不行，设为0也不行，BCP报错如下：

Server Message: -Msg 921, Level 14, State1:
Database 'dbnamd' has not been recovered yet - Please wait and try again.

Server Message:  - Msg 208, Level 16, State 1:
ndydxt..yhzqk not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Unexpected result type returned.
Regrieving table format failed.




sp_helpdb结果如下：
name                     db_size       owner                    dbid
         created
         status

------------------------ ------------- ------------------------ ------
         --------------
         -----------------------------------------------------------------------
-------------------------------
dbname                      7168.0 MB sa                            4
         Dec 30, 2003
         not recovered, offline


(1 row affected)
device_fragments               size          usage
         created             free kbytes
------------------------------ ------------- --------------------
         ------------------- ------------------------------
dbname_data                      5120.0 MB     data only
         Dec 30 2003  3:56PM          4521304
dbname_log                       2048.0 MB     log only
         Dec 30 2003  3:56PM not applicable

--------------------------------------------------------------
log only free kbytes = 2089006
(return status = 0)



部分日志如下：
00:00000:00000:2004/03/12 11:10:17.14 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2004/03/12 11:10:17.14 kernel  Using config area from primary master device.
00:00000:00000:2004/03/12 11:10:17.15 kernel  Warning: Using default file 'C:\Sybase\ICNDNDYDXTSVR.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2004/03/12 11:10:17.25 kernel  Using 100000 file descriptors.
00:00000:00000:2004/03/12 11:10:17.26 kernel  Adaptive Server Enterprise/12.5/SWR 9616 GA/P/NT (IX86)/OS 4.0/main/1647/32-bit/OPT/Fri Jun 01 16:58:25 2001
00:00000:00000:2004/03/12 11:10:17.26 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2004/03/12 11:10:17.26 kernel  Copyright 1987, 2001
00:00000:00000:2004/03/12 11:10:17.26 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2004/03/12 11:10:17.26 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2004/03/12 11:10:17.26 kernel  
00:00000:00000:2004/03/12 11:10:17.26 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2004/03/12 11:10:17.26 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2004/03/12 11:10:17.26 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2004/03/12 11:10:17.26 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2004/03/12 11:10:17.26 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2004/03/12 11:10:17.26 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2004/03/12 11:10:17.26 kernel  Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2004/03/12 11:10:17.26 kernel  Using 'C:\Sybase\ICNDNDYDXTSVR.cfg' for configuration information.
00:00000:00000:2004/03/12 11:10:17.26 kernel  Logging ASE messages in file 'C:\Sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2004/03/12 11:10:17.29 kernel  Initializing MSDTC Connection
00:00000:00000:2004/03/12 11:10:19.33 kernel  MSDTC Initialization succeeded
00:00000:00000:2004/03/12 11:10:19.33 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2004/03/12 11:10:19.34 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2004/03/12 11:10:19.34 kernel  *** WARNING ******************
00:00000:00000:2004/03/12 11:10:19.34 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/03/12 11:10:19.34 kernel  SQL Server NT process id is 0x658.
00:00000:00000:2004/03/12 11:10:19.34 kernel  SQL Server was started as a Service.
00:00000:00000:2004/03/12 11:10:19.34 kernel  SSL Plus security modules loaded successfully.
00:00000:00000:2004/03/12 11:10:19.34 kernel  Network and device connection limit is 99992.
00:00000:00000:2004/03/12 11:10:19.41 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2004/03/12 11:10:19.42 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2004/03/12 11:10:19.43 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2004/03/12 11:10:19.43 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2004/03/12 11:10:19.44 kernel  Initializing virtual device 0, 'C:\Sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2004/03/12 11:10:19.44 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2004/03/12 11:10:19.44 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2004/03/12 11:10:19.44 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/03/12 11:10:19.44 kernel  engine 0, os pid 376  online
00:00000:00000:2004/03/12 11:10:19.45 server  No active traceflags
00:00000:00001:2004/03/12 11:10:19.45 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5/SWR 9616 GA/P/NT (IX86)/OS 4.0/main/1647/32-bit/OPT/Fri Jun 01 16:58:25 2001'.
00:00000:00001:2004/03/12 11:10:19.45 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P/PC Intel/BUILD125-005/OPT/Sat May 19 14:48:00 2001'
00:00000:00001:2004/03/12 11:10:19.45 server  Opening Master Database ...
00:00000:00001:2004/03/12 11:10:19.47 server  Loading SQL Server's default sort order and character set
00:00000:00001:2004/03/12 11:10:19.47 server  Loaded default Unilib conversion handle.
00:00000:00001:2004/03/12 11:10:19.47 server  Recovering database 'master'.
00:00000:00001:2004/03/12 11:10:19.48 server  Checking external objects.
00:00000:00001:2004/03/12 11:10:19.50 server  Database 'master' is now online.
00:00000:00001:2004/03/12 11:10:19.50 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 11:10:19.50 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2004/03/12 11:10:19.50 server  server is unnamed
00:00000:00001:2004/03/12 11:10:19.50 server  Activating disk 'sysprocsdev'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Initializing virtual device 1, 'C:\Sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2004/03/12 11:10:19.50 server  Activating disk 'ydxt_data'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Initializing virtual device 2, 'd:\ydxtsb\ydxt_data.dat' with dsync 'on'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2004/03/12 11:10:19.50 server  Activating disk 'ydxt_log'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Initializing virtual device 3, 'd:\ydxtsb\ydxt_log.dat' with dsync 'on'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2004/03/12 11:10:19.50 server  Activating disk 'ydxt_temp'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Initializing virtual device 4, 'd:\ydxtsb\ydxt_temp.dat' with dsync 'on'.
00:00000:00001:2004/03/12 11:10:19.50 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2004/03/12 11:10:19.53 server  Recovering database 'sybsystemdb'.
00:00000:00001:2004/03/12 11:10:19.54 server  Boot Count: 30
00:00000:00001:2004/03/12 11:10:19.54 server  Checking external objects.
00:00000:00001:2004/03/12 11:10:19.54 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 11:10:19.55 server  Database 'sybsystemdb' is now online.
00:00000:00001:2004/03/12 11:10:19.56 server  Recovering database 'model'.
00:00000:00001:2004/03/12 11:10:19.56 server  Checking external objects.
00:00000:00001:2004/03/12 11:10:19.57 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 11:10:19.57 server  Database 'model' is now online.
00:00000:00001:2004/03/12 11:10:19.58 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2004/03/12 11:10:19.58 server  0 dump conditions detected at boot time
00:00000:00001:2004/03/12 11:10:19.58 server  Resident Node id: d1569b841a78
00:00000:00001:2004/03/12 11:10:19.58 server  Transaction coordinator initialized.
00:00000:00001:2004/03/12 11:10:19.58 server  Clearing temp db
00:00000:00001:2004/03/12 11:10:36.32 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 11:10:36.33 server  Database 'tempdb' is now online.
00:00000:00001:2004/03/12 11:10:36.33 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2004/03/12 11:10:36.35 server  Checking external objects.
00:00000:00001:2004/03/12 11:10:36.36 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2004/03/12 11:10:36.37 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2004/03/12 11:10:36.37 kernel  network name 192.168.70.2, type ether, port 5000, filter NONE
00:00000:00001:2004/03/12 11:10:36.38 server  Recovering database 'ndydxt'.
00:00000:00001:2004/03/12 11:10:36.41 server  Error: 3474, Severity: 21, State: 1
00:00000:00001:2004/03/12 11:10:36.41 server  During redo the page timestamp value is less than old timestamp from log. Page #=6494, object id = 23, page timestamp=0000 00013434. Log old timestamp=0000 034bf2d6.
00:00000:00001:2004/03/12 11:10:36.41 server  Error: 3414, Severity: 21, State: 1
00:00000:00001:2004/03/12 11:10:36.41 server  Database 'ndydxt' (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause.
00:00000:00001:2004/03/12 11:10:36.41 server  Recovery complete.
00:00000:00001:2004/03/12 11:10:36.41 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2004/03/12 11:10:36.41 server  SQL Server's default sort order is:
00:00000:00001:2004/03/12 11:10:36.41 server          'altnoacc_cp850' (ID = 39)
00:00000:00001:2004/03/12 11:10:36.41 server  on top of default character set:
00:00000:00001:2004/03/12 11:10:36.41 server          'cp850' (ID = 2).
00:00000:00001:2004/03/12 11:10:36.41 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)