欢迎访问深圳极佳数据恢复救援网站！
Sybase 数据库恢复案例
sybase iq 12.7 数据库修复 Invalid bitmap links on page
这是某地移动公司的 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. Copyright 1992-2008 by Sybase, Inc. All rights reserved
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)
Copyright 1992-2008 by Sybase, Inc. All rights reserved
从日志看 是 位图链接页 损坏 ，但实际上我分析 这个页面并无损坏,真实的故障时 位图索引页面 出现问题,手工修正指针即可。
在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. Copyright 1992-2006 by Sybase, Inc. All rights reserved
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:homeiqSGDBsg_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:homeiqSGDBsg_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:homeiqSGDBsg_iq.iqmsg
E. 04/06 14:35:36. -- (hos_ion.cxx 182)
.jpg)
他已经成功启动， 找不到sq_iq.iqmsg文件是因为 不在原机子上，把修复后的db放到存储位置 启动后，整个数据库完全正常。
