RE: rman incremental backups vs. full backups

Ryan,

Up to and including release 9.x, there really is not much benefit of taking an incremental backup in regards to run time. Oracle scans all the database objects anyway to backup the changes. The backup set size may be smaller (though I've never taken a look at it - I'm just happy that it works and I can verify the backup ran correctly).

According to Oracle, backups in 10g are much faster because they are tracking block changes with bitmaps so that when Rman runs, it only backs up the blocks that are marked as being changed during an incremental backup. This should be much faster.

Haven't tried it yet - don't have 10g installed anyplace.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Ryan [mailto:ryan_gaffuri_at_comcast.net] Sent: Wednesday, November 10, 2004 3:09 PM To: Oracle Discussion List
Subject: rman incremental backups vs. full backups

I believe I read somewhere that you should only take 1 full backup ever. I can't remember where. I just took an RMAN class from Oracle. The instructor said that she does not agree with this. If you have too many incrementals it increases the amount of time it takes to recover. What are some strategies that you use?
--

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

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 10 2004 - 14:15:22 CST