Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    20

    Unanswered: move big TB database

    What is the best way to movea big TeraByte db to another db instance.
    What is the best strategy to backup such db ( Rman/export)
    can we stripe any of above ?
    TIA

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What is the best way to movea big TeraByte db to another db instance.
    One byte at a time very fast.

    >What is the best strategy to backup such db ( Rman/export)
    The one that can be restored the quickest.

    >can we stripe any of above ?
    Stripes make me look fat. I prefer plaid.
    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
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    What is the best way to movea big TeraByte db to another db instance.
    If you want to clone the database, normally copying the first databases datafiles (while down) is the fastest. Do NOT do this without reading up on database cloning.

    What is the best strategy to backup such db ( Rman/export)
    RMAN, export's are useless, you can NOT use them for recovery.


    can we stripe any of above ?
    Striping is a hardware thing, NOT a function of the database. You answer me, can your hardware support raid?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    If you can do a BCV split then that would be the fastest.
    Otherwise I would do an rman full backup and restore that onto the new system.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2006
    Posts
    20

    striping

    Sorry for confusion!
    What i meant by striping means , can we create multiple export/RMAN files instead of one big TeraByte files?
    Thanks for everyone's response!

Posting Permissions

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