Results 1 to 7 of 7

Thread: multi-tB backup

  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: multi-tB backup

    How Do We Take Big Backups Like Multiple Of Terra Bytes?
    Any Strategy Recommendation?

    Tia

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How Do We Take Big Backups Like Multiple Of Terra Bytes?
    To 3.5" floppies (LOTS of them)!
    or just run on RAID and don't worry about backups; since you'll never have a disk failure
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    best way to manage it

    thanks for your ans.
    but if you need to take ,can you tell/point the best way or policy to manage big backups ? faster ?
    TIA.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >faster ?
    Use RAM disk!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by udbdb2
    thanks for your ans.
    but if you need to take ,can you tell/point the best way or policy to manage big backups ? faster ?
    TIA.
    a) incremental or delta backup
    b) tablespace-level backup
    c) split mirror
    d) replication
    e) any combination of the above

  6. #6
    Join Date
    Sep 2003
    Location
    NE Florida w/ view of co-workers
    Posts
    32
    My $0.02 -

    If you intend on backing up straight to tape, get 4 or more tape drives and use RMAN to allocate one channel for each drive. This way you can backup in parallel - and then restore in parallel if ever necessary.

  7. #7
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Boy, multi-TB is tough. It really depends on what type of database this is and the frequency of the data changes. If it is a DW, I'd do a level 0 right after I load the majority of my data and follow up with either level 1 or just archived redo logs.

    If this is an OLTP 24x7, I'd try to do a level 0 at least once a week and a level 1 daily. I'd probably backup to NFS mounted disk, unless I was on 10.2 (see http://marist89.blogspot.com/2005/10...54-part-i.html )

Posting Permissions

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