Checking Whether the Source Database Is on Standby

Whether the source database is on standby

For a full+incremental synchronization task, the source database cannot be a standby database. Otherwise, incremental synchronization cannot be performed.

For a full synchronization task, the source database can be a standby database, but hot_standby_feedback must be set to on. Otherwise, the synchronization may fail.

Failure cause: In a real-time full+incremental synchronization task, the source database cannot be a standby database. Otherwise, incremental synchronization cannot be performed.

Handling suggestion: Configure the source database as the primary database.

Failure cause: For a full synchronization task, the source database is a standby database, and hot_standby_feedback is set to off.

Handling suggestion: Configure the source database as the primary database, or set hot_standby_feedback of the source database to on.

• Change the source database to the primary database.
• Alternatively, change the hot_standby_feedback value of the source database to on before starting full synchronization. After the full synchronization is complete, change the value of this parameter to off.