les10_dcap.ppt

Configuring Downstream Capture Objectives After completing this lesson, you should be able to: Describe downstream capture Configure downstream capture Test downstream capture Downstream Capture Prerequisites for Downstream Capture Configure a Streams administrator, with ARCHIVELOG mode and (optionally) a staging queue. Configure network connectivity. (Optional) Create a database link from the target back to the source database. Enable supplemental logging on the source database if you are not using a database link. Configure log transport services. Copy password file for database authentication. Add standby redo log at the downstream database. Configuring Log Transport Services Configure initialization parameters for both the source and destination databases: LOG_ARCHIVE_CONFIG LOG_ARCHIVE_DEST_STATE_n Configuring Log Transport Services at the Source Database Use the LOG_ARCHIVE_DEST_n source database initialization parameter with the following attributes: Configuring Downstream Initialization at the Destination Database Configure the downstream database to receive redo data from the source database LGWR process and write the redo data to the standby redo log at the downstream database. Configuring Standby Logs at the Destination Database 1. Determine the source log file size. 2. Determine the number of standby log file groups. 3. Ensure access rights to the new standby log files. Creating a Downstream Capture Process with a Database Link Creating a Downstream Capture ProcessWithout a Database Link Creating Downstream Processeswith the MAINTAIN Procedure DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS( schema_names = HR, source_directory_object = SRC_EXP_DIR, destination_directory_object = DST_EXP_DIR, source_database = AMER.US.ORACLE.COM, destination_database = EURO.US.ORACLE.COM, capture_name = DSTRM02_CAPTURE, capture_queue_table = DSTRM02_QUEUE_TABLE, capture_queue_name = DSTRM02_QUEUE, apply_name = DSTRM