RE: Difference Between RMAN Incremental and Full Backups - Driving me Nuts!

From: Allen, Brandon <>
Date: Thu, 17 Jul 2008 09:49:45 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C450C968046@NT15.oneneck.corp>

I have been running incremental backups on AIX5.3 with CIO for years now and haven't had any problems, but I'm also running database and Netbackup, so not exactly the same setup. In 10g, you don't have to mount the filesystems with the cio option - you just set filesystemio_options=setall and then Oracle opens the datafiles with the CIO flag.  

I found bug 4034775 on Metalink which talks about some performance problems with backups on AIX and they suggest setting AIXTHREAD_SCOPE=S so you might want to try that if you haven't already. I do have it set in my environment.  

I don't have any idea why the full would run so much better than the incremental. Did you try implementing the block change tracking file? Any improvement from that? It should dramatically reduce the number of disk I/Os required for the incremental backup and in my case it reduced my backup runtime from about 2 hours to 2 minutes.  


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Thu Jul 17 2008 - 11:49:45 CDT

Original text of this message