Terrabyte DB backup time inputs needed - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Terrabyte DB backup time inputs needed

  1. #11
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Hrishy ,
    If you maintain 1 TB Database, then you should backup the database on to disk first, then to tape.

    Where do you backup first?

    Tamil

  2. #12
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Tamil

    Yes we do backup on to disk first on a staging area..

    regards
    Hrishy

  3. #13
    Join Date
    Jun 2003
    Posts
    108
    Dear Nagarjuna,

    Can i have ur maild, Since i am a chennai guy I would like to talk
    to you something regarding on backup and recovery strategy.

    It would be great if u give me ur id.

    Thanx in advance.

  4. #14
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Hrishy,

    How much money can you afford for backing up 1 TB DB?
    Depnding upon your spending capacity, I would offer some tips.

    Tamil

  5. #15
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Hmmm, don't know if this will help but here it goes.
    I had a 1.5t database on a Dell power edge with Linux. Used Netbackup with RMAN interface and went directly to tape via hot backup. It took 6 hours.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #16
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Tamil

    Budget is not a constraint.we need to prepare a case study to put in a comprehensive case study..I am looking for a backup windo of less then 3 hours..probably SAN environment would be what i am loking for..and also put some data in readonly tablespace mode..

    Tamil your tips would be more then welcome..

    oracle Doc..its cool that your bnackup of 1.5T completes in 6 Hours..Just wundering if you could teel mee more about your environment like cpu power memeory and bandwidth of the attached tape drives.

    regards
    Hrishy

  7. #17
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    TJI:
    We have a couple of 1TB and 2TB databases. The main issue we have is with the i/o bandwidth to the tape drives. Using 3-4 channels, the 2TB database takes 12-15 hours to back up.

    We are using both the BCV/mirror split approach and the 'Lots of Read Only' approach (depending on database.) The problem we have is the larger database doesn't have any read-only data. What we do is split out 1 set of a triplex mirror and mount them on a different server so that the files can be copied effectively without taking the database down. (Actually, it does come down for about 20 minutes to get the mirror set, but it is at 4am when no-one is around anyway--our window is 4am to 6am for maintenance.) It takes longer (we don't have as many channels) but there is effectively no down time. This is the BCV type approach (today).
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  8. #18
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Hrishy,

    Here are my suggestions:
    1 Have Enough money ( around $1M) :
    Go for EMC Disk Arrays and BCV Timefinder. In this setup, BCV will write the data on both disks (primary and secondary) which is transparent to oracle. You can do backup from 2nd Mirror without affecting the perf of primary disks. This is very expensive and effective because write is done at the hardware level.

    2. Limited Money.
    Buy SQLBacktrack product from BMC. This is the tool I used extensively. Configure your backup devices (disks) under separate controllers. Disable read ahead cache and enable write cache on the backup devices. The important point is not sharing the controllers between your oracle datafiles and backup disks. Stripe across 8 disks. I would prefer stripe size of 1MB per disk (or even more). Create 24/32 pools. After the backup is done, the backup disks can be BCVed to another set of disks that can be read by the Tape Backup software (Netbackup or Tivoli etc). This is the setup I use. The impact on DB is almost zero.

    3 No Money.
    Do not run oracle db.

    Tamil

Posting Permissions

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


Click Here to Expand Forum to Full Width