Re: Disaster Recovery for datawarehouse
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx, adar666@xxxxxxxxxxxx
- Date: Wed, 21 Nov 2007 08:53:15 +0000 (GMT)
Hi Niall
Thanks for responding..
I asked about this question in other forums too..
And one of them suggested that applying incremental
backups to image copies from 10.2 onwards
And i think that is a more viable answer provided the
client is willing to load probably one days worth of
data into that remote host and start running his ETL
processes from there..
What do you guys think on this approach.
regards
Hrishy
--- Niall Litchfield <niall.litchfield@xxxxxxxxx>
wrote:
> It really all comes down to business and
> availability requirements
>
> On Nov 20, 2007 11:12 AM, Yechiel Adar
> <adar666@xxxxxxxxxxxx> wrote:
>
> > You have to make a difference between 3 types of
> DR:
> > 1) Hardware failure, the server blew a gasket.
> > Use RAC.
>
>
> or keep a fresh stock of gaskets. or have a
> replacement agreement with a
> gasket manufacturer.
>
> 2) Database failure, someone erased some data files.
> > Clone the database.
> >
>
> oops they erased the backup as well and the tape
> drive has always been a bit
> dodgy - better get last weeks tape back.
>
>
>
> > 3) Site failure, Katerina has entered the
> building.
> > Use storage with remote online copy to another
> site many miles away.
> >
>
> the ceo/cfo/dba are all dead. the customers are
> largely dead. Does anyone
> actually care any more. Or can it all wait until the
> more important issues
> are resolved.
>
> Ok so all of my examples are tongue in cheek, but
> they all *might* be
> perfectly viable options (especially for a decision
> support system such as a
> DW).
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
____________________________________________________
Which email service gives you unlimited storage?
http://uk.mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
