Oracle Streams / RAC and sharing archive logs
- From: "Fedock, John \(KAM.RIC\)" <John.Fedock@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 May 2008 13:59:40 -0400
We have been testing streams where the source is a 2 node HP-UX 10.2.0.3
database 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
- Follow-Ups:
- Re: Oracle Streams / RAC and sharing archive logs
- From: Roman Podshivalov
Other related posts:
- » Oracle Streams / RAC and sharing archive logs
- » Re: Oracle Streams / RAC and sharing archive logs
- Re: Oracle Streams / RAC and sharing archive logs
- From: Roman Podshivalov