软件开发 数据库
在线全备，没有日志怎么恢复？
大家好，上次同事从生产库做了在线全备，但是没有include logs，虽然把最后的日志拷贝回来了，但是现在恢复完后，数据库处于前滚暂挂状态。在没有前滚所要的日志情况下，可不可以把数据库置为可用状态？
6 同行回答
还好同事及时把日志发了回来，不然真不知道怎么办了……
谢谢db2china，解释得这么详细。还有hchao和蓝皮猪猪，呵呵。
to hchao：
备份语句--db2 backup db dbname online to D: [ 本帖最后由 Felix 于 2008-7-2 17:25 编辑 ] 收起
谢谢db2china，解释得这么详细。还有hchao和蓝皮猪猪，呵呵。
to hchao：
备份语句--db2 backup db dbname online to D: [ 本帖最后由 Felix 于 2008-7-2 17:25 编辑 ] 收起
谢谢你的提问！
非常抱歉今天才给你回复！我请教了一个专家，解答如下，你看看对你有没有帮助。
not really
because when you do online backup, the page that already written to backup image may be changed during backup, therefore it request rollforward
if you cannot provide the logs to rollforward to bring the database to consistent point, you cannot use the database
那没有办法恢复出这部分数据了？
not really, if you don't have the log files
the only way is calling IBM，and let them patch the control file，
then you can connect to database, and you need to export data for ALL tables, and drop the database, create new db, import data
以后发帖提问后可以qq我，那样解决速度会更快一点！
qq联系方式在页面最下方。 收起
非常抱歉今天才给你回复！我请教了一个专家，解答如下，你看看对你有没有帮助。
not really
because when you do online backup, the page that already written to backup image may be changed during backup, therefore it request rollforward
if you cannot provide the logs to rollforward to bring the database to consistent point, you cannot use the database
那没有办法恢复出这部分数据了？
not really, if you don't have the log files
the only way is calling IBM，and let them patch the control file，
then you can connect to database, and you need to export data for ALL tables, and drop the database, create new db, import data
以后发帖提问后可以qq我，那样解决速度会更快一点！
qq联系方式在页面最下方。 收起