Re: rman policy

From: Mike Schmitt <mschmitt_at_uchicago.edu>
Date: 2005-12-23 19:09:33
Message-id: 6.1.2.0.2.20051223115734.04918148@imap.uchicago.edu

You can have your script check the date, on the first Saturday of the month use the RMAN keep until parameter like the following

backup database keep until time 'sysdate+1095' ...

If this is a hot backup, then you will need to provide the logs keyword. This causes some issues because when you give the logs keyword, RMAN then wants to keep 1095 days of archive logs in the catalog and not expire them. If you use a cold backup, then you do not need to provide the logs keyword and you can avoid this.

I believe someone else mentioned that you can manually remove the 1095 days of archive log backups from the catalog manually (the ones you do not want to keep records of), I am not sure and you will need to test it yourself. Received on Fri Dec 23 2005 - 19:09:33 CST