Hello,
our goal is to mark as 'archival backup' with NO EXPIRATION a PREVIOUSLY EXECUTED BACKUP still present in RMAN's recovery catalog.
I've changed the keep until option via 'CHANGE BACKUP TAG ........ KEEP FOREVER' but when I periodically execute these steps to maintain RMAN catalog and Netbackup Catalog our marked with 'keep forever' clause backups are marked as expired and than deleted:
allocate channel for maintenance type 'sbt_tape' ;
crosscheck backup of controlfile completed before 'sysdate-35';
crosscheck backup of archivelog until time 'sysdate-35';
crosscheck backup of database completed before 'sysdate-35';
delete noprompt expired backup of controlfile completed before 'sysdate-35';
delete noprompt expired backup of archivelog until time 'sysdate-35';
delete noprompt expired backup of database completed before 'sysdate-35';
I tried to change the syntax of the crosscheck and delete commands to avoid a date/time specification... just to keep the default (rman retention policy..) in this way:
allocate channel for maintenance type 'sbt_tape' ;
crosscheck backup of controlfile;
crosscheck backup of archivelog;
crosscheck backup of database;
delete noprompt expired backup of controlfile;
delete noprompt expired backup of archivelog;
delete noprompt expired backup of database;
but we've the same issue: backups marked with 'keep forever' option are delete anyway.
We use Netbackup as Media Manager. It's retention policy is 6 weeks: wider than the RMAN's one.
We use RMAN RETENTION POLICY set to RECOVERY WINDOW OF 30 DAYS;
We use control_file_record_keep_time= 35 days;
Thank you,
Silvio