Re: [Networker] Why Oracle incremental backup is as large as a full?

AND significantly reduce the I/O load of those incrementals.

---
W. Curtis Preston
Author of O'Reilly's Backup & Recovery and Using SANs and NAS
VP Data Protection
GlassHouse Technologies


-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Uwe Weber
Sent: Thursday, May 03, 2007 3:11 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] Why Oracle incremental backup is as large as a
full?

Preston de Guise schrieb:

> I always followed their instructions, and always got proper
> full+"incremental" backups. One thing of course is that while the
> "incremental" is usually much smaller than the full, many of my
> customers have found that it takes almost as long as the full, and is
> more intensive on database processing than the full, due to the
> tablespace scans that have to be done.

If you are backing up Oracle 10, you could ask your
DBA to enable Block Change tracking. This will
speed up incrementals a lot. 

Regards,
uwe

To sign off this list, send email to listserv AT listserv.temple DOT edu and
type "signoff networker" in the body of the email. Please write to
networker-request AT listserv.temple DOT edu if you have any problems with this
list. You can access the archives at
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER