Once you say “YES” to the above confirmation, then it will start deleting those obsolete backups. RMAN retention policy is set to recovery window of 4 daysĭeleting the following obsolete backups and copies:īackup Piece 643 06-JUN-14 /rman-backups/dev-db/full_ojpa6ke3_787_1īackup Piece 642 06-JUN-14 /rman-backups/dev-db/full_okpa6ke3_788_1īackup Piece 682 05-SEP-14 /rman-backups/dev-db/full_qjphp6ug_851_1īackup Piece 685 12-SEP-14 /rman-backups/dev-db/full_qqpiblig_858_1ĭo you really want to delete the above objects (enter YES or NO)? YES RMAN retention policy will be applied to the command Once the crosscheck is done, it is time to delete the old obsolete backup using the DELETE OBSOLETE command as shown below. RMAN> CROSSCHECK BACKUP Ĭhannel ORA_DISK_1: SID=37 device type=DISKĬhannel ORA_DISK_2: SID=22 device type=DISKĬrosschecked backup piece: found to be 'AVAILABLE'īackup piece handle=/rman-backups/dev-db/full_okpa6ke3_788_1 RECID=642 STAMP=849564099īackup piece handle=/rman-backups/dev-db/full_qvpiu46h_863_1 RECID=686 STAMP=858722513īackup piece handle=/rman-backups/dev-db/full_r4pjgir0_868_1 RECID=687 STAMP=859327328Ĭrosschecked 46 objects 4. If there is an record in the RMAN catalog that is not available on the physical filesystem, it will make that entry with appropriate status. Perform RMAN CrossCheckīefore we start executing the delete obsolete command, it is always recommended to do a crosscheck of the backup as shown below.Ĭrosscheck backup command will check for the records in the RMAN repository to make sure they are accurate. i.e I have backups starting from 6th June until 26th Sep (several months). In the following example, I see that there are lot of backup that I have on the system that are way older than what I need to satisfy my recovery requirement. The entries are marked as DELETED in the Oracle control file.The backup entries are removed from the RMAN recovery catalog.The physical backup files are removed from the filesystem level (or from tape backup).The following three things will happen when you perform “DELETE OBSOLETE” from RMAN prompt: Obsolete backups are those that are not required to satisfy RMAN requirement of what is specified in the retention policy to recover the database from the backup.
Horcrux email backup exclude list full#
If you don’t have a full backup in the last 4 days, then what RMAN considers as obsolete will be even longer than that. It depends on whether a full-backup is available within the last 4 days. Please keep in mind that sometimes it might not be just 4 days. In our example above, any backup that we have in our system (both on RMAN catalog, and as physical RMAN backup files at the filesystem level) that is older than 4 days is considered obsolete. There is a big difference between Obsolte and Expired RMAN backup.
![horcrux email backup exclude list horcrux email backup exclude list](https://thehorcrux.com/wp-content/uploads/2020/03/yahoo_horcrux_emaill_backup-768x1005.png)
$ rman target /ĬONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS So, any backup that is older than 4 days is considered obsolete and old.
![horcrux email backup exclude list horcrux email backup exclude list](https://help.upsafe.com/wp-content/uploads/2016/03/12-1-1024x361.png)
In the following example, retention policy is 4 days. To identify your retention policy, connect using RMAN and and execute “show all” and look for the following line. The main parameter that decides what to delete is the retention policy.
Horcrux email backup exclude list how to#
This tutorial explains how to identify the backups that are obsolete and expired, and how to properly delete them from RMAN. If you don’t properly delete obsolete and expired Oracle DB backup from the catalog, it will cause some unnecessary throw error message during backup and also it will take-up space at the filesystem level.Īlso, it is not recommended to directly remove the RMAN backup files from the filesystem using Linux rm command. If you are sysadmin, sometimes you might find yourself dealing with Oracle backups.Īpart from taking oracle RMAN backup, you should also understand how to Delete the old backups from the RMAN catalog and from physical filesystem.