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" <[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] > > > > 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: Mercadante, Thomas F > > 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). > > > __________________________________________________ > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle 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: Loughmiller, Greg 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).