I would also suggest (in a world somewhere between ideal and 'cheapest') using Veritas NetBackup with the Block-Level Incremental extension for Oracle. This is really nice for saving on tape costs and backup time - it performs incremental backups of your datafiles on a block level (thus the name), meaning that in a large but moderately static datatabase only your full backups will be huge.
I would also recommend (closer to the ideal world), a (as many as you can afford)-head LTO based jukebox system so that you can stream your data to multiple drives simultaneously. In a perfectly ideal world, I would also agree with Rachel's advice to use SRDF for box-to-box storage mirroring, but even with that nothing replaces having long-term storage on tape (for example, SRDF does _not_ prtoect you against block-corruption if you do it close to real-time, is infinitely (100+ times) more expensive than tape, gig for gig, and doesn't allow for multiple versions (unless you have a bunch of extra arrays lying around, see caveat 2 regarding $'s) George ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 11:20 AM > thanks a lot Kimberly ! > > DBAndrey > > * 03-9254520 > * 053-464562 > * mailto:[EMAIL PROTECTED] > > > > -----Original Message----- > Sent: Wednesday, January 02, 2002 5:35 PM > 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: 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: 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).
