Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

rman delete obsolete but keeping reclaimable backups in FRA

Franck PachotMar 18 2015 — edited Jan 11 2016

Hi,

A configuration that is often use is:

-> backup to FRA which is local

-> backup the FRA to a remote destination (NFS mount point for example)

Obsolescence in FRA is automatically managed and we don't need to delete obsolete there.

Obsolescence in the remote destination has to be managed manually with a 'RMAN> DELETE OBSOLETE;' command.

My problem is that the 'delete obsolete' also deletes those that are obsolete in FRA. But I don't need that and if I have enough space in the FRA that it's better to keep older backups just in case we need them. They are reclaimable and will be deleted is more space is needed. But there is no RMAN syntax to do that.

What I propose is:

  • the 'delete obsolete' do not delete reclaimable files in FRA. we need to add 'FORCE' in order to do it.
  • or add a new syntax such as 'delete obsolete from destination '/...'; where we give the path where we want to delete obsolete. This is similar to the syntax used for 'backup recovery area to destination'

The first one is my preferred solution. There is no reason to delete reclaimable files from the FRA when we do not specify FORCE

Regards,

Franck.

Comments
Post Details
Added on Mar 18 2015
3 comments
730 views