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