Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Disaster Recovery for datawarehouse
In my opinion, there is no definitive answer.
The recoverability of a DWH is depended on business requirements and
the amount of money which that implicates.
Various extreme cases I encountered come to mind: -I remember a datawarehouse at a bank which didn't got backuped because all the data was re-extractable from the sources (and the actions in the DWH weren't business critical) -I also remember a business critical database which was DG'ed (dataguarded) to be able to go on within reasonable time in case of H/W failure (reasonable here meaning minutes). Yes, we've had to fight with business not to get data not being loaded using direct path. Also the decision was made to make a weekly full backup, other days incremental backups. At the standby database.
frits
On Nov 20, 2007 4:24 PM, hrishy <hrishys_at_yahoo.co.uk> wrote:
> Hi Dennis
>
> Thanks for taking time out and responding.
>
> In many systems what i have seen is the EDW is huge
> and they just cannot afford to do without nologging
> operation
>
> For management disaster recovery means when the
> building blows up we start operating from another
> country and we start working .
>
> With these kind of systems in mind when the
> interviewer persisted with dataguard option i
> explained to him dataguard means frequently recreating
> the standby becuase of the nologging operations.
>
> I was more on the expensive things like EMC Symetric
> technology or any kind of storage based replication.
>
> Let me see if i get the job offer :-).
>
> But i would be very happy to see what the experts
> think here are there any other solutions apart from
> storage based replication
>
> regards
> Hrishy
>
>
>
>
> ____________________________________________________
> Which email service gives you unlimited storage?
> http://uk.mail.yahoo.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 20 2007 - 10:23:41 CST