Help Center/ Data Replication Service/ FAQs/ Real-Time Synchronization/ How Do I Delete XStream Outbound Created When XStream Is Enabled?
Updated on 2023-07-03 GMT+08:00
View PDF

How Do I Delete XStream Outbound Created When XStream Is Enabled?

For Oracle to GaussDB synchronization, if you use XStream for log reading, you need to delete XStream Outbound created by the DRS task from the source database after the task is complete. This prevents the disk space from being used up because the Oracle database does not automatically delete archive logs that are not consumed by XStream Outbound.

Procedure

  1. Run the following SQL statements on the source database to check whether XStream Outbound created by the DRS task exists: 

    SELECT SERVER_NAME, 
       CONNECT_USER, 
       CAPTURE_USER,
       CAPTURE_NAME,
       SOURCE_DATABASE,
       QUEUE_OWNER,
       QUEUE_NAME
FROM DBA_XSTREAM_OUTBOUND;

    The naming format of SERVER_NAME of XStream Outbound is DRS_+Task ID in uppercase. The hyphen in the uppercase task ID will be replaced by an underscore (_), for example, DRS_04981F62_84A4_4974_A5D5_772ED2DF63AC.

  2. If XStream Outbound exists, run the following SQL statement to delete it: In the following statement, <xstream SERVER_NAME> indicates the value of SERVER_NAME obtained in 1. 

    BEGIN DBMS_XSTREAM_ADM.DROP_OUTBOUND(server_name => '<xstream SERVER_NAME>');END;