Fwd: Disaster Recovery for datawarehouse

 Hirshy,

The safe answer is that you will provide DR that meets the user requirements. Of course, true DR depends a lot on the IT infrastructure, and such things as whether a remote DR site is made available, for example. DR is a field unto itself, populated by very expensive consultants who can talk intelligibly to senior managers. But maybe your interviewer really meant what is your database backup and recovery plan.

In reality, DR depends a lot on the DW load cycle and the DW criticality. For example I worked with a DW that had a weekly load cycle each weekend. It was backed up weekly and the load files were easily available on the source system. The users could easily do without the system for a few days. So the DR plan was rather simple.

    Some sites have DW that are continually updated from many sources and the corporation can't do without the system for more than an hour. The DR plan for such a DW might include a remote hot DR site. The DR plan for such a DW would be very similar to the DR plan for a mission-critical OLTP database. That would cost big bucks but the company might consider that worthwhile.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l