Change the RMAN Backup TAG Retention Policy Using Change Backup .. Keep Command

advertisements

_____________________________________________________________________________________________________________________

Connect to RMAN.

RMAN> list backup summary;

List of Backups

===============

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

1492833 B  0  A DISK        25-OCT-11       1       1       YES        PROD_WEEK_BKUP

1492874 B  F  A DISK        25-OCT-11       1       1       NO         PROD_WEEK_CTRL

1. To keep the backupset/TAG for ever.

RMAN>  CHANGE BACKUP TAG ‘PROD_WEEK_BKUP’ Keep forever;

using channel ORA_DISK_1

keep attributes for the backup are changed

backup will never be obsolete

backup set key=1492833 RECID=690 STAMP=765612663

2. To Keep the backupset/TAG for certain period of time say 15 days

RMAN>  CHANGE BACKUP TAG ‘PROD_WEEK_BKUP’ Keep until time 'sysdate+15';

using channel ORA_DISK_1

keep attributes for the backup are changed

backup will be obsolete on date 12-NOV-11

backup set key=1492833 RECID=690 STAMP=765612663

_____________________________________________________________________________________________________________________

Website Stats