Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2007

    Smile Unanswered: differance between online and offline backup

    can one give general differances on online and oflline backup

  2. #2
    Join Date
    May 2007
    somewhere in dbforums
    The basic difference is during offline backups you cannot access your database.....whereas Online backups can run while the database is still in service,

    An offline backup assumes that no user or process is connected to the database except for the one performing the backup. Hence during offline backups no other user can access the DB
    Online backups require only that the tablespaces being backed up not have a user (other than the one performing the backup) connected to them.This is especially useful in a production environment where you cannot afford a downtime
    Last edited by nick.ncs; 07-02-07 at 04:05.

  3. #3
    Join Date
    Jun 2006
    big difference is also for the restore
    with offline backup : the database can be made available, even if the log files (created after the backup - for rollfoward) are not available
    with online backup : you need the log files, active at backup time to be able to make the database available;
    or you have to use include logs with the backup command to be able to leave the rollforward state of the restored database
    anyhow : also backup the log files
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts