sybase数据库只有某个库的数据设备文件和log设备文件，是否可以恢复？

[sfb]

各位老大，
我的sybase安装在/home/sybase下，里面包括master等其他数据库文件
只有用户数据库文件 放在/home2/sybdata下。
现在，我的sybase目录没有了，
也不记得原来分配了多少给用户数据库使用。具体参数忘记了，
只有定期的为用户数据库备份的dump文件，
没有相关设备、库的ddl备份

我还能恢复吗？
如何恢复？

谢谢老大们。
（网上查的是，创建一个大小一样位置一样的数据库，可是我不记得了阿。）

[sfb]

问题是
我不记得原来的大小了
怎么建立的一抹一样？
有没有办法能查到？

[hobbylu]

可以啊,就是你说的,建立一模一样的,然后覆盖

[os586]

帮你顶,虽然不是很寻常的问题.
但是还是 有一定的价值.

[sfb]

状况描述：
unixware 7.1.3 sybase 11.9.2
某天醒来，数据库进入不去，sybase用户登录失败，root登录，发现sybase目录没有了，
我的数据不见了！

经过察看lost+found目录，发现sybase的内容全部在里面，
于是，把内容恢复到sybase目录，根据正常的机器上的信息，
或增加或替换
根据相关log，文件日期等信息，设置数据库文件，设置interface，等等。

重新启动服务，
好了，嘻嘻。

现在问题出来了：
为什么会出现这种情况，为啥sybase目录会丢失？
这好像是操作系统的原因，跟sybase不不正常使用有关系？

各位大哥帮忙讨论一下吧

[sfb]

这是sybase最后启动的log
00:00000:00000:2006/08/28 08:07:41.79 kernel Using config area from primary master device.
00:00000:00000:2006/08/28 08:07:42.34 kernel Warning: Using default file '/home/sybase/xxwz.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/08/28 08:07:42.89 kernel Using 400 file descriptors.
00:00000:00000:2006/08/28 08:07:42.92 kernel Adaptive Server Enterprise/11.9.2/P/DG AViiON/SCO UnixWare 2.1.3/FBO/Tue Jul 6 08:52:13 1999
00:00000:00000:2006/08/28 08:07:42.97 kernel Confidential property of Sybase, Inc.
00:00000:00000:2006/08/28 08:07:42.97 kernel Copyright 1987, 1999
00:00000:00000:2006/08/28 08:07:42.97 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2006/08/28 08:07:42.98 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/08/28 08:07:42.98 kernel
00:00000:00000:2006/08/28 08:07:42.98 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/08/28 08:07:42.99 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2006/08/28 08:07:42.99 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2006/08/28 08:07:43.00 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2006/08/28 08:07:43.00 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2006/08/28 08:07:43.01 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/08/28 08:07:43.01 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/08/28 08:07:43.02 kernel Using '/home/sybase/xxwz.cfg' for configuration information.
00:00000:00000:2006/08/28 08:07:43.03 kernel Logging SQL Server messages in file '/home/sybase/errorlog.xxwz'.
00:00000:00000:2006/08/28 08:07:45.10 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/08/28 08:07:45.24 kernel Network and device connection limit is 390.
00:00000:00000:2006/08/28 08:07:45.44 server Number of proc buffers allocated: 741.
00:00000:00000:2006/08/28 08:07:45.76 kernel dioinit: Unable to lock memory for async I/O
00:00000:00000:2006/08/28 08:07:45.81 server Proc header memory allocated 370 pages for each per engine cache
00:00000:00000:2006/08/28 08:07:45.82 server Number of blocks left for proc headers: 789.
00:00000:00000:2006/08/28 08:07:45.82 server Memory allocated for the default data cache cache: 5544 Kb
00:00000:00000:2006/08/28 08:07:45.86 server Size of the 2K memory pool: 5544 Kb
00:00000:00000:2006/08/28 08:07:45.86 kernel Initializing virtual device 0, '/home/sybase/master.dat'
00:00000:00000:2006/08/28 08:07:45.93 kernel Virtual device 0 started using standard unix i/o.
00:00000:00000:2006/08/28 08:07:45.98 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/08/28 08:07:45.98 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/08/28 08:07:46.00 kernel engine 0, os pid 1153 online
00:00000:00000:2006/08/28 08:07:46.12 server No active traceflags
00:00000:00001:2006/08/28 08:07:46.30 server Opening Master Database ...
00:00000:00001:2006/08/28 08:07:46.68 server Loading SQL Server's default sort order and character set
tli_ninit: sninteraface: machname /dev/tcp, netname tcp

[sfb]

00:00000:00002:2006/08/28 08:07:46.78 kernel ninit:0: listener type: master
00:00000:00002:2006/08/28 08:07:46.89 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2006/08/28 08:07:46.90 kernel ninit:0: listener raw address: \x00021388c0a800350000000000000000
00:00000:00002:2006/08/28 08:07:46.90 kernel ninit:0: transport provider: T_COTS_ORD
tli_ninit: sninteraface: machname /dev/tcp, netname tcp
00:00000:00003:2006/08/28 08:07:46.91 kernel ninit:1: listener type: master
00:00000:00003:2006/08/28 08:07:46.91 kernel ninit:1: listener endpoint: /dev/tcp
00:00000:00003:2006/08/28 08:07:46.92 kernel ninit:1: listener raw address: \x000222b8c0a800350000000000000000
00:00000:00003:2006/08/28 08:07:46.92 kernel ninit:1: transport provider: T_COTS_ORD
00:00000:00001:2006/08/28 08:07:46.99 server Recovering database 'master'
00:00000:00001:2006/08/28 08:07:47.86 server Database 'master' is now online.
00:00000:00001:2006/08/28 08:07:47.89 server The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:47.89 server 0 dump conditions detected at boot time
00:00000:00001:2006/08/28 08:07:47.98 server server is unnamed
00:00000:00001:2006/08/28 08:07:48.05 server Activating disk 'lyxxlog'.
00:00000:00001:2006/08/28 08:07:48.05 kernel Initializing virtual device 4, '/home2/sybdata/xxlylog.dat'
00:00000:00001:2006/08/28 08:07:48.08 kernel Virtual device 4 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.08 server Activating disk 'sysprocsdev'.
00:00000:00001:2006/08/28 08:07:48.08 kernel Initializing virtual device 1, '/home/sybase/systemprocs.dat'
00:00000:00001:2006/08/28 08:07:48.09 kernel Virtual device 1 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.09 server Activating disk 'systemdbdev'.
00:00000:00001:2006/08/28 08:07:48.10 kernel Initializing virtual device 2, '/home/sybase/systemdb'
00:00000:00001:2006/08/28 08:07:48.10 kernel Virtual device 2 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.11 server Activating disk 'tempdev'.
00:00000:00001:2006/08/28 08:07:48.11 kernel Initializing virtual device 5, '/home/sybase/systemp.dat'
00:00000:00001:2006/08/28 08:07:48.11 kernel Virtual device 5 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.12 server Activating disk 'xxwzdata'.
00:00000:00001:2006/08/28 08:07:48.12 kernel Initializing virtual device 3, '/home2/sybdata/xxwzdata.dat'
00:00000:00001:2006/08/28 08:07:48.12 kernel Virtual device 3 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.13 server Activating disk 'zzwzdev'.
00:00000:00001:2006/08/28 08:07:48.13 kernel Initializing virtual device 6, '/home2/sybdata/wzdata.dat'
00:00000:00001:2006/08/28 08:07:48.14 kernel Virtual device 6 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.14 server Activating disk 'zzwzdev2'.
00:00000:00001:2006/08/28 08:07:48.14 kernel Initializing virtual device 7, '/home2/sybdata/wzdata2.dat'
00:00000:00001:2006/08/28 08:07:48.15 kernel Virtual device 7 started using standard unix i/o.
00:00000:00001:2006/08/28 08:07:48.91 server Recovering database 'model'.
00:00000:00001:2006/08/28 08:07:49.23 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:49.34 server Database 'model' is now online.
00:00000:00001:2006/08/28 08:07:49.34 server Clearing temp db
00:00000:00001:2006/08/28 08:07:55.87 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:55.87 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:55.87 server Database 'tempdb' is now online.
00:00000:00001:2006/08/28 08:07:55.87 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:56.02 server Recovering database 'sybsystemdb'.
00:00000:00001:2006/08/28 08:07:56.05 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:56.06 server Database 'sybsystemdb' is now online.
00:00000:00001:2006/08/28 08:07:56.23 server Recovering database 'sybsystemprocs'.
00:00000:00001:2006/08/28 08:07:56.31 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:56.31 server Database 'sybsystemprocs' is now online.
00:00000:00001:2006/08/28 08:07:56.74 server Recovering database 'wzxxdb'.
00:00000:00001:2006/08/28 08:07:56.91 server The transaction log in the database 'wzxxdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/28 08:07:57.00 server Database 'wzxxdb' is now online.
00:00000:00001:2006/08/28 08:07:57.01 server Recovery complete.
00:00000:00001:2006/08/28 08:07:57.01 server SQL Server's default sort order is:
00:00000:00001:2006/08/28 08:07:57.01 server 'bin_iso_1' (ID = 50)
00:00000:00001:2006/08/28 08:07:57.01 server on top of default character set:
00:00000:00001:2006/08/28 08:07:57.01 server 'iso_1' (ID = 1).
00:00000:00001:2006/08/28 08:07:57.01 server Loaded default Unilib conversion handle.
00:00000:00000:2006/08/28 17:47:19.77 kernel nspacket: t_snd, event requires attention
00:00000:00001:2006/08/28 17:47:19.88 server SQL Server shutdown by request.
00:00000:00001:2006/08/28 17:47:19.88 kernel ueshutdown: exiting

[ftsuo]

00:00000:00000:2006/08/29 07:57:57.54 kernel Using config area from primary master device.
00:00000:00000:2006/08/29 07:57:58.16 kernel Warning: Using default file '/home/sybase/xxwz.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/08/29 07:57:58.73 kernel Using 400 file descriptors.
00:00000:00000:2006/08/29 07:57:58.75 kernel Adaptive Server Enterprise/11.9.2/P/DG AViiON/SCO UnixWare 2.1.3/FBO/Tue Jul 6 08:52:13 1999
00:00000:00000:2006/08/29 07:57:58.80 kernel Confidential property of Sybase, Inc.
00:00000:00000:2006/08/29 07:57:58.80 kernel Copyright 1987, 1999
00:00000:00000:2006/08/29 07:57:58.80 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2006/08/29 07:57:58.81 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/08/29 07:57:58.81 kernel
00:00000:00000:2006/08/29 07:57:58.81 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/08/29 07:57:58.82 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2006/08/29 07:57:58.82 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2006/08/29 07:57:58.83 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2006/08/29 07:57:58.83 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2006/08/29 07:57:58.84 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/08/29 07:57:58.84 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2006/08/29 07:57:58.85 kernel Using '/home/sybase/xxwz.cfg' for configuration information.
00:00000:00000:2006/08/29 07:57:58.86 kernel Logging SQL Server messages in file '/home/sybase/errorlog.xxwz'.
00:00000:00000:2006/08/29 07:58:00.56 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/08/29 07:58:00.67 kernel Network and device connection limit is 390.
00:00000:00000:2006/08/29 07:58:00.96 server Number of proc buffers allocated: 741.
00:00000:00000:2006/08/29 07:58:01.16 kernel dioinit: Unable to lock memory for async I/O
00:00000:00000:2006/08/29 07:58:01.27 server Proc header memory allocated 370 pages for each per engine cache
00:00000:00000:2006/08/29 07:58:01.27 server Number of blocks left for proc headers: 789.
00:00000:00000:2006/08/29 07:58:01.28 server Memory allocated for the default data cache cache: 5544 Kb
00:00000:00000:2006/08/29 07:58:01.28 server Size of the 2K memory pool: 5544 Kb
00:00000:00000:2006/08/29 07:58:01.29 kernel Initializing virtual device 0, '/home/sybase/master.dat'
00:00000:00000:2006/08/29 07:58:01.29 kernel Virtual device 0 started using standard unix i/o.
00:00000:00000:2006/08/29 07:58:01.34 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/08/29 07:58:01.34 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/08/29 07:58:01.35 kernel engine 0, os pid 1153 online
00:00000:00000:2006/08/29 07:58:01.48 server No active traceflags
00:00000:00001:2006/08/29 07:58:01.66 server Opening Master Database ...
00:00000:00001:2006/08/29 07:58:02.20 server Loading SQL Server's default sort order and character set
tli_ninit: sninteraface: machname /dev/tcp, netname tcp
00:00000:00002:2006/08/29 07:58:02.28 kernel ninit:0: listener type: master
00:00000:00002:2006/08/29 07:58:02.32 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2006/08/29 07:58:02.33 kernel ninit:0: listener raw address: \x00021388c0a800350000000000000000
00:00000:00002:2006/08/29 07:58:02.33 kernel ninit:0: transport provider: T_COTS_ORD
tli_ninit: sninteraface: machname /dev/tcp, netname tcp
00:00000:00003:2006/08/29 07:58:02.34 kernel ninit:1: listener type: master
00:00000:00003:2006/08/29 07:58:02.34 kernel ninit:1: listener endpoint: /dev/tcp
00:00000:00003:2006/08/29 07:58:02.34 kernel ninit:1: listener raw address: \x000222b8c0a800350000000000000000
00:00000:00003:2006/08/29 07:58:02.35 kernel ninit:1: transport provider: T_COTS_ORD
00:00000:00001:2006/08/29 07:58:02.49 server Recovering database 'master'
00:00000:00001:2006/08/29 07:58:03.21 server Database 'master' is now online.
00:00000:00001:2006/08/29 07:58:03.24 server The transaction log in the database 'master' will use I/O size of 2 Kb.

[ftsuo]

00:00000:00001:2006/08/29 07:58:03.24 server 0 dump conditions detected at boot time
00:00000:00001:2006/08/29 07:58:03.38 server server is unnamed
00:00000:00001:2006/08/29 07:58:03.57 server Activating disk 'lyxxlog'.
00:00000:00001:2006/08/29 07:58:03.57 kernel Initializing virtual device 4, '/home2/sybdata/xxlylog.dat'
00:00000:00001:2006/08/29 07:58:03.61 kernel Virtual device 4 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.61 server Activating disk 'sysprocsdev'.
00:00000:00001:2006/08/29 07:58:03.62 kernel Initializing virtual device 1, '/home/sybase/systemprocs.dat'
00:00000:00001:2006/08/29 07:58:03.62 kernel Virtual device 1 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.63 server Activating disk 'systemdbdev'.
00:00000:00001:2006/08/29 07:58:03.63 kernel Initializing virtual device 2, '/home/sybase/systemdb'
00:00000:00001:2006/08/29 07:58:03.63 kernel Virtual device 2 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.64 server Activating disk 'tempdev'.
00:00000:00001:2006/08/29 07:58:03.64 kernel Initializing virtual device 5, '/home/sybase/systemp.dat'
00:00000:00001:2006/08/29 07:58:03.64 kernel Virtual device 5 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.65 server Activating disk 'xxwzdata'.
00:00000:00001:2006/08/29 07:58:03.65 kernel Initializing virtual device 3, '/home2/sybdata/xxwzdata.dat'
00:00000:00001:2006/08/29 07:58:03.66 kernel Virtual device 3 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.66 server Activating disk 'zzwzdev'.
00:00000:00001:2006/08/29 07:58:03.66 kernel Initializing virtual device 6, '/home2/sybdata/wzdata.dat'
00:00000:00001:2006/08/29 07:58:03.67 kernel Virtual device 6 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:03.67 server Activating disk 'zzwzdev2'.
00:00000:00001:2006/08/29 07:58:03.67 kernel Initializing virtual device 7, '/home2/sybdata/wzdata2.dat'
00:00000:00001:2006/08/29 07:58:03.68 kernel Virtual device 7 started using standard unix i/o.
00:00000:00001:2006/08/29 07:58:04.75 server Recovering database 'model'.
00:00000:00001:2006/08/29 07:58:04.88 server The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:05.00 server Database 'model' is now online.
00:00000:00001:2006/08/29 07:58:05.01 server Clearing temp db
00:00000:00001:2006/08/29 07:58:12.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:12.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:12.16 server Database 'tempdb' is now online.
00:00000:00001:2006/08/29 07:58:12.16 server The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:12.27 server Recovering database 'sybsystemdb'.
00:00000:00001:2006/08/29 07:58:12.35 server The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:12.47 server Database 'sybsystemdb' is now online.
00:00000:00001:2006/08/29 07:58:12.72 server Recovering database 'sybsystemprocs'.
00:00000:00001:2006/08/29 07:58:12.80 server The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:12.88 server Database 'sybsystemprocs' is now online.
00:00000:00001:2006/08/29 07:58:13.13 server Recovering database 'wzxxdb'.
00:00000:00001:2006/08/29 07:58:13.23 server The transaction log in the database 'wzxxdb' will use I/O size of 2 Kb.
00:00000:00001:2006/08/29 07:58:13.25 server Database 'wzxxdb' is now online.
00:00000:00001:2006/08/29 07:58:13.26 server Recovery complete.
00:00000:00001:2006/08/29 07:58:13.26 server SQL Server's default sort order is:
00:00000:00001:2006/08/29 07:58:13.26 server 'bin_iso_1' (ID = 50)
00:00000:00001:2006/08/29 07:58:13.26 server on top of default character set:
00:00000:00001:2006/08/29 07:58:13.26 server 'iso_1' (ID = 1).
00:00000:00001:2006/08/29 07:58:13.26 server Loaded default Unilib conversion handle.

[sfb]

没人捧场？

[ZZZzzzZZZ]

有数据文件和日志的备份，恢复起来应该很容易啊！

重要的是数据库名，位置应该是无所谓的，大小嘛，只要新建的数据库不小如原来那个就行了，如果说原来的库分配的空间是1G的，现在分配2G一样可以正常导入。楼主可以试试~