RE: VLDB backup policy

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