Deletion of old Archived Redo Logs
Date: Mon, 16 Jul 2012 10:11:20 -0300
Message-ID: <CACH2ED+85dNMXVL=zbmk+pog8VEBRpiAYTCf2yhChvRfZS7GiQ_at_mail.gmail.com>
Deletion of Archived Redo Logs
As explained in "Basic Concepts of Backup and Repository Maintenance", the recommended maintenance strategy is to configure a fast recovery area, a backup retention policy, and an archived redo log deletion policy. By default, the archived redo logs deletion policy is configured to NONE. In this case, the fast recovery area considers the logs eligible for deletion if they have been backed up at least once to disk or tape or the logs are obsolete according to the backup retention policy. Archived redo logs can be deleted automatically by the database or by any of the user-initiated RMAN commands listed in Table 12-1. For logs in the recovery area, the database retains them as long as possible and automatically deletes eligible logs when disk space is required. You can delete eligible logs from any location, inside or outside the recovery area, with BACKUP ... DELETE INPUT or DELETE ARCHIVELOG. Both of these commands obey the archive redo log deletion policy when the policy is any setting other than NONE. You can override the archived redo log deletion policy settings by using the FORCE option in the DELETE command.
English is not my first language, but doesn't this imply that if the fast_recovery_area is short of space, RMAN will overwrite older logs?
It's not doing it on our server, we are at 11.2.0.3..
- Patrice
<http://www.viadeo.com/fr/profile/patrice.boivin>
[image: Facebook]
<http://www.facebook.com/profile.php?id=100000206805521> [image:
LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9> [image:
Twitter] <http://www.twitter.com/PatriceBoivin> [image:
Amazon]<http://www.amazon.com/gp/redirect.html?ie=UTF8&location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fregistry%2Fregistry.html%3Fie%3DUTF8%26type%3Dwishlist%26id%3D2JU0BBL2AGGSD&tag=casper-20>
[image:
Digg] <http://digg.com/patriceboivin> [image:
Google]<http://https://sites.google.com/site/patriceboivin/>
Get a signature like this.
<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19>
CLICK
HERE.<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 16 2012 - 08:11:20 CDT