Results 1 to 4 of 4

Thread: Backup time

  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: Backup time

    UDB ver 8.1.3 on SP2/AIX.

    We are planning to have backup strategy for our database server.
    The database is currently 200 GB. How much time does it generally take to ONLINE backup the database on disk / tape?

    Also will offline backup be faster than online?

    Thanks,
    toby

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Backup time

    There is no way to tell the exact time as there are lot of variables involved but the online backup of our database (size 280 GB) takes around 8 hours.

    dollar

    Originally posted by toby25
    UDB ver 8.1.3 on SP2/AIX.

    We are planning to have backup strategy for our database server.
    The database is currently 200 GB. How much time does it generally take to ONLINE backup the database on disk / tape?

    Also will offline backup be faster than online?

    Thanks,
    toby

  3. #3
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Backup Strategy

    Hi,

    Whether to go for an Online Backup or Offline Backup entirely depends on your environment and the policies of your IT department.

    Each of the method's has its own pro's and cons, what I suggest is that you first list down your requirements and then decide on what you need.

    We are currently proceeding with an Online Backup as the data is essentially critical to us and the copies of the logs are also mirrored to external disks for additional safety.

    HTH

    Nitin.
    HTH

    Nitin

    Ask the experienced rather than the learned

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Backup Strategy

    I feel it is more than the policies of your IT department ...

    The bakckup, recovery, DR and HA policies should all be dependent on the requirements of the core business the IT Infrastructure supports ... For eg. if you have an on-line store with customers worldwide, you do not want to bring down the system and hence you should do an online backup ... If your database is used for a 9-5 shop, yes , you may find a couple of hours to get into the offline mode ....

    You can have a look at the backup buffer size, numbuffers etc in your backup command to improve performance ... Your utliheapsz config parm also needs consdieration ... AFAIK, Using a tape, is a killer ... You may consider writing to disk and then backing up to tap



    HTH

    Sathyaram


    Originally posted by nitingm
    Hi,

    Whether to go for an Online Backup or Offline Backup entirely depends on your environment and the policies of your IT department.

    Each of the method's has its own pro's and cons, what I suggest is that you first list down your requirements and then decide on what you need.

    We are currently proceeding with an Online Backup as the data is essentially critical to us and the copies of the logs are also mirrored to external disks for additional safety.

    HTH

    Nitin.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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