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

that's it.

Thanks Jared.

Pat.

-----Original Message-----
Sent: Friday, February 21, 2003 2:34 AM
To: Multiple recipients of list ORACLE-L

Not necessarily. If you're backing up vxfs with Veritas Netbackup and also have someother component from Veritas that I can't recall at the moment, filesystem incrementals are made at the FS block level.

You only backup new blocks, or blocks that have been touched.

Jared

On Wednesday 19 February 2003 12:09, Nelson, Allan wrote:
> Actually assuming you checkpoint or commit at least once between backups
it
> would not make any difference at all. An incremental backup catches
> changed files since the last backup which will typically be all your data
> files. SCN's get updated in all headers if any thing changes.
>
> Allan
>
> -----Original Message-----
> Sent: Wednesday, February 19, 2003 1:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Jared Still
  INET: jkstill_at_cybcon.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: 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).