RE: rman incremental backups vs. full backups

Ryan,

I realized that I didn't really answer your question. We perform full Rman backups three times a week with incrementals in between. Because of what I said prior, there really was no reason to perform incremental backups. Of course, I am not backing up any warehouses where an incremental may help.

Again, according to Oracle, incrementals are the way to go with 10g and forward. I won't believe it until I see it.

Tom Mercadante
Oracle Certified Professional

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

From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Wednesday, November 10, 2004 3:19 PM To: 'ryan_gaffuri_at_comcast.net'; Oracle Discussion List Subject: 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
--

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