Re: Oracle Streams / RAC and sharing archive logs
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: John.Fedock@xxxxxxxxxxxx
- Date: Tue, 13 May 2008 14:20:40 -0400
John,
You can use OCFS (or any other clustered filesystem), ASM or NFS (?) to
share your archived redo destination between multiple instances. Or in your
case configure downstream capture on non-RAC target.
--romas
On 5/13/08, Fedock, John (KAM.RIC) <John.Fedock@xxxxxxxxxxxx> wrote:
>
> We have been testing streams where the source is a 2 node HP-UX
> 10.2.0.3database and the target is a
> 10.2.0.3 Windows database (not RAC).
>
>
>
> While testing, we have been getting errors where logminer cannot read a
> particular archive log. The reason is Node2 is looking for an archive log
> on Node1.
>
>
>
> We have seen in the fine reference manuals this statement:
>
>
>
> "The archive log threads from all instances must be available to any
> instance running a capture process. This is true for both local and
> downstream capture."
>
>
>
> I am looking for clarification on this statement. Currently our archive
> logs are specific to the node it is generated on. Node 1 cannot see Node2
> archive logs and Node2 cannot see node1 archive logs. If this is true, how
> do you make them available to each other? Manually FTP and double the
> space used? Create a log_archive_dest_x on both nodes and write the
> archive logs there as well?
>
>
>
> Seems to me my space requirement for archive logs is going to go up.
>
>
>
> Thanks in advance,
>
>
>
>
>
>
>
> *John Fedock*
>
> *"K"* Line America, ISD Department
>
>
>
Other related posts:
