标题: 帮我看看这个问题该怎么解决 [打印本页] 作者: jintingli 时间: 2006-07-13 11:13 标题: 帮我看看这个问题该怎么解决 今日查数据服务器备机日志,发现日志中有这样的错误提示：
“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.