absolutely true -- but if they want "instant" recovery, then this will
handle hardware failure
- George Schlossnagle <schlossnagle_at_pythian.com> wrote:
> One problem with SRDF though is that it doesn't protect against block
> corruption. SRDF is really really cool, but is not a complete backup
> plan
> in and of itself.
>
> George
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, January 02, 2002 12:48 PM
>
>
> > The problem is, most business users say "5 minutes" (and btw, the
> emc
> > srdf option is actually faster than a hot standby, since a hot
> standby
> > might need log files to be applied while the mirroring does not --
> > check out Lawrence To's papers)
> >
> > so you go ahead and figure out what a "5 minutes" scenario costs
> and
> > then they say "no way, it's too expensive".. but they still want "5
> > minutes"
> >
> > It doesn't hurt to give them all their options and let them do the
> > "time vs money" decision.
> >
> >
> > --- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us> wrote:
> > > Andrey,
> > >
> > > I think that you are looking at this problem from the wrong end.
> > > Rather
> > > than come up with backup scenarious first and reporting back to
> > > management,
> > > I think you need to get managment to declare to you their "Mean
> Time
> > > to
> > > Recovery". By this I mean that they need to tell you how long
> they
> > > can
> > > survive without a database before it begins to affect their
> > > operations.
> > >
> > > Depending on their answer, it drives your research in certain
> > > directions.
> > >
> > > If they say "10 minutes", you have no choice but to have a
> > > hot-standby
> > > database running.
> > >
> > > If they say 1 hour, you could use EMC/mirror disk options (like
> > > Rachel just
> > > mentioned).
> > >
> > > If they say 24 hours, then RMan backup/restore from tape
> (probably
> > > the
> > > cheapest solution) would work for you.
> > >
> > > Kimberly's suggestions are very good if you are following the
> Rman
> > > scenario.
> > >
> > > Hope this helps
> > >
> > > Tom Mercadante
> > > Oracle Certified Professional
> > >
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, January 02, 2002 10:35 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > You could split off a mirror and backup the mirror however, I
> have
> > > never
> > > done that so I am not going
> > > to get into it. I know there are others in the list who have
> done it
> > > for
> > > their backup strategy.
> > >
> > > Keep in mind that if you are running in archive log mode you need
> not
> > > backup
> > > every data file at the
> > > same time. This would be your cheap end solution. Make sure you
> > > have
> > > enough disk to deal with
> > > your archive logs (depends on how much you want to keep on disk).
> I
> > > would
> > > place objects in tablespaces
> > > based on usage rather then size or functionality. In other
> words, if
> > > you
> > > have a bunch of tables that
> > > have very little data changed or data that does get changed does
> so
> > > infrequently then place them in
> > > the same tablespace. If you have tables that have change
> constantly
> > > then
> > > keep them together. Granted
> > > you may end up with more then one tablespace per change type but
> > > don't mix.
> > > Then schedule backups
> > > of those tablespaces more frequently then others. Try and get
> the
> > > full
> > > backup done by the end of
> > > the week for all tablespaces. Keep in mind that the control file
> and
> > > other
> > > stuff need to be backed up
> > > as well.
> > >
> > > Your recovery is going to be a little more complicated this way
> and
> > > time to
> > > recover is going to be
> > > longer but if you get the frequently changed tablespaces more
> often
> > > then it
> > > should not be too bad.
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, January 02, 2002 6:50 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dear list !
> > > I'm reposting this , since got no replies yet.
> > >
> > > I need to design a backup policy for a VLDB sized some 10TB,
> running
> > > as close to 24X7 as possible.
> > > I need 2 versions of the policy:
> > > One is the "best case" , i.e. money does not matter, the company
> can
> > > aquire
> > > any software / hardware , the only goal is to have a solid backup
> and
> > > ability to backup and recover as fast as possible.
> > > The second is the opposite case - how to achieve a good backup
> > > spending as
> > > little money as possible, possibly tolerating a little more
> downtime
> > > in case
> > > of a crash.
> > >
> > > I just have never happened to work with 10 Terrabytes size of DB,
> in
> > > particular ,i believe that my proven backup strategies that work
> well
> > > with
> > > 100GB DB might need some amending when it comes to 10 TB size.
> > >
> > > Another constraint is that i'm limited to Oracle 8.1.7 , and can
> not
> > > upgrade
> > > to 9i.
> > >
> > > I need to decide which hardware/software needs to be
> > > purchased/evaluated to
> > > implement solid DRP and HA.
> > > People say : EMC , Veritas , Legato etc...
> > > I'm just lost among these (and many others) buzzwords and need a
> > > "Second
> > > opinion" from gurus, like you.
> > > Please share your experience and thoughts.
> > > Thanks a lot in advance !
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Andrey Bronfin
> > > INET: andreyb_at_elrontelesoft.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > > San Diego, California -- Public Internet access / Mailing
> > > Lists
> > >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You
> may
> > > also send the HELP command for other information (like
> subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Kimberly Smith
> > > INET: ksmith2_at_myfirstlink.net
> > >
>
=== message truncated ===
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jan 02 2002 - 14:32:42 CST
