RE: VLDB backup policy

What type of application is it (OLTP, DSS, mixed, etc.)?  Also, is it monolithic or can the functionality be broken down into usage profiles (i.e. mostly read, high velocity update, etc.)?

-----Original Message-----

From: Andrey Bronfin [mailto:andreyb_at_elrontelesoft.com]

Sent: Wednesday, January 02, 2002 9:50 AM

To: Multiple recipients of list ORACLE-L

Subject: VLDB backup policy

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