RMAN backup retentions & policies - implementation and management
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN backup retentions & policies - implementation and management

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    RMAN backup retentions & policies - implementation and management

    I have some questions on RMAN backup retentions and policies.

    My requirements :
    Regular day to day backup retentions : 30 days
    Quarterly backups : 2 years
    Year end backups : 7 years
    All backups will be 'online' or 'hot'.

    My Questions :
    1) How do you (DBA's) typically manage deletion of backups (database, archivelogs, others) on a periodic basis? Do you let the backup tool (say Netbackup or Tivoli Data protection for example) take care of this by setting retentions there? Or do you setup RMAN scripts to do this? It appears that a lot of DBA's choose to do the latter..but I wonder why? Isn't it one less thing to do for the DBA, if s/he lets the backup tool/vendor take care of it? Yes, the recovery catalog will then be out of sync since it will indicate that certain backups (say 6 months ago) still exist, when it reality the tapes might very well have been reused after 30days by the backup tool/vendor. But then, can't you simply verify (or crosscheck), do a "delete expired" and resync the catalog instead?

    2) How do you typically manage quarterly and year end backup retentions? Do you set separate "retention policies" (with keep / nokeep cluases) for these and then issue a "delete obsolete"? How do you ensure that the backup software vendor doesn't automatically reuse these quaterly/yearly tapes?

    Thanks for your time. I greatly appreciate your inputs.
    - Anand

  2. #2
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    At my site it is policy that all retention must be managed by NetBackup due to off site vaulting etc. I think this is a shame because RMAN is very feature rich in this respect. We too have a requirement to maintain year end backups etc. and the retention on these is set to infinite in NetBackup.

  3. #3
    Join Date
    Oct 2002
    Posts
    807
    At my site it is policy that all retention must be managed by NetBackup due to off site vaulting etc. I think this is a shame because RMAN is very feature rich in this respect. We too have a requirement to maintain year end backups etc. and the retention on these is set to infinite in NetBackup.
    I'm not sure I understand. So how do you implement this? If all retentions are managed by Netbackup, how do you manage your catalog? I assume you have different retention requirements for daily,qtrly,yearly backups..and that not all of them are being set to "infinite" retentions. So how do you sync your catalog with what is actually available on tape? Do you set separate retention policies for each of these backups (daily,qtrly,yearly) and then cross check and delete the obsolete/expired ones?

    Thanks, Anand
    Last edited by Axr2; 04-19-2004 at 03:54 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width