Is there any way to push Standby database to delete archiveloges quicker (ARCHIVELOG DELETION POLICY in use)?
- From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- 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.
ON STANDBY:
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
+DATA/gtst/archivelog/2009_06_16/thread_1_seq_83.349.689686855
Deleted Oracle managed file
+DATA/gtst/archivelog/2009_06_16/thread_1_seq_84.351.689687247
...
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,
Yury
--
//www.freelists.org/webpage/oracle-l
Other related posts:
