Disaster Recovery for datawarehouse
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Disaster Recovery for datawarehouse

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    Disaster Recovery for datawarehouse

    Hi

    Today i was in a interview and the interviewer asked me a tricky question on how to provide disaster recovery for Datawarehousing.

    would like to know how you guys do it.

    regards
    Hrishy

  2. #2
    At its core I don't see how this is different then any other db. I suppose you could discuss some backup optimizations based on the assumption that the data could be reloaded from the original sources, and possibly doing something with partitioning and read-only tablespaces such that historical data is only backed up once, but ultimately it all comes down to how fast you need to be able to recover and if you are willing to spend the amount it'll take to get you there reliably.

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Assuming finance is not a constraint what are the various options available with me.

    The questions sounds easy but in reality its not (practically speaking offcourse) .

    regards
    Hrishy

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well, there are thousands of options.
    In general, make an identical database at the disaster site and refresh it after each load. One may use transportable tablespaces, or insert/select via DB link or whatever
    Edit:
    Nothing is easy with the DWH systems, because of their huge size

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Thats not a feasible option since there are 100's of Jobs running and doing the load in nologging option.

    regards
    Hrishy

  6. #6
    Nightly incremental backups applied to image-copies on the remote host. However you'll lose up to a days worth of loading if the disaster occurs immediately before the backup occurs.
    Last edited by jhmartin; 11-20-2007 at 12:18 PM. Reason: Spelling

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Thanks for responding.

    Yeah thats a good idea nightly incremental applied to image copies over a remote site.

    Thanks very much wish i had thought about this in the interview.

    regards
    Hrishy

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