Re: Differential incremental backups - Do you really use them?

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Fri, 19 Mar 2010 16:00:29 -0700 (PDT)
Message-ID: <169631.60914.qm_at_web113211.mail.gq1.yahoo.com>

>> I am yet to appreciate the usefulness of incremental backups.
Imagine a very large database (say > 1PB).... imagine that the data in it changes (so no read-only tablespaces) and imagine you have to back it up. Still want to do full backups?

Imagine an environment where your daily backup takes 32 hours. Still want to do full backups every day....?

If you have a small database, then I can see why you might find incremental backups a bit excessive. If you have a larger environment, you might well find them a requirement.

RF

 Robert G. Freeman
Master Principle Consultant, Oracle Corporation Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON! OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex) Oracle Database 11g New Features (Oracle Press) Oracle Database 10g New Features (Oracle Press) Other various titles
Blog: http://robertgfreeman.blogspot.com

---

From: Pani Babu <panibabu.mail_at_gmail.com> To: oracle-l_at_freelists.org
Sent: Fri, March 19, 2010 6:09:15 AM
Subject: Re: Differential incremental backups - Do you really use them?

The incremental backup topic raises an interesting question for me. I am yet to appreciate the usefulness of incremental backups. I always use a periodic(daily or weekly) fullback and rely on archived logs for any restores. If you use incremental backups, do you use them just for large databases? I am curious to see how prevalent is the incremental in everyone's backup strategy.

Pani

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 19 2010 - 18:00:29 CDT