Hello Oracle DBA community,
How are you doing ?
I have a doubt with RMAN Retention policy, and the documentation didn't answer.
-> I am using Oracle Database 11.2.0.4 Enterprise Edition, with Tivoli Storage Manager (TSM) to store the backups in SBT TAPES.
For years we're using this retention policy:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
But now, we must delete all backups older than 1 year from TSM.
I read about rman retention policy feature and understood i should have to set a new retention policy to CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 365 DAYS;
However, when i use "report obsolete" after changing this retention policy expecting the output would be backups from last year i got this:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 365 DAYS;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 365 DAYS;
new RMAN configuration parameters are successfully stored
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 365 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 86307 27-01-19 14:44
Backup Piece 86307 27-01-19 14:44 dbtocq1q_1_1
Backup Set 86309 27-01-19 15:29
Backup Piece 86309 27-01-19 15:29 ddtocsmt_1_1
Backup Set 86311 27-01-19 16:44
Backup Piece 86311 27-01-19 16:44 dftod12u_1_1
Backup Set 86313 27-01-19 17:37
Backup Piece 86313 27-01-19 17:37 dhtod46m_1_1
Backup Set 86376 28-01-19 18:41
Backup Piece 86376 28-01-19 18:41 bkp_database_dia_inc_BDTDSPM_86511_1_998764879
Backup Set 86377 28-01-19 18:42
Backup Piece 86377 28-01-19 18:42 bkp_database_dia_inc_BDTDSPM_86513_1_998764894
Backup Set 86378 28-01-19 19:00
Why those backups from 11 days ago show up in my report ?
Did i choose the wrong rman feature to do this ?
Thanks & Regards,