How to fix the Oracle error RMAN-05039: One or more auxiliary set datafiles could not be removed?

In this post, you’ll learn more about the Oracle ErrorRMAN-05039: One or more auxiliary set datafiles could not be removed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05039: One or more auxiliary set datafiles could not be removed

Reason for the Error RMAN-05039: One or more auxiliary set datafiles could not be removed

There was an error while performing Tablespace Point-in-Time Recovery. Some of the restored datafiles had OMF names and were not deleted.

How to fix the Error RMAN-05039: One or more auxiliary set datafiles could not be removed ?

You can fix this error in Oracle by following the below steps

Manually remove the auxiliary set datafiles that were not removed.