Is there any way to push Standby database to delete archiveloges quicker (ARCHIVELOG DELETION POLICY in use)?
Date: Wed, 20 May 2009 18:22:22 +1000
Hello dear List members,
Just wonder if someone came across the following question:
10.2.0.4 Data Guard configuration
Backups are taken on primary. As soon as an archivelog applied on a standby it could be deleted.
log_archive_dest_1='LOCATION=use_db_recovery_file_dest' CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; Oracle deletes applied archivelogs in a "lazy" mode. I assume as soon as space usage reach some threshold of db_recovery_file_dest_size Oracle starts to delete some "old"/applied archivelogs from fra. There are the following messages in the alert.log file: Deleted Oracle managed file
Deleted Oracle managed file
Just wonder if someone knows any way to change the "threshold" to push Oracle to delete applied archivelogs faster? Let say do not keep those at all on keep a small amount of those?
Thank you in advance,