Hello!
Consider the following scenario:
Oracle CDB DB named CDB01.
Oracle PDB DB named PDB01
Oracle PDB DB named PDB02
Oracle PDB DB named PDB03
Customer wants to backup PDB01 only once and keep it for 5 years. So, subclient is created pointing to PDB01 only. Full Backup is made, including logs. Consider January 1st as the backup date.
PDB02 and 03 need to be backed up daily. Then, a subclient is created, including PDBs 02, 03, CDB&ROOT and PDB&SEED (excluding PDB01). That sublcient is backed up with daily fulls. With 1 day retentions.
I noticed that the backups for CDB01 (excluding PDB01) which are daily made, with 1 day retention are not getting pruned. Day retention and forecast report states that the CDB01 jobs are required (LOG_ RULE) by the PDB01 job (which previously ran only once and will be kept for 5 years).
How to work around this situation?
PDB01 needs to be backed up only once in its life and be retained for 5 years.
PDBs 02 and 03, are backed up daily. And retention is only 1 day.
Regards,
Pedro