Re: Streams foreign archivelog restore

From: Rich <richa03_at_gmail.com>
Date: Tue, 2 Aug 2011 14:10:17 -0700
Message-ID: <CALgGkeBFuYJtD2MFKF_GvZ+XZUXRRY+A9MfH6ENmsXs1cGgdFQ_at_mail.gmail.com>

From Oracle SR:
Regarding Streams and REDO, as noted in Note 313279.1 Master Note for Troubleshooting Streams Capture 'WAITING For REDO' or INITIALIZING please see question #2:

It is recommended that the FRA should be avoided with Streams.

Archive log files can be deleted and ORA-1291 reported when archive logs are located in a Flash Recovery Area (FRA). More details can be found with respect to FRA in Note 305648.1 What is a Flash Recovery Area and how to configure it ?".
This is a recognized behavior and for this reason it is recommended that archive logs not be located in a FRA where a Capture process will mine from this location.

This is documented in the Oracle Streams Concepts and Administration 11g Release 2 (11.2) guide under the section Troubleshooting Capture Problems subsection : Are Required Redo Log Files Missing. http://download.oracle.com/docs/cd/E11882_01/server.112/e17069/strms_trcapture.htm#i1010961

It should also be pointed out that archive logs may be deleted from the FRA when the instance is shutdown and restarted. Those archive logfiles deleted logs should be reported in the alert.log file.

On Wed, Jul 27, 2011 at 3:11 PM, Rich <richa03_at_gmail.com> wrote:

> Hi All,
> This is 11.2.0.2 DB (64-bit) on RHEL 5.6 using ASM.
>
> This instance is the Streams destination for a 10.2.0.4 DB (non-ASM).
>
> It is set up as real-time downstream capture.
>
> It has been through:
> stop apply
> stop capture
> shutdown immediate;
> startup
> start capture
> start apply.
>
> Now, the alertlog complains:
> LOGMINER: Error 308 encountered, failed to read logfile
> +FRA/prdstr/foreign_archivelog/dbid_139235938/2011_07_27/thread_1_seq_9529.4234.757609859
> ...
>
> RFS is still receiving logfiles on the downstream instance from the source
> DB, so this was not a transport issue:
> RFS LogMiner: Registered logfile
> [+FRA/prdstr/foreign_archivelog/dbid_139235938/2011_07_27/thread_1_seq_9570.3015.757634233]
> to LogMiner session id [3]
>
> Seems that Oracle removed some of the necessary foreign archivelogs at
> shutdown:
> Deleted Oracle managed file
> +FRA/prdstr/foreign_archivelog/dbid_139235938/2011_07_18/thread_1_seq_9529.4234.757609859
> ...
>
> We have done this a number of times before (stop apply and capture,
> shutdown, startup, start capture and apply) with no issue.
>
> These archived redo files exist on the primary, however, I don't know how
> to get them to the destination such that logminer can read them.
>
> I know how to do this for "normal" archived redo and "normal" file system,
> however, how is this (restoration of foreign archivelog files) done with
> ASM?
> A "straight" copy will not work as ASM will append it's serial numbers to
> the file...
>
> TIA,
> Rich
>

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

Received on Tue Aug 02 2011 - 16:10:17 CDT