当前位置: 代码迷 >> Sybase >> 急高分!
  详细解决方案

急高分!

热度:2727   发布时间:2013-02-26 00:00:00.0
急!在线等,高分求助!!!!
未学过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  
  相关解决方案