Disaster Recovery for datawarehouse

[hrishy]

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

[jhmartin]

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.

[hrishy]

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

[Bore]

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

[hrishy]

Hi

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

regards
Hrishy

[jhmartin]

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.

[hrishy]

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