RE: Archive logs & physical standby
Date: Thu, 20 Mar 2008 14:09:44 -0400
Message-ID: <746B47FAF6783042B256C0E7CC0795CD0293460B@caonmastxm02.na.capgemini.com>
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_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752
Together: the Collaborative Business Experience
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frank Pettinato
Sent: Thursday, March 20, 2008 12:45 PM
To: rems_at_wp-sa.pl; granaman_at_cox.net
Cc: oracle-l_at_freelists.org
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_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#SB
YDB00750>
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 ________________________________ 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. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 20 2008 - 13:09:44 CDT