RE: Archive logs & physical standby

  • From: "Goulet, Dick" <richard.goulet@xxxxxxxxxxxxx>
  • To: <ecpdba97@xxxxxxxxx>, <rems@xxxxxxxx>, <granaman@xxxxxxx>
  • Date: Thu, 20 Mar 2008 14:09:44 -0400

Frank,

 

            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 / www.capgemini.com
Fax: 508.229.2019 /  Email: richard.goulet@xxxxxxxxxxxxx
45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience 
______________________________________________________________

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Frank Pettinato
Sent: Thursday, March 20, 2008 12:45 PM
To: rems@xxxxxxxx; granaman@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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.

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#SB
YDB00750>
      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



 

 

________________________________

Looking for last minute shopping deals? Find them fast with Yahoo!
Search.
<http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearc
h/category.php?category=shopping> 



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.

Other related posts: