Include logs in online backup (As of DB2 8.2)

February 15, 2005

db2 BACKUP DB “dbname” ONLINE TO “backupdir” INCLUDE LOGS

Above command includes the logs required to restore the database and bring back the database to a consistent point.

And to restore

db2 RESTORE DB “dbname” FROM “backupdir” LOGTARGET “logdir”

ROLLFORWARD DB “dbname” TO END OF LOGS AND STOP OVERFLOW LOG PATH “logdir”

To restore just the logs from the backup image

db2 restore db “dbname” logs from “backupdir” logtarget ‘logdir”

posted in DB2 by Visu

Follow comments via the RSS Feed | Leave a comment | Trackback URL

1 Comment to "Include logs in online backup (As of DB2 8.2)"

  1. Daniel wrote:

    Hello,

    Even if I am not very good expresing myself in writing, I really like when someone is able to put in words simple and clear concepts the way you are doning it…

    I’m working on a data storage site. It is not easy to find good content for data storage websites but I try to do my best…I also have a blog there

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org