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.
No comments:
Post a Comment