ss

Down Streams Capture Configuration

At times, it may not be feasible or desirable to configure a database link between the source and Down Streams databases. It is because:

• The Down Streams database is outside a firewall
   

• The DBA does not want an in-bound database link to the source database

If the database link does not exist from the Down Streams database to the source database, the following tasks must be completed manually at the source site when configuring Down Streams capture:

• Dictionary dump and obtain the first_scn value
   

• Instantiate replicated database objects

Steps in Case of Implicit Assignment of Logs

The implicit assignment means that the Down Streams Capture process automatically scans all redo log files added by log transport services from the source database to the Down Streams database. This method follows the steps shown below:

Step 1:  Setup up Source Database Environment

At the source database, ensure that the required init.ora parameters used to configure log transport services are present in order to copy the redo log files from the source database to the Down Streams database. For example, the log_archive_dest_2 parameter sets the log transport service at source database, DNYTST10.

LOG_ARCHIVE_DEST_2='SERVICE=DNYOIP20.world ARCH OPTIONAL NOREGISTER REOPEN=60 TEMPLATE=/db_dumps/oracle/archive/TST1_arc_%t_%s_%r.log'