RMAN catalog maintenance
Date: Thu, 26 Jun 2014 16:11:50 -0600
Message-ID: <CAJzM94AAX=JNWxJMBdnqJ=Wgw-bJfsfffOpF-7TOQugk2MNWeQ_at_mail.gmail.com>
After our DBA team was cut in half during recent layoffs, I was tasked with simplifying our current backup strategy. We have a mixture of 10gr2 through 11gR2. Every database had its own catalog in production but lower environments had catalogs based on the database version. When I questioned this strategy last fall (shortly after I started), I was told this was necessary because a single catalog was too slow. Never got any details on what exactly was slow though. The multiple catalogs led to yet another schema, tables, scripts to collect all the backup information in one place for the daily report.
So I was tasked with consolidating this multitude of catalogs into two--production and lower environments. Consolidation has gone well so far. Backups are not taking any longer, I created an Apex report to pull the data from both catalogs into a single report (rather than the three we previously had.)
We have a catalog maintenance script that runs for each database. It crosshchecks and deletes expired backups. The databases don't run the script at the same time so there's less contention on the catalog.
Now my question:
I would like to ensure this script is as efficient as possible. I see the
following and was wondering if this is really an efficient script:
crosscheck backup completed between 'sysdate - 90' and 'sysdate - 35';
delete force noprompt expired backup completed between 'sysdate - 90' and
'sysdate - 35';
crosscheck backup completed between 'sysdate - 180' and 'sysdate - 91';
delete force noprompt expired backup completed between 'sysdate - 180' and
'sysdate - 91';
crosscheck backup completed between 'sysdate - 270' and 'sysdate - 181';
delete force noprompt expired backup completed between 'sysdate - 270' and
'sysdate - 181';
crosscheck backup completed between 'sysdate - 365' and 'sysdate - 271';
delete force noprompt expired backup completed between 'sysdate - 365' and
'sysdate - 271';
I'm double-checking, but to the best of my knowledge, we don't have any backups older than 90 days. Still, it seems inefficient to me to repeatedly do the crosschecks and deletes. What am I not understanding here?
Thanks for help/suggestions.
-- Sandy Transzap, Inc. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 27 2014 - 00:11:50 CEST