1 问题现象
DB2无法正常归档。https://www.cndba.cn/hbhe0316/article/4886
https://www.cndba.cn/hbhe0316/article/4886
https://www.cndba.cn/hbhe0316/article/4886
https://www.cndba.cn/hbhe0316/article/4886
2 问题诊断
db2 get dbm cfg | grep -i diag找到db2diag.log日志
db2diag.log日志抛:https://www.cndba.cn/hbhe0316/article/4886
https://www.cndba.cn/hbhe0316/article/4886
Failed to archive log file S0000003.LOG to /db2archlogs/db2inst1/TESTDB/NODE0002/C0000002/ from /db2home/db2inst1/db2inst1/NODE0002/SQL00001/SQLOGDIR/.
显示无法向/db2archlogs归档。https://www.cndba.cn/hbhe0316/article/4886https://www.cndba.cn/hbhe0316/article/4886
https://www.cndba.cn/hbhe0316/article/4886
3 数据收集,查看first active log号
https://www.cndba.cn/hbhe0316/article/4886
db2 get db cfg for <dbname> | grep -i active
4 恢复步骤
su - root
chown <db2inst1>.<db2iadm> /db2archlog
su - db2inst1
db2stop force
db2start
db2 activate db <dbname>
版权声明:本文为博主原创文章,未经博主允许不得转载。
DB2