Skip to main content
Delphix

Troubleshooting Failure of Oracle vCDB and Linked CDB Snapshot Deletion in Accordance with Retention Policy (KBA 5535)

 

KBA

KBA# 5535

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

Troubleshooting failure of vCDB and linked CDB snapshot deletion in accordance with retention policy

With certain versions of the Delphix Engine software, you may find that snapshots of vCDBs and linked CDBs are not automatically deleted according to the retention policy you have set, even after the related vPDB snapshots have been deleted. You cannot delete them manually, either, because CDBs have no timeflow view, and attempting to delete them using the Storage Capacity screen, the CLI, or the API fails with a message that "Snapshots of an Oracle multitenant container database cannot be deleted manually" and a suggestion to "Delete corresponding pluggable database snapshots instead."

Resolution

If no snapshots of a given vCDB or linked CDB are being deleted:

To start the automatic deletion of vCDB and linked CDB snapshots, apply a different retention policy to those databases. This will cause the retention policy enforcement process to start.

The issue described here is fixed in version 5.3.5.0, and later versions, of the Delphix Engine software. However, after upgrading an existing Delphix Engine to a version where the issue is fixed, you may still encounter it for CDBs linked or vCDBs provisioned before the upgrade, and the same fix will apply. 

If one CDB snapshot is being retained unnecessarily after each vPDB refresh:

Prior to version 5.3.4.0 of the Delphix Engine software, there is an issue that may prevent deletion of one CDB snapshot after a vPDB refresh, even when all of the snapshots from the previous vPDB timeflow have been deleted.

To resolve this issue, upgrade your Delphix Engine to version 5.3.4.0 or later.