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).
