I need design a Archivelog, Level 0 and Level 1 long-term retention backup strategy for Oracle 10g, It must be based in Rman with tapes.
¿Somebody could tell me what it's the best option to configure long-term retention backups in Oracle?, "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1825 DAYS;" It's posibble ?
Regards and thanks in advance
RECOVERY WINDOW is an integer so yes its possible. Does it make sense? Later My bad, this is Oracle 11 only ( the gavinsoorma link ) . Getting harder and harder to think about 10. Don't think I would use RECOVERY WINDOW.
I would let the tape backup system handle the retention of your rman backups.
Using crosscheck and delete expired commands you can keep the catalog current with the available backups on tape. Oracle 10
Keeping a Long-Term Backup: Example
http://web.njit.edu/info/oracle/DOC/backup.102/b14191/advmaint005.htm Oracle 11
If you want to keep 5 years worth of backups I might just use KEEP specific date using the UNTIL TIME clause :
keep until time 'sysdate+1825'
More info :
RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands
Edited by: mseberg on Dec 4, 2012 7:20 AM