RMAN backup Keep until clause
Hello All,
I need quick help from everyone. Let me explain the architecture before i ask question:
OS Platform - AIX 6.1
DB Version - Oracle 10gR2 and above
DB Sizes - Minimum of 10GB to max 6TB
Backup Methods -
RMAN Backups with BCT(Block Change Track) feature enabled
Backup Location - Tape
Backup Policy - Weekend Full(Offline Backup) Backup and week days Incremental Level 1 Backups.
Retention - Sysdate+35
And the problem we are having is -
Now Customer asked to maintain one specific day Full backup to sysdate+90 as they require that backup to refresh non-production environment for testing/development purpose. That is for example, Full backups taken on 29/Jun and 30/Jun to store till sysdate+90.
I need quick help from everyone. Let me explain the architecture before i ask question:
OS Platform - AIX 6.1
DB Version - Oracle 10gR2 and above
DB Sizes - Minimum of 10GB to max 6TB
Backup Methods -
RMAN Backups with BCT(Block Change Track) feature enabled
Backup Location - Tape
Backup Policy - Weekend Full(Offline Backup) Backup and week days Incremental Level 1 Backups.
Retention - Sysdate+35
And the problem we are having is -
Now Customer asked to maintain one specific day Full backup to sysdate+90 as they require that backup to refresh non-production environment for testing/development purpose. That is for example, Full backups taken on 29/Jun and 30/Jun to store till sysdate+90.
0