This content has been marked as final. Show 2 replies
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.
Keeping a Long-Term Backup: Example
If you want to keep 5 years worth of backups I might just use KEEP specific date using the UNTIL TIME clause :
More info :
keep until time 'sysdate+1825'
RMAN KEEP FOREVER, KEEP UNTIL TIME and FORCE commands
Edited by: mseberg on Dec 4, 2012 7:20 AM