Re: Archive logs & physical standby

  • From: Frank Pettinato <ecpdba97@xxxxxxxxx>
  • To: rems@xxxxxxxx, granaman@xxxxxxx
  • Date: Thu, 20 Mar 2008 09:44:31 -0700 (PDT)

This only works if your LOG_ARCHIVE_DEST_N is set to MANDATORY. If you set the 
physical Standby archive_dest_n to mandatory the Primary WAITS for archive to 
be applied on the standby.

HTH,
Frank

----- Original Message ----
From: Remigiusz Sokolowski <rems@xxxxxxxx>
To: granaman@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thursday, March 20, 2008 12:46:23 AM
Subject: Re: Archive logs & physical standby

Don Granaman wrote:
> Me: "How can a 10.2 physical standby (LGWR + ASYNC) be configured to
> automatically purge the archive logs from the primary after they have been
> applied?"
>
> Support: "For logical standby we have the automation is in place.  for
> physical standby you have to do the purge manually for now"
>
>  Is this true?  It seems like there should be something better by now.
>
> --
>   
in RMAN there is a setting ARCHIVELOG DELETION POLICY, which can be set 
to APPLIED ON STANDBY
According to doc
"Governs archived redo log deletion policy for the flash recovery area. 
Possible settings are:

    *

      |APPLIED ON STANDBY| - enables flash recovery area to delete
      archivelogs that are applied on mandatory standby. See Oracle Data
      Guard Concepts and Administration
      
<http://andro3/docs/oracle_doc/oracle.10g2/server.102/b14239/rman.htm#SBYDB00750>
      for details."

Does it seem like something You need?
Regards
Remigiusz


-- 

------------------------------------------------------------------------
Remigiusz Sokolowski <rems@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v04.x,05.x; Oracle v10.x

Zastrzezenia:
1. Wylaczenie danej funkcjonalnosci oznacza, ze niezwlocznie przystapimy
   lub juz pracujemy nad jej uruchomieniem
2. Niniejsza wiadomosc stanowi jedynie wyraz prywatnych pogladow autora 
   i nie jest w zadnym wypadku zwiazana ze stanowiskiem przedsiebiorstwa 
   Wirtualna Polska S.A.
------------------------------------------------------------------------



"WIRTUALNA POLSKA" Spolka Akcyjna z siedziba w Gdansku przy ul.
Traugutta 115 C, wpisana do Krajowego Rejestru Sadowego - Rejestru
Przedsiebiorcow prowadzonego przez Sad Rejonowy Gdansk - Polnoc w
Gdansku pod numerem KRS 0000068548, o kapitale zakladowym
67.980.024,00  zlotych oplaconym w calosci oraz Numerze Identyfikacji
Podatkowej 957-07-51-216.
--
//www.freelists.org/webpage/oracle-l








      
____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

Other related posts: