冷备份 db2 backup db donggua to /opt/db2backup/

db2 rollforward db donggua to end of logs and complete


热备份 [db2inst1@oracle db2backup]$ db2 backup db donggua online to /opt/db2backup/

Backup successful. The timestamp for this backup image is : 20100424144815


增量备份 db2 => backup db donggua online incremental to /opt/db2backup/

Backup successful. The timestamp for this backup image is : 20100424145713






恢复之前，用db2ckbkp 检查将要用来恢复的文件，看看是在线备份还是离线备份。离线备份，恢复时可以用without rolling forward,在线备份不可以。

使用完全备份来恢复
[db2inst1@oracle db2backup]$ db2 restore db donggua from /opt/db2backup/ taken at 20100424144815
DB20000I The RESTORE DATABASE command completed successfully.


[db2inst1@oracle db2backup]$ db2 rollforward db donggua to end of logs and complete

Rollforward Status

Input database alias = donggua
Number of nodes have returned status = 1

Node number = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = S0000049.LOG - S0000049.LOG
Last committed transaction = 2010-04-24-06.48.21.000000 UTC

DB20000I The ROLLFORWARD command completed successfully.




使用增量备份来恢复
[db2inst1@oracle db2backup]$ db2 restore db donggua incremental automatic from /opt/db2backup/ taken at 20100424145713
[db2inst1@oracle db2backup]$ db2 rollforward db donggua to end of logs and complete