les06_cap2.pptVIP

Configuring a Capture Process Objectives After completing this lesson, you should be able to: Configure a capture process Manage a capture process Monitor a capture process Creating the Capture Process Automatically create a capture process by using the DBMS_STREAMS_ADM package: ADD_TABLE_RULES ADD_SCHEMA_RULES ADD_GLOBAL_RULES ADD_SUBSET_RULES MAINTAIN_* procedures Manually create a capture process by calling the CREATE_CAPTURE procedure of DBMS_CAPTURE_ADM. Creation of the first capture process in a database may take time because the data dictionary is being copied to the redo logs. Creating the Capture Process Creating the Capture Process Example of creating a capture process automatically: Detailed Capture Management The DBMS_CAPTURE_ADM package includes the following procedures for managing the capture process: CREATE_CAPTURE SET_PARAMETER START_CAPTURE ALTER_CAPTURE INCLUDE_EXTRA_ATTRIBUTE STOP_CAPTURE DROP_CAPTURE BUILD Manually Creating the Capture Process Example of creating a capture process by using the DBMS_CAPTURE_ADM package: Setting Capture Process Parameters Use the DBMS_CAPTURE_ADM package to: Alter the capture process configuration Set capture process parameters that control the way a capture process operates Capture Process Parameters DISABLE_ON_LIMIT DOWNSTREAM_REAL_TIME_MINE MAXIMUM_SCN MESSAGE_LIMIT PARALLELISM STARTUP_SECONDS TIME_LIMIT TRACE_LEVEL WRITE_ALERT_LOG Starting the Capture Process When you create a capture process, it does not start automatically. This allows the DBA to set the capture parameters appropriately before the capture starts. You must not start capture until all apply processes and propagation jobs have been configured and started. To start the capture process, use the DBMS_CAPTURE_ADM.START_CAPTURE procedure. Modifying the Capture Process The ALTER_CAPTURE procedure is used to: Specify or remove a positive or negative rule set Specify a capture user Change the start SCN or first SCN Change the duration for checkpoint