Re: Transient files in the FRA

From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 4 Dec 2014 15:13:11 +0100 (CET)
Message-ID: <1981870445.27428.1417702391077.open-xchange_at_app10.ox.hosteurope.de>

Hi John,
you can think about deferred log destinations in Data Guard environments. Oracle introduced a hidden parameter (with version 11.2.0.x) called "_deferred_log_dest_is_valid" to control this behavior. More details can be found in MOS ID #1380368.1.

Best Regards
Stefan Koehler

Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> John Hallas <John.Hallas_at_morrisonsplc.co.uk> hat am 4. Dezember 2014 um 14:51 geschrieben:
>
> * Archived redo logs are not eligible for deletion until all the consumers of the logs have satisfied their requirements.
>
> I am interested in what consumers of the log files might be in point 4. Situations I can think of is if GoldenGate has a long-running transaction
> which it think might still need an old log file (the system where the situation occurred does have GG extracting and forwarding on transactions but
> we have bnot integrated it with RMAN) or if a LogMiner session is running. I am not sure I can think of any other situations. Obviously the RMAN
> retention policy manages when files become obsolete but they will not show

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 04 2014 - 15:13:11 CET