未学过SYBASE,但赶鸭子上架,被逼维护数据库。
观察出错情况如下:
Can't allocate space for object 'master_log' in database 'foxhis' because the 'default' segment is full. IF you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
通过dump trabsaction foxhis with truncate_only清除日志后,用sp_helpdb foxhis查看结果如下:
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
foxhis 1702.5 MB foxhis 5
Nov 12, 2001
select into/bulkcopy, trunc log on chkpt, allow nulls by default
device_fragments size usage free kbytes
------------------------------ ------------- -------------------- -----------
foxhis 1000.0 MB data only 0
foxhis1 1.5 MB data only 0
foxhis2 1.0 MB data only 0
foxhis3 500.0 MB data only 0
foxlog 200.0 MB log only 204784
device
segment
------------------------------
通过sp_helpdevice
1> sp_helpdevice
2> go
device_name physical_name
description
status cntrltype device_number low high
------------------------------ ----------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------ --------- ------------- ----------- -----------
foxdump /backup/dump/foxdump.dat
disk, dump device
16 2 0 0 0
foxhis /dev/rfoxhis
special, physical disk, 1000.00 MB
2 0 2 33554432 34066431
foxhis1 \data1\foxhis1.dat
special, physical disk, 1.95 MB