SQL检测到基于一致性的逻辑 I/O 错误 页撕裂

无法使用闩锁类型 SH读取并闩锁页(1:415568)。由于不可修复的错误,CHECK语句终止。



公司动态 【2020-10-11 16:10】


DBCC CheckDB检测错误如下:




消息 605,级别 12,状态 3,第 1 行

Attempt to fetch logical page (1:415656) in database 7 failed. It belongs to allocation unit 2314885530818445312 not to 281474980642816.

消息 605,级别 12,状态 3,第 1 行

Attempt to fetch logical page (1:415656) in database 7 failed. It belongs to allocation unit 2314885530818445312 not to 281474980642816.

DBCC results for 'ERP_DATA'.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2387225703656521728 (type Unknown), page (1:413520). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007336695791616 (type Unknown), page ID (1:413521) contains an incorrect page ID in its page header. The PageId in the page header = (97:6488096).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007336695791616 (type Unknown), page ID (1:413522) contains an incorrect page ID in its page header. The PageId in the page header = (111:6422560).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 29555009995669504 (type Unknown), page ID (1:413523) contains an incorrect page ID in its page header. The PageId in the page header = (32:2097184).

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2814887208157184 (type Unknown), page (47:3080224). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3286783303050330112 (type Unknown), page (8481:555810816). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 28147897109905408 (type Unknown), page ID (1:413526) contains an incorrect page ID in its page header. The PageId in the page header = (116:7602273).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007693182402560 (type Unknown), page ID (1:413527) contains an incorrect page ID in its page header. The PageId in the page header = (73:7602277).

消息 8939,级别 16,状态 5,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.

消息 8939,级别 16,状态 8,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_freeCnt <= PAGESIZE - PageHeaderOverhead ()) failed. Values are 8224 and 8096.

消息 8939,级别 16,状态 10,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.

消息 8939,级别 16,状态 11,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_ghostRecCnt <= m_slotCnt) failed. Values are 25133 and 8224.




SQLServer 检测到基于一致性的逻辑 I/O 错误 页撕裂(签名应该为:0x55555555, 但实际为:0x00000001) 在文件‘D:\DATA\ERP_DATA.mdf’


001.png

002.png

003.png



1、重要数据要经常备份,【异地备份重要数据,一天一次】。备份方案推荐:秒备份

2、建议将重要数据定时备份到远程FTP,可以确保数据安全。


SQL Oracle MySQL数据库可以做恢复修复,QQ : 80554803,TEL : 18620906802 (微信)

SQL and Oracle and MySQL database can be restored and repaired, wechat: 18620906802, Skype: jogewang, Email:Data700@qq.com


甲骨文Oracle,微软SQLServer,MySQL常见错误修复恢复。底层修复。技术支持。





友情链接:
SQL数据库修复专家
  • 关注微博
    联系QQ
  • 二维码
  • 扫一扫加关注

——信阳市速全网络科技有限公司——

版权所有:信阳市速全网络科技有限公司

豫ICP备19030104号-2