Parameters in Oracle Streams Stored Procedure

1. maintain_mode Parameter

Golbal or transportable tablepsaces is recommended. When this parameter is set to global, streams is used for full-database replication; otherwise, streams is used for table space replication, you must specify one or more tablespaces to be copied in the tablespace_names parameter.

2. Required m_actions Parameter

When this parameter is set to true, the script execution process configured for streams is recorded in the dba_recoverable_script dictionary table. If pre_instantiation_setup encounters an error, you can execute the recover_operation process of dbms_streams_adm to continue the streams replication configuration after the error is corrected. If the parameter is false, the configuration script is generated to the location specified by the script_directory_object/script_name parameter.

3. source_database/destination_database Parameters

Is the database link to the source and target databases, must be correct, otherwise the pre_instantiation_setup process will fail, the ora-23621 error is reported, if the error occurs, you can use the recover_operation process of dbms_streams_adm to roll back or clear the previous operation, correct the error, and then execute the pre_instantiation_setup process.

4, bi_directional

When this parameter is set to true, it indicates that streams is a multi-source replication, that is, objects and data are copied both to the target database and the source database. Otherwise, only objects and data are copied from the source database to the target database.

5, include_ddl

This parameter indicates that DDL operations are also performed during the replication process.

6, start_processes

This parameter starts the capture, propagation, and application process after the streams configuration is complete.

7. exclude_schemas

This parameter indicates the users who do not participate in the replication during full-Database Replication. If multiple users do not participate in the replication, they can be separated by commas (,). If the asterisk (*) is used, all schemas are excluded, NULL does not rule out any schemas (sys/system/stxsys does not copy at all). This parameter is only valid for full database replication.

8, exclude_flags

This indicates some operations that should be avoided to avoid recursive Application Problems of redo entry during multi-source replication.

1 2 Next Page