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

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
  1. 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
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google