ChannelDB2

Difference between full Online / online incremental / delta / offline database backup in db2 udb

Could you please post Difference between full Online / online incremental / delta / offline database backup in db2 udb ?

 

The difference that I know  :

 

Full online backup :  To take a full online backup at first the database configuration needs to be checked for the LOGARCHMETH1 is set or not.It needs to be set.

USEREXIT/LOGRETAIN should be ON.

In db2diag.log you can see whether the backup was full online or not. If it is full online backup it will say Started Online backup while you start the backup.By list history backup command also you can check the type of backup.This backup image is independent. Archive logs are required to restore the point in time database.

 

Online Incremental backup :  TRACKMOD should be ON to enable online incremental backup.

In db2diag.log you can see whether the backup was incremental online or not. If it is incremental online backup it will say Started Online incremental backup while you start the backup.By list history backup command also you can check the type of backup.A full online or offline backup is required to make a base database copy on which these incremental image can be added to restore point in time recovery.

 

Delta backup :  In case of delta backup every delta backup image is required to restore the database.

 

Offline backup :  It is a independednt backup.. Connections needs to be forced before starting the offline backup otherwise "Database is in use" error will come and backup will fail.

 

Regards,

 

Shubhrojyoti De

Kolkata

advance.db2.udb.dba.on.aix@gmail.com

09831509788

 

 

 

Views: 10447

Replies to This Discussion

The types of DB2 backup that can be created are mentioned below:

  • Full – all database is backed up.
  • Incremental – changes the data since the last full backup are backed up.
  • Delta – changes the data since the last full or incremental backup are backed up.

We, suggest you must always go for full backup whenever possible. Well, you can also go for incremental backups to save times because full backups take more time.

If you want to know more about DB2 Backup option then check out this - DB2 Backups of Data and Recovery

RSS

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service