absolutely true -- but if they want "instant" recovery, then this will handle hardware failure
--- George Schlossnagle <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > === 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
