- 论坛徽章:
- 0
|
SQL1117N 由于 ROLL-FORWARD PENDING,不能连接或激活数据库
遇到一样的问题了,专家请解:
1. 我修改参数:
db2 update db cfg for sample using LOGRETAIN ON
2. force applications all
3. db2stop
4. db2start
5. db2 backup db sample to c:\tmp
6. insert data into table test
7. db2 backup db sample online to c:\tmp\db2
8. insert data into table test
9. db2 force applications all
10. db2stop
11. db2start
12. db2 restore db sample from c:\tmp\db2
13. db2 rollforward db sample to end of logs and stop
14. db2 delete from test
15. db2 force applications all
16. db2stop
17. db2start
18. db2 restore db sample from c:\tmp\db2
19. db2 rollforward db sample to end of logs and stop
开始出现问题了:
roll forward database samplel can't reach the point of specific, because of missing log file(s) on Node(0)
检查 f:\db2\NODE00000\SQL00001\SQLOGDIR, 果然没有log了
怎么办?我的测试数据库没有办法恢复了. |
|