Re: Veritas Agent for Oracle / incremental backups vs. hot

Patrice,

Another list participant may verify or nullify this, but I think that both will take the same space/time. In either case, it should be backing up the entire datafile. Doing incremental backups with RMAN stands a good chance of saving you space/time as it can back up only changed blocks. If Veritas agent is working in conjunction with RMAN for block level incremental, it will likely be your better bet. (Then, of course, 'it depends' on how many block changes from one incremental to the next.) Hope this helps a little.

Darrell Landrum

>>> BoivinP_at_mar.dfo-mpo.gc.ca 02/19/03 01:24PM >>>
My manager asked me to assess how much smaller our backups would be if we were doing incremental backups of our database files, instead of the usual hot backups.

We are running 8i on UNIX.

I know that the answer is "it depends" and "you can't really know 'till you try", but we are just looking for a ballpark figure, perhaps in percentages.

Our databases are between OLTP and DSS, closer to DSS environment, this being a scientific site.

Thanks.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Darrell Landrum
  INET: DLANDRUM_at_zalecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).