// ]]>

Sunday, 5 January 2014

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

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.