RE: rman incremental backups vs. full backups

What a mistake? If you only take one full backup (ever) think how much longer and more complicated restoring would be. I try to do full backups up until the point where my backup window simply won't work. Then I start considering incremental. =20

Another approach for a large data warehouse where most of your data may be only loaded once and never changed is to switch those tablespaces to read-only, perform a full backup (making sure to mark this tape) then to use the rman close not to backup those readonly tablespaces anymore. =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeremiah Wilton Sent: Wednesday, November 10, 2004 3:27 PM To: Ryan
Cc: Oracle Discussion List
Subject: Re: rman incremental backups vs. full backups

On Wed, 10 Nov 2004, Ryan wrote:

> I believe I read somewhere that you should only take 1 full backup=20
> ever. I can't remember where.

This doesn't make any sense to me. If you only ever took one full backup, you would have to apply all the incrementals thereafter in the event of a restore. Until at least 10g (?), incrementals don't save you anything but backup media. They take just as long and read just as much as fulls.

--
Jeremiah Wilton
Independent Oracle Professional
Oracle Certified Master
Disaster Recovery - Seminars - Technical Interviews
http://www.speakeasy.net/~jwilton
--
http://www.freelists.org/webpage/oracle-l


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
NOTE: This message was auto-learned as non-spam.  If this is wrong,
please correct the training as soon as possible.
Teach CanIt if this mail (ID 15412930) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D15412930&m=3Ddca1=
bd010
5d8
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D15412930&m=3Ddca1=
bd010
5d8
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D15412930&m=3Ddca1=
bd010
5d8
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

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