RE: Archive logs & physical standby

From: Goulet, Dick <>
Date: Thu, 20 Mar 2008 14:09:44 -0400
Message-ID: <>


            Regrettably false. If you have log_archive_dest_n set to mandatory the primary will insure that the data is written to the standby redo log at the standby database before proceeding with the next transaction, it can be applied later depending on how the standby is set up, like with an apply delay. And this depends on the protection level of the databases to boot.  

            If your using rman to backup the redo logs on the primary (best practice as far as I'm concerned) with the "delete input" qualifier rman will insure that only applied logs are deleted from the primary site after they have been backed up. Otherwise you'll see an error message about the file being needed for recovery coming from rman. OH, BTW is you set archivelog deletion policy to applied on standby your likely to run into bug 5261960, so set _log_deletion_policy initialization parameter to "ALL" and bounce your database.  

Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / Fax: 508.229.2019 / Email: 45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

[] On Behalf Of Frank Pettinato Sent: Thursday, March 20, 2008 12:45 PM
Subject: Re: Archive logs & physical standby  

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.


  • Original Message ---- From: Remigiusz Sokolowski <> To: Cc: 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
> 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#SB YDB00750>
      for details."

Does it seem like something You need?


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

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.




Looking for last minute shopping deals? Find them fast with Yahoo!

This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient,  you are not authorized to read, print, retain, copy, disseminate,  distribute, or use this message or any part thereof. If you receive this  message in error, please notify the sender immediately and delete all  copies of this message.

Received on Thu Mar 20 2008 - 13:09:44 CDT

Original text of this message