GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Golden Gate Downstream configuration following Document ID: 1485620.1

edited Aug 8, 2018 9:27AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓

I have configured the logfile transport as this document specify.

Everytinhg works fine in both modes :

Example for a real-time downstream logmining server:

SQL >ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DBMSCAP.EXAMPLE.COM

ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10

DB_UNIQUE_NAME=dbmscap'

Example for an archived-log-only downstream logmining server.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DMBSCAP.EXAMPLE.COM

ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10

TEMPLATE=/usr/oracle/log_for_dbms1/dbms1_arch_%t_%s_%r.log DB_UNIQUE_NAME=dbmscap'

The full configuration of downstream golden gate extract works fine.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center