784786 wrote:First off, your concept of how long to keep the various backups is all wrong. You configure rman to specify either a recovery window or a level of redundancy. By far the most common is a recovery window. So say you specify a recovery window of 30 days. Whenever you run rman to take a backup, include a step to 'delete obsolete'. Then you are letting rman decide how long it needs to keep a backup.
I want to schedule the backups for my new oracle window server. Can some one help me how to write the proper scripts.
Following are the requirements.
1. Weekly Full DB Backup at every Friday (Retention Period: 1 Month)
2. Daily Incremental DB Backup (Retention Period: 1 Week)
3. Daily Archive Logs Backup (Retention Period: 1 Week), though I know their is nothing like retention period for archivelogs backups, however I want to keep 1 week backups in my disk alike backupsets for one weeks).
Or some variation of that. Do yourself a favor and read the backup and recovery manual about the variations and what they mean.
rman> backup archivelog all delete all input;
784786 wrote:As I said ealier, you let rman handle it. Yous specify in your rman configuration what you want the recovery window to be. Let's say you set it at 30 days. That means you want rman to retain any and all backups (full, incremental 0, incremental 1, archivelog) that could be needed to restore the database to any point within that 30 day period. When a particular backup set is no longer needed to recover to a date within that period, it is considered 'obsolete' and will be deleted when you issue the rman 'DELETE OBSOLETE' command.
My DB version is 220.127.116.11
And platform : windows 98
I asked my boss, it is not a good strategy to keep 4 to 5 full backups in a month, however he says, it is the requirement. Im only confused about Incremental level1 backup, how will i keep retention period for that, and How will my script removes the 1 week archive backup, I know how to deal with removing archives, but how can i put it in script to delete the 7 days archive backups.
Edited by: 784786 on Dec 6, 2012 10:15 PM