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).
Received on Wed Jan 02 2002 - 12:17:10 CST
