RE: Veritas Agent for Oracle / incremental backups vs. hot backup

Patrice,

The redo writes and redo blocks written (from a Statspack snapshot between two periods when backups would have taken place) _may_ give you an indication, as I believe 'updated' blocks are backed up in an incremental.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my future!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Sent: Wednesday, February 19, 2003 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Veritas Agent for Oracle / incremental backups vs. hot
> backups
>
>
> The difference in size depends on how much your data changes.
>
> If the percentage of inserts/updates/deletes is relatively small, then
> the backup time will decrease dramatically.
>
> As someone else has pointed out, you will repay those time savings
> at restore time. With small incrementals, the time to
> restore the backup
> files may be insignificant next to the time required for the
> tape library
> to load the tape and locate the additional backup files.
>
> Jared
>
>
>
>
>
>
> "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> Sent by: root_at_fatcity.com
> 02/19/2003 11:24 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Veritas Agent for Oracle /
> incremental backups vs. hot backups
>
>
> 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:
> INET: Jared.Still_at_radisys.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).