RE: VLDB backup policy

check out SharePlex for Oracle. The target system is completely open and available while it is applying the changes from the source.  If you are expecting < 25 GB of redo generation per day, it will usually be under 15 seconds latency.  And it's a LOT cheaper than the hardware solutions.   (not to mention nicer to the network too)

-----Original Message-----
From: Loughmiller, Greg [mailto:GLoughmiller_at_presolutions.com] Sent: Wednesday, January 02, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: VLDB backup policy

It works really well for a DR site though!!

Greg

-----Original Message-----
Sent: Wednesday, January 02, 2002 2:20 PM To: Multiple recipients of list ORACLE-L

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
> >
> > 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: Mercadante, Thomas F
> >   INET: NDATFM_at_labor.state.ny.us
> >
> > 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).
>
>
> __________________________________________________
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: schlossnagle_at_pythian.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: Loughmiller, Greg
  INET: GLoughmiller_at_presolutions.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).