How Do I Handle an Exception of the CDC Function (Using the XStream Mode) Caused by Unexpected Oracle Database Restart?

If the CDC function is abnormal because the Oracle database restarts unexpectedly, perform the following operations on the Oracle database to locate and rectify the fault:

Connect to the Oracle database as user sys and run the following command:

SELECT CAPTURE_NAME,status FROM ALL_CAPTURE;

If the status is Aborted, the outbound server of the CDC is abnormal. Run the following command and press Enter. Then, enter / and press Enter again to manually start the outbound server.

BEGIN
 DBMS_XSTREAM_ADM.START_OUTBOUND(server_name => 'dbzxout');
END;