Oracle Streams / RAC and sharing archive logs

From: Fedock, John \(KAM.RIC\) <>
Date: Tue, 13 May 2008 13:59:40 -0400
Message-ID: <>

We have been testing streams where the source is a 2 node HP-UX database and the target is a 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

Received on Tue May 13 2008 - 12:59:40 CDT

Original text of this message