Re: Archive logs & physical standby
Date: Thu, 20 Mar 2008 09:44:31 -0700 (PDT)
Message-ID: <538941.70189.qm@web52707.mail.re2.yahoo.com>
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_at_wp-sa.pl> To: granaman_at_cox.net Cc: oracle-l_at_freelists.org 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_at_wp-sa.pl> 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. -- http://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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 20 2008 - 11:44:31 CDT