sybase12.5.3状态为－32756，如何解决？？？

zy8215356

我的备份数据有点问题，还原后强进ONLINE，现在数据库 能启动，也能读数据，唯独不能写入或删除，一执行就出现报错：  Attempt to BEGIN TRANSACTION  in database 'xlpsdb' failed because database is in BYPASS RECOVERY mode，一查询发现‘xlpsdb’数据库状态为－32756，请各位高手看看如何解决！！附日志以供大家参考！

    02:00000:00034:2006/09/03 09:20:43.98 kernel  Cannot read, host process disconnected: WinNT 4068 spid: 34
02:00000:00045:2006/09/03 09:21:01.36 kernel  Cannot read, host process disconnected: WinNT 1248 spid: 45
02:00000:00035:2006/09/03 09:32:47.78 kernel  Cannot read, host process disconnected:  2100 spid: 35
02:00000:00023:2006/09/03 09:32:47.78 kernel  Cannot read, host process disconnected:  2100 spid: 23
01:00000:00024:2006/09/03 09:43:57.19 kernel  Cannot read, host process disconnected:  2552 spid: 24
00:00000:00049:2006/09/03 09:56:27.16 kernel  Cannot read, host process disconnected:  3504 spid: 49
01:00000:00022:2006/09/03 09:56:27.17 kernel  Cannot read, host process disconnected:  3504 spid: 22
01:00000:00026:2006/09/03 09:57:49.90 kernel  Cannot read, host process disconnected: WinNT 3480 spid: 26
02:00000:00014:2006/09/03 10:37:17.20 kernel  Cannot read, host process disconnected: DLSERVER 3408 spid: 14
01:00000:00027:2006/09/03 10:37:41.63 kernel  Cannot read, host process disconnected: DLSERVER 3408 spid: 27
02:00000:00037:2006/09/03 10:38:23.79 kernel  Cannot read, host process disconnected: WinNT 2964 spid: 37
00:00000:00034:2006/09/03 10:43:48.82 kernel  Cannot read, host process disconnected: WinNT 3636 spid: 34
01:00000:00022:2006/09/03 10:45:11.70 kernel  Cannot send, host process disconnected: xlserver1 16188 suid: 1
01:00000:00030:2006/09/03 10:50:28.20 kernel  Cannot read, host process disconnected: XLZY 1872 spid: 30
02:00000:00017:2006/09/03 10:55:20.80 kernel  Cannot read, host process disconnected: XLZY 3204 spid: 17
02:00000:00040:2006/09/03 10:55:20.90 kernel  Cannot read, host process disconnected: XLZY 1588 spid: 40
01:00000:00016:2006/09/03 10:55:21.51 kernel  Cannot read, host process disconnected: XLZY 2116 spid: 16
00:00000:00000:2006/09/03 10:56:19.36 kernel  nrpacket: recv, Connection timed out
00:00000:00000:2006/09/03 11:14:16.54 kernel  nrpacket: recv, Connection timed out
02:00000:00013:2006/09/03 11:33:11.28 kernel  Cannot read, host process disconnected: WinNT 2252 spid: 13
00:00000:00026:2006/09/03 11:57:08.73 server  Configuration file '/home/sybase/ASE-12_5/xltemp.cfg' has been written and the previous version has been renamed to '/home/sybase/ASE-12_5/xltemp.127'.
01:00000:00026:2006/09/03 11:57:08.74 server  The configuration option 'allow updates to system tables' has been changed by 'sa' from '1' to '1'.
01:00000:00026:2006/09/03 12:00:36.19 server  Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
01:00000:00026:2006/09/03 12:00:36.20 server  SQL Server shutdown by request.
01:00000:00026:2006/09/03 12:00:36.20 kernel  ueshutdown: exiting
00:00000:00000:2006/09/03 12:04:50.59 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2006/09/03 12:04:50.59 kernel  Using config area from primary master device.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Detected 8 physical CPU's
00:00000:00000:2006/09/03 12:04:50.60 kernel  Internal run-time model set for Linux  - Native
00:00000:00000:2006/09/03 12:04:50.60 kernel  Using 1024 file descriptors.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Adaptive Server Enterprise/12.5.3/EBF 13332 ESD#7/P/Linux Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24 00:40:52 2006
00:00000:00000:2006/09/03 12:04:50.60 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Copyright 1987, 2006
00:00000:00000:2006/09/03 12:04:50.60 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/09/03 12:04:50.60 kernel  
00:00000:00000:2006/09/03 12:04:50.60 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/09/03 12:04:50.60 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/09/03 12:04:50.60 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/09/03 12:04:50.60 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/09/03 12:04:50.60 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/09/03 12:04:50.60 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2006/09/03 12:04:50.60 kernel  ASE booted on Linux release 2.4.21-32.ELsmp version #1 SMP Fri Apr 15 21:17:59 EDT 2005.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Using '/home/sybase/ASE-12_5/xltemp.cfg' for configuration information.
00:00000:00000:2006/09/03 12:04:50.60 kernel  Logging ASE messages in file '/home/sybase/ASE-12_5/install/xltemp.log'.
00:00000:00000:2006/09/03 12:04:50.62 kernel  SQL Server booted with TCP_NODELAY enabled.
00:00000:00000:2006/09/03 12:04:50.62 kernel  SSL Plus v3.1.14 security modules loaded successfully.
00:00000:00000:2006/09/03 12:04:50.62 kernel  Network and device connection limit is 1014.
00:00000:00000:2006/09/03 12:04:51.75 server  Number of blocks left for proc headers: 204744.
00:00000:00000:2006/09/03 12:04:51.79 server  Proc header memory allocated 25593 pages for each per engine cache
00:00000:00000:2006/09/03 12:04:51.79 server  Local cache partition number has been auto tuned to 1 for default data cache cache.
00:00000:00000:2006/09/03 12:04:54.03 server  Size of the 2K memory pool: 1024000 Kb
00:00000:00000:2006/09/03 12:04:54.03 server  Memory allocated for the default data cache cachelet 1: 1024000 Kb
00:00000:00000:2006/09/03 12:04:54.03 kernel  Enabling Linux Kernel asynchronous disk I/O strategy.
00:00000:00000:2006/09/03 12:04:54.03 kernel  Initializing virtual device 0, '/home/sybase/sybdev/master.dat' with dsync 'on'.
00:00000:00000:2006/09/03 12:04:54.03 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/09/03 12:04:54.03 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/09/03 12:04:54.03 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:2006/09/03 12:04:54.03 kernel  Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2006/09/03 12:04:54.05 kernel  engine 0, os pid 8705  online
00:00000:00000:2006/09/03 12:04:54.05 server  No active traceflags
00:00000:00001:2006/09/03 12:04:54.05 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.3/EBF 13332 ESD#7/P/Linux Intel/Enterprise Linux/ase1253/1951/32-bit/OPT/Fri Mar 24 00:40:52 2006'.
00:00000:00001:2006/09/03 12:04:54.05 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5.1/P-EBF12823 ESD #10/DRV.12.5.1.4/Linux Intel/Linux 2.4.18-18.7.xsmp i686/BUILD1251-043/OPT/Wed Aug 10 19:53:54 2005'
00:00000:00001:2006/09/03 12:04:54.05 server  Opening Master Database ...
00:00000:00001:2006/09/03 12:04:54.08 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/09/03 12:04:54.09 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/09/03 12:04:54.09 server  Recovering database 'master'.
00:00000:00001:2006/09/03 12:04:54.09 server  Started estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/09/03 12:04:54.09 server  Database 'master', checkpoint=(6354, 22), first=(6354, 22), last=(6542, 15).
00:00000:00001:2006/09/03 12:04:54.09 server  Completed estimating recovery log boundaries for database 'master'.
00:00000:00001:2006/09/03 12:04:54.09 server  Started ANALYSIS pass for database 'master'.
00:00000:00001:2006/09/03 12:04:54.09 server  Completed ANALYSIS pass for database 'master'.
00:00000:00001:2006/09/03 12:04:54.09 server  Started REDO pass for database 'master'. The total number of log records to process is 1338.
00:00000:00001:2006/09/03 12:04:54.14 server  Redo pass of recovery has processed 27 committed and 0 aborted transactions.
00:00000:00001:2006/09/03 12:04:54.14 server  Completed REDO pass for database 'master'.
00:00000:00001:2006/09/03 12:04:54.14 server  Recovery of database 'master' will undo incomplete nested top actions.
00:00000:00001:2006/09/03 12:04:54.14 server  Started recovery checkpoint for database 'master'.
00:00000:00001:2006/09/03 12:04:54.16 server  Completed recovery checkpoint for database 'master'.
00:00000:00001:2006/09/03 12:04:54.16 server  Started filling free space info for database 'master'.
00:00000:00001:2006/09/03 12:04:54.84 server  Completed filling free space info for database 'master'.
00:00000:00001:2006/09/03 12:04:54.84 server  Started cleaning up the default data cache for database 'master'.
00:00000:00001:2006/09/03 12:04:54.87 server  Completed cleaning up the default data cache for database 'master'.
00:00000:00001:2006/09/03 12:04:54.87 server  Checking external objects.
00:00000:00001:2006/09/03 12:04:54.87 server  Database 'master' is now online.
00:00000:00001:2006/09/03 12:04:54.87 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/09/03 12:04:54.89 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/09/03 12:04:54.89 server  server name is 'xltemp'
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'sysprocsdev' of size 307200 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 1, '/home/sybase/sybdev/sybsystemprocs.dat' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'systemdbdev' of size 204800 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 2, '/home/sybase/sybdev/sybsystemdb.dat' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'xldata1' of size 30720000 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 5, '/data/xldata1.dev' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'xldata2' of size 30720000 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 4, '/data/xldata2.dev' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'xllog1' of size 4096000 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 6, '/data/xllog1' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.90 server  Activating disk 'xltempdb' of size 2048000 KB.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Initializing virtual device 7, '/data/xltempdb.dev' with dsync 'on'.
00:00000:00001:2006/09/03 12:04:54.90 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2006/09/03 12:04:54.95 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.95 server  Started estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.95 server  Database 'sybsystemdb', checkpoint=(645, 17), first=(645, 17), last=(645, 17).
00:00000:00001:2006/09/03 12:04:54.95 server  Completed estimating recovery log boundaries for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.95 server  Started ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.95 server  Completed ANALYSIS pass for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.95 server  Started REDO pass for database 'sybsystemdb'. The total number of log records to process is 1.
00:00000:00001:2006/09/03 12:04:54.96 server  Completed REDO pass for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.96 server  Recovery of database 'sybsystemdb' will undo incomplete nested top actions.
00:00000:00001:2006/09/03 12:04:54.96 server  Started recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.96 server  Completed recovery checkpoint for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:54.96 server  Started filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:55.03 server  Completed filling free space info for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:55.03 server  Started cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:55.06 server  Completed cleaning up the default data cache for database 'sybsystemdb'.
00:00000:00001:2006/09/03 12:04:55.06 server  Boot Count: 19
00:00000:00001:2006/09/03 12:04:55.06 server  Checking external objects.
00:00000:00001:2006/09/03 12:04:55.06 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/09/03 12:04:55.09 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/09/03 12:04:55.12 server  Recovering database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Started estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Database 'model', checkpoint=(629, 13), first=(629, 13), last=(629, 13).
00:00000:00001:2006/09/03 12:04:55.12 server  Completed estimating recovery log boundaries for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Started ANALYSIS pass for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Completed ANALYSIS pass for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Started REDO pass for database 'model'. The total number of log records to process is 1.
00:00000:00001:2006/09/03 12:04:55.12 server  Completed REDO pass for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Recovery of database 'model' will undo incomplete nested top actions.
00:00000:00001:2006/09/03 12:04:55.12 server  Started recovery checkpoint for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Completed recovery checkpoint for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Started filling free space info for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Completed filling free space info for database 'model'.
00:00000:00001:2006/09/03 12:04:55.12 server  Started cleaning up the default data cache for database 'model'.
00:00000:00001:2006/09/03 12:04:55.15 server  Completed cleaning up the default data cache for database 'model'.
00:00000:00001:2006/09/03 12:04:55.15 server  Checking external objects.
00:00000:00001:2006/09/03 12:04:55.15 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/09/03 12:04:55.18 server  Database 'model' is now online.
00:00000:00001:2006/09/03 12:04:55.18 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2006/09/03 12:04:55.18 server  0 dump conditions detected at boot time
00:00000:00001:2006/09/03 12:04:55.18 server  Resident Node id: cf086c70be1f
00:00000:00001:2006/09/03 12:04:55.18 server  Transaction coordinator initialized.
00:00000:00001:2006/09/03 12:04:55.18 server  Clearing temp db
00:00000:00001:2006/09/03 12:05:30.83 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/09/03 12:05:30.86 server  Database 'tempdb' is now online.
00:00000:00001:2006/09/03 12:05:30.89 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Started estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Database 'sybsystemprocs', checkpoint=(96807, 7), first=(96807, 6), last=(96807, 16).
00:00000:00001:2006/09/03 12:05:30.89 server  Completed estimating recovery log boundaries for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Started ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Completed ANALYSIS pass for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Started REDO pass for database 'sybsystemprocs'. The total number of log records to process is 11.
00:00000:00001:2006/09/03 12:05:30.89 server  Redo pass of recovery has processed 1 committed and 0 aborted transactions.
00:00000:00001:2006/09/03 12:05:30.89 server  Completed REDO pass for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Recovery of database 'sybsystemprocs' will undo incomplete nested top actions.
00:00000:00001:2006/09/03 12:05:30.89 server  Started recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Completed recovery checkpoint for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:30.89 server  Started filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:31.05 server  Completed filling free space info for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:31.05 server  Started cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:31.07 server  Completed cleaning up the default data cache for database 'sybsystemprocs'.
00:00000:00001:2006/09/03 12:05:31.07 server  Checking external objects.
00:00000:00001:2006/09/03 12:05:31.07 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/09/03 12:05:31.10 server  Database 'sybsystemprocs' is now online.
00:00000:00009:2006/09/03 12:05:31.10 kernel  network name xlserver1, interface IPv4, address 192.168.1.11, type tcp, port 5000, filter NONE
01:00000:00000:2006/09/03 12:05:31.35 kernel  engine 1, os pid 9138  online
02:00000:00000:2006/09/03 12:05:31.56 kernel  engine 2, os pid 9139  online
00:00000:00001:2006/09/03 12:05:31.57 kernel  Use sp_engine procedure to online 1 more new engines.
00:00000:00001:2006/09/03 12:05:31.57 server  
*** Bypassing recovery of database id 4

00:00000:00001:2006/09/03 12:05:32.45 server  Recovery complete.
00:00000:00001:2006/09/03 12:05:32.45 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2006/09/03 12:05:32.45 server  SQL Server's default sort order is:
00:00000:00001:2006/09/03 12:05:32.45 server          'bin_iso_1' (ID = 50)
00:00000:00001:2006/09/03 12:05:32.45 server  on top of default character set:
00:00000:00001:2006/09/03 12:05:32.45 server          'iso_1' (ID = 1).
00:00000:00001:2006/09/03 12:05:32.45 server  Master device size: 500 megabytes, or 256000 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00011:2006/09/03 12:07:41.73 kernel  Cannot read, host process disconnected: WinNT 2064 spid: 11

zy8215356

在线急等，小弟在这儿先谢各位了！！！

hobbylu

需要发生这个故障前面的信息