Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1092406609.341901_at_yasure>...
> Rob De Langhe wrote:
>
> > Hi,
> >
> > we are interested to know what DBAs have selected as realistic recovery
> > (and corresponding backup) strategy for a database with multiple
> > terabytes of data.
> >
> > Internet talks everywhere about backup performances, but nowhere the
> > actual recovery method is discussed for such a large database. Even when
> > doing online backups, you still need a way to get this huge dbase back
> > into a consistent mode, or get a set of data backup in the dbase.
> >
> > We are using Solaris-9, Oracle 9.2, SAN storage, Veritas Netbackup, and
> > LTO tape robot.
> >
> > TIA for any suggestions
> >
> > Rob
>
> Get a duplicate storage array likely NetApp, EMC, Hitachi, or IBM and
> use the snap-mirror capability to mirror changed blocks to the second
> array. Be sure the duplicate array is at least 500 miles away from
> the primary and connect them with a T3.
>
> Then don't waste your time backing up anything.
Dan:
Pardon my ignorance, what happends if something got corrpted, you
accidently deleted some data/table or for whatever reaosn you have to
do point in time recovery. How will one accomplish that using
snap-mirror type of backups.
Received on Fri Aug 13 2004 - 17:02:15 CDT
