Sybase12日志满的解决办法2.docVIP

Sybase12.5日志满问题的解决 日志满分为两种情况：1.非master(用户库或者其他系统库sybsystemprocs)库的日志满，导致用户库不能访问；2.系统库master日志满，导致服务都不能正常启动。针对以上情况要分别对待处理。 1.非master库日志满的处理： 重庆数据库后台sybsystemprocs库日志报满：09:00000:01631:2011/11/13 06:45:36.16 server Error: 3475, Severity: 21, State: 709:00000:01631:2011/11/13 06:45:36.16 server There is no space available in SYSLOGS to log a record for which space has been reserved. This process will retry at intervals of one minute. 11:00000:04104:2011/11/13 06:20:11.87 server Space available in the log segment has fallen critically low in database sybsystemprocs. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.00:00000:02407:2011/11/13 06:20:11.89 server Error: 2812, Severity: 16, State: 500:00000:02407:2011/11/13 06:20:11.89 server Stored procedure sp_thresholdaction not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). 或某个用户库etoh2_cq的日志空间满报： 00:00000:00001:2008/12/02 17:28:07.38 serverwbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-align:leftError: 1105, Severity: 17, State: 3/spanbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-align:left00:00000:00001:2008/12/02 17:28:07.38 server/spanwbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-align:leftCant allocate space for object syslogs in database etoh2_cq because logsegment segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment./spanbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-align:left00:00000:00001:2008/12/02 17:28:07.38 server/spanwbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-align:leftError: 3475, Severity: 21, State: 7/spanbr style=line-height:21px; text-align:leftspan style=line-height:21px; text-