Help Center/ DataArts Studio/ FAQs/ DataArts Migration (Real-Time Jobs)/ What Should I Do If an Error Occurs During Real-Time Data Transmission from an Oracle Database to the Standby Oracle Database?
Updated on 2026-03-20 GMT+08:00
View PDF
Share

What Should I Do If an Error Occurs During Real-Time Data Transmission from an Oracle Database to the Standby Oracle Database?

Symptom

When data is transmitted from an Oracle database to the standby Oracle database in real time, the error shown in the following figure occurs.

Figure 1 Error message

Possible Cause

The standby Oracle database reads and parses binary logs during real-time synchronization. During the parsing, the standby database must use the same character set as the source database so that the binary logs can be correctly parsed.

Currently, the following character sets are supported: ZHS16GBK, AL32UTF8, UTF-8, US7ASCII, WE8MSWIN1252, WE8ISO8859P1, WE8ISO8859P2, WE8ISO8859P4, WE8ISO8859P5, WE8ISO8859P7, WE8ISO8859P9, WE8ISO8859P13 and WE8ISO8859P15.

Other character sets are not supported.

Solution

  • Change the character set used in the source Oracle database to AL32UTF8, which is more commonly used.
  • Synchronize data from the primary Oracle database.