Considerations for DB2 Online backup and offline backup

Source: Internet
Author: User
Tags db2

The difference between DB2 online backup and offline backup

1 The general default to establish a DB2 database is not supported online backup (in the DB2 Control center)

If you want a DB2 database to support Online backup, update db CFG for sampledb using Logretain=on serexit=on,trackmode=on

2 If a DB2 database supports both online and offline backups, be careful when backing up, and if you want to do an online backup, you must copy the logs separately. Otherwise, it cannot be rolled back and cannot be used.

(Of course, if it's done on the same machine, there is no need to handcuff, in the recovery after the rollback, directly assigned to the source database log path can be, but also pay attention to time constraints, a long time, in the online backup point of time that the log may be covered by a new log file and does not exist.

(This, SQL Server is better, online backup directly to the log file and database body into a file, without the need for a separate copy), if it is offline backup, you do not need.

3 offline backup after recovery, plus the parameter without rollforward ...

4 After online backup, must rollforward to ....

5 Force Application Stop command is actually not related to offline backup/online backup.

------------------------------------------------

To this end, let the customer back up, she got an online backup, but no log, the result is hurt to go back to the customer there ran a trip .... Miserable.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.