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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 -- //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 -- //www.freelists.org/webpage/oracle-l