Does Real-Time Downstream Capture supports Heterogenous OS at source & target sites?
edited May 16, 2012 6:36PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓
The Doc# 753158.1'How to Configure an Oracle Stream Real-Time Downstream Capture Environment ' demonstrates how to configure Real-time downstrem capture.
The configurations for log shipping are standby database configuration fashion :
from source site:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE= orcl102d LGWR SYNC NOREGISTER VALID_FOR=(oline_logfiles,primary_role) DB_UNIQUE_NAME=ORCL102D' SCOPE=SPFILE;
from target site:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='LOCATION=/home/oracle/archives/ORCL102D/standby-archives/
VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)'
SCOPE=SPFILE;
from both source & target
ALTER DATABASE ADD STANDBY LOGFILE GROUP xxx
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORCL102C,ORCL102D)' SCOPE=SPFILE;
0