Re: Streams foreign archivelog restore
- From: Rich <richa03@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Aug 2011 14:10:17 -0700
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@xxxxxxxxx> 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
>
Other related posts:
