帮我看看这个问题该怎么解决

jintingli

今日查数据服务器备机日志,发现日志中有这样的错误提示：
    “00:00000:00006:2006/04/27 14:28:35.13 server  1 task(s) are sleeping waiting for  space to become available in the log segment for database sybsystemdb”
在日志中还发现：
“00:00000:00056:2006/04/27 14:25:05.70 server  background task message: LOG DUMPED TO: device '/data/logbackup/sybsystemdb_log_20060427142505.dump”
原来是4月27日有人在执行：
dump tran sybsystemdb to '/data/logbackup/sybsystemdb_log_20060427142505.dump’ 不成功，原因是sybase 用户没有对目录“/data”写的权限。
请问各位兄弟这对数据库有没有影响，该怎么解决
设备及ASE版本为：
Adaptive Server Enterprise/12.5.0.3/EBF 11444 ESD#4/P/RS6000/AIX 4.3.3/rel12503/1940/64-bit

部分日志如下：
00:00000:00117:2006/04/26 09:53:04.97 server  DBCC TRACEON 3604, SPID 117
00:00000:00117:2006/04/26 09:53:11.25 server  Checking space allocation for database 1
00:00000:00056:2006/04/27 14:25:05.67 server  background task message: LOG FULL: database 'sybsystemdb'
00:00000:00056:2006/04/27 14:25:05.69 server  background task message: LOG DUMP: database 'sybsystemdb', threshold '32'
00:00000:00056:2006/04/27 14:25:05.70 server  Error: 4205, Severity: 16, State: 1
00:00000:00056:2006/04/27 14:25:05.70 server  Syslogs does not exist in its own segment in database 'sybsystemdb' with segmap '7' with logical start page number of '0'. You cannot use DUMP TRANSACTION in this case, use DUMP DATABASE instead.
00:00000:00056:2006/04/27 14:25:05.70 server  background task message: LOG DUMP ERROR: 4205
00:00000:00056:2006/04/27 14:25:05.70 server  background task message: LOG DUMPED TO: device '/data/logbackup/sybsystemdb_log_20060427142505.dump
00:00000:00056:2006/04/27 14:25:05.70 server  background task message: LOG DUMP PAGES: Before: '359', After '359'
00:00000:00056:2006/04/27 14:25:05.71 server  background task message: LOG DUMP TIME: Apr 27 2006  2:25PM, Apr 27 2006  2:25PM
00:00000:00006:2006/04/27 14:25:35.13 server  1 task(s) are sleeping waiting for space to become available in the log segment for database sybsystemdb.
00:00000:00006:2006/04/27 14:26:35.13 server  1 task(s) are sleeping waiting for space to become available in the log segment for database sybsystemdb.
00:00000:00006:2006/04/27 14:27:35.13 server  1 task(s) are sleeping waiting for space to become available in the log segment for database sybsystemdb.
00:00000:00006:2006/04/27 14:28:35.13 server  1 task(s) are sleeping waiting for space to become available in the log segment for database sybsystemdb.

[ 本帖最后由 jintingli 于 2006-7-13 11:38 编辑 ]

leno_mx

sybsystemdb日志空间满了，增加设备空间

jintingli

原帖由 leno_mx 于 2006-7-13 11:53 发表
sybsystemdb日志空间满了，增加设备空间

就是因为日志空间满了，有人在截日志时操作错误所致。

zhangdonglin

"原来是4月27日有人在执行：
dump tran sybsystemdb to '/data/logbackup/sybsystemdb_log_20060427142505.dump’ 不成功，原因是sybase 用户没有对目录“/data”写的权限。"

按理说，没有操作成功，应该不会产生日志吧！

用dump tran sybsystemdb  with no_log 试试 或者增加设备空间！

jintingli

这个错误对系统没有多在的影响吧？