RE: rman incremental backups vs. full backups
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'ryan_gaffuri@xxxxxxxxxxx'" <ryan_gaffuri@xxxxxxxxxxx>, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Nov 2004 15:32:17 -0500
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@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, November 10, 2004 3:19 PM
To: 'ryan_gaffuri@xxxxxxxxxxx'; 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@xxxxxxxxxxx]
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?
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
