Thanks Hrishy,

Please see my comments below your suggestions

1 Consider changing RMAN RETENTION POLICY.
If you are using Data Guard,then consider changing RMAN ARCHIVELOG DELETION POLICY.

If we decrease the RMAN retention policy from 14 days to say 2 days then all the backups older than 2 days will be deleted from the O/S (which is fine) but then they also will be deleted from the recovery catalog which is not fine as the backups are available on tapes for upto 14 days and we would need the ability to restore/recover from them.

2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.


Unfortrunately this would not be possible as the tape backup strategy is a part of the officeiwse strategy which backups up other things in addition to the databases.

3. Add disk space and increase db_recovery_file_dest_size parameter to reflect the new space.

The db size is 200G. To have 14 days worth of backups on disk I would need 14*200G

4. Delete unnecessary files using RMAN DELETE command. If an operating system command was used to delete files, then use RMAN CROSSCHECK and DELETE EXPIRED commands.

Issue same as #1

I would be very greatful if others can also chip in with their thoughts. I am sure someone might have a similar setup as ours.

Jeff, Tamil, Tarry, Tim anyone please