sybase iq 12.7 数据库修复 Invalid bitmap links on page

最新案例

.malox勒索病毒解密服务...

.Carver勒索病毒解密服务...

sybase数据库

2015-04-06 15:08:31

这是某地移动公司的 IQ服务器里面存储了几十TB的电话录音，一个db 拖了几十个TB仓库机房断电导致的损坏故障,老备份是一周前。

Run Directory : /home/iq/SGDB

Server Executable : /home/iq/asiq12/bin/asiqsrv12

Server Output Log : /home/iq/asiq12/logfiles/sg_iq.023.srvlog

Server Version : 12.7.0/ESD 7

Open Client Version : 15.0/P-EBF13571 ESD #4

User Parameters : '@sg_iq.cfg' 'sg_iq.db' '-f'

Default Parameters : -hs -gn 205

I. 01/07 04:50:10. Adaptive Server IQ

I. 01/07 04:50:10. Version 12.7

I. 01/07 04:50:10. (64bit mode)

I. 01/07 04:50:10.

I. 01/07 04:50:10. 8 logical processor(s) on 2 physical processor(s) detected.

I. 01/07 04:50:10. Running on Linux 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x

I. 01/07 04:50:10. 65536K of memory used for caching

I. 01/07 04:50:10. Minimum cache size: 65536K, maximum cache size: 262012K

I. 01/07 04:50:10. Using a maximum page size of 4096 bytes

I. 01/07 04:50:11. Starting database "sg_iq" (/home/iq/SGDB/sg_iq.db) at Sun Jan 07 2001 04:50

I. 01/07 04:50:11. Database recovery in progress

I. 01/07 04:50:11. Last checkpoint at Fri Apr 04 2015 17:11

I. 01/07 04:50:11. Checkpoint log...

E. 01/07 04:50:11. *** ERROR *** Assertion failed: 202101 (12.7.0.2074)

E. 01/07 04:50:11. Invalid bitmap links on page 0x95d5

Adaptive Server IQ

Version 12.7

(64bit mode)

从日志看是位图链接页损坏，但实际上我分析这个页面并无损坏,真实的故障时位图索引页面出现问题,手工修正指针即可。
在windows下做的启动测试

I. 04/06 14:35:35. Adaptive Server IQ

I. 04/06 14:35:35. Version 12.7

I. 04/06 14:35:35. (32bit mode)

I. 04/06 14:35:35.

I. 04/06 14:35:35. 4 logical processor(s) on 1 physical processor(s) detected.

I. 04/06 14:35:35. Running on Windows 2003 Build 3790 Service Pack 2

I. 04/06 14:35:35. 32768K of memory used for caching

I. 04/06 14:35:35. Minimum cache size: 32768K, maximum cache size: 262144K

I. 04/06 14:35:35. Using a maximum page size of 4096 bytes

I. 04/06 14:35:35. Starting database "sg_iq" (c:\sg_iq.db) at Mon Apr 06 2015 14:35

I. 04/06 14:35:35. Database recovery in progress

I. 04/06 14:35:35. Last checkpoint at Fri Apr 04 2015 17:11

I. 04/06 14:35:35. Checkpoint log...

E. 04/06 14:35:36. Error: File does not exist. File: C:\home\iq\SGDB\sg_iq.iqmsg

E. 04/06 14:35:36. -- (hos_ion.cxx 182)

I. 04/06 14:35:36. Error: File does not exist. File: C:\home\iq\SGDB\sg_iq.iqmsg

I. 04/06 14:35:36. -- (hos_ion.cxx 182)

I. 04/06 14:35:36.

E. 04/06 14:35:36. File does not exist. File: C:\home\iq\SGDB\sg_iq.iqmsg

E. 04/06 14:35:36. -- (hos_ion.cxx 182)

他已经成功启动，找不到sq_iq.iqmsg文件是因为不在原机子上，把修复后的db放到存储位置启动后，整个数据库完全正常。

[Print] [Close]

Prev: sybase数据库修复 sybase11.9数据库恢复 sybase ase报错恢复

Next: sql anywhere db文件修复 sybase db文件修复