DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Data warehousing question

  1. #1
    Join Date
    Aug 2002
    Posts
    15

    Data warehousing question

    Hi,

    I am building a database which will house a data warehouse of about 200Gb.I have to order the disk for the backup of this.What should be the type of backup I should be doing.Is it

    a)RMAN backup
    b)Exports (? its too large ...to be exported daily)

    Kindly advice.

    Thanks,
    copernicus

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Forget exports -- it's not just the "backup" that will be slow, but the "restore" will take months. Import rebuild one index at a time, remeber. You'd be sitting there wondering why your system utilization is so low, and why the import seems to have hung up.

    RMAN is a pretty good choice.

    Also you could consider Transportable Tablespace exports, if large amounts of your data are going to be static.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    A couple of things to think about.

    1. export is not a good backup method for production.

    2. the number of backups might depend on the frequency of loads and the amount of history required.

    3. you might have some read only tablespaces with static data that do not need to be backed up after each load.

    good luck
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Consider BMC's SQLBACKTRACK. It is pretty good and fast.

    Tamil

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by tamilselvan
    Consider BMC's SQLBACKTRACK. It is pretty good and fast.

    Tamil
    How does it compare to RMAN?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Sqlbacktrack is way too expensive, BMC charges by MB/GB backed up and it's does not do more than RMAN does

  7. #7
    Join Date
    Aug 2002
    Posts
    15
    Thank you Guys ...I am going for cold backup....

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Why cold?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by Copernicus
    Thank you Guys ...I am going for cold backup....
    You have chosen the worst backup method possible (assuming that we all agree that export is not a "backup method" at all).....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by jmodic
    You have chosen the worst backup method possible (assuming that we all agree that export is not a "backup method" at all).....

    Yeah, i think we agree on all of that.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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