Re: Is there any way to push Standby database to delete archiveloges quicker (ARCHIVELOG DELETION POLICY in use)?

  • From: Edgar Chupit <chupit@xxxxxxxxx>
  • To: j.velikanovs@xxxxxxxxx
  • Date: Thu, 28 May 2009 10:43:55 +0200

Hi Jurijs,

As soon as Oracle knows that archivelog is applied on standby, it
marks the space used by archived log as reclaimable. Unfortunately, I
also don't know how to make Oracle free reclaimable space more
aggressively.
But what you can try to do is make a script that will run DELETE
OBSOLETE from RMAN at specified periods, so that you are sure that all
archived&applied logs are removed.

Best regards,
 Edgar Chupit
 callto://edgar.chupit



On Wed, May 20, 2009 at 10:22 AM, Jurijs Velikanovs
<j.velikanovs@xxxxxxxxx> wrote:
> Hello dear List members,
>
> 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: