文章目录
- 环境
- 症状
- 问题原因
- 解决方案
环境
系统平台:N/A
版本:4.5.6
症状
启动瀚高数据库,数据库日志报如下错误:
2025-07-16 09:39:04.657 CST,,,22985,,687702b8.59c9,11,,2025-07-16 09:39:04 CST,,0,日志,XX000,"无法取文件 ""./base/16384/367737206"" 的状态: 结构需要清理",,,,,,,,,"" 2025-07-16 09:39:04.658 CST,,,22985,,687702b8.59c9,12,,2025-07-16 09:39:04 CST,,0,日志,XX000,"无法取文件 ""./base/16384/367737107"" 的状态: 结构需要清理",,,,,,,,,"" 2025-07-16 09:39:04.661 CST,,,22985,,687702b8.59c9,13,,2025-07-16 09:39:04 CST,,0,日志,XX000,"无法取文件 ""./base/16384/367737230"" 的状态: 结构需要清理",,,,,,,,,"" 2025-07-16 09:39:04.664 CST,,,22985,,687702b8.59c9,14,,2025-07-16 09:39:04 CST,,0,日志,XX000,"无法取文件 ""./base/16384/367734763"" 的状态: 结构需要清理",,,,,,,,,"" 2025-07-16 09:39:04.666 CST,,,22985,,687702b8.59c9,15,,2025-07-16 09:39:04 CST,,0,日志,00000,"数据库系统没有正确的关闭; 处于自动恢复状态中",,,,,,,,,"" 2025-07-16 09:39:04.672 CST,,,22985,,687702b8.59c9,16,,2025-07-16 09:39:04 CST,,0,日志,00000,"redo 在 1BEE/E66FEF50 开始",,,,,,,,,"" 2025-07-16 09:39:04.708 CST,,,22985,,687702b8.59c9,17,,2025-07-16 09:39:04 CST,,0,致命错误,XX000,"无法创建文件 ""base/16384/367737094"": 结构需要清理",,,,,"Storage/CREATE: base/16384/367737094 WAL 重做在 1BEE/E683B560 位置",,,,"" 2025-07-16 09:39:04.710 CST,,,22808,,687702b8.5918,2,,2025-07-16 09:39:04 CST,,0,日志,00000,"启动进程 (PID 22985) 已退出, 退出代码 1",,,,,,,,,"" 2025-07-16 09:39:04.710 CST,,,22808,,687702b8.5918,3,,2025-07-16 09:39:04 CST,,0,日志,00000,"由于启动进程失败, 终止启动",,,,,,,,,""du -sh 报错文件,报:
du: 无法访问"./base/16384/367734763": 结构需要清理问题原因
数据文件损坏,无法使用。
解决方案
将备份拷贝到正常磁盘,使用备份恢复数据库,参考SUPPORT 011654804,如果没有备份,由操作系统工程师和硬件工程师确认原磁盘状态,进行硬件修复。