Hello All,
I need some clarification regarding Storage Policy retention configurations for DB2, and Oracle command-line backups initiated through DB2 and RMAN commands. Version - 11.40
My understanding is that Commvault currently manages command-line log backups based only on days-based retention and not cycle-based retention. By Cycle, I am referring to the complete database backup chain consisting of Full + Incremental/Differential + Log backups as part of a cycle.
My first question is whether the cycle retention condition is applicable to Incremental/Differential/Delta backups initiated through the command line. It appears that it may be, but the behavior is not entirely clear.
In the case of Oracle, the situation is even less clear because archive log backups are also classified as Incremental backups. As a result, it is difficult to determine whether these log backups follow cycle-based retention or are retained solely according to the days-based retention settings.
If command-line database backups cannot reliably utilize cycle-based retention and instead must rely on days-based retention, what would be the recommended retention settings for both:
- Command-line database backups
- Command-line log backups
Any guidance on the recommended retention configuration and best practices for this use case would be greatly appreciated.
