Cómo saber que Archived de Oracle ya se aplicó en la BD destino

[Datateam]

como puedo saber que secuencia de archiver de una base de datos Oracle como origen ya se replicó en un base de datos snowflake de destino?

Puedo tener en el log de la task a secuencia del archived o redo leido en Oracle pero no se como saber en que momento esos cambios se aplicaron en destino.

[john_wang · Accepted solution]

Hello @Datateam ,

Thanks for reaching out to Qlik Community!

I got below transalation from Google:

How to know that Oracle Archived has already been applied to the destination DB
How can I know which archiver sequence from an Oracle database as a source has already been replicated to a target Snowflake database?

I can have in the task log the sequence of the archived or redo read in Oracle but I don't know how to know when those changes were applied to the destination.

In Qlik Replicate task log files, all the processed Oracle redo log files sequence number will be printed (with default source_capture logging level), the rows like:

2024-02-06T10:06:58 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 230 thread 1 name C:\APP\2024_01_26\O1_MF_1_230_LV7GQN9Y_.ARC (oradcdc_redo.c:1009)
2024-02-06T10:07:01 [SOURCE_CAPTURE ]I: Start processing archived Redo log sequence 231 thread 1 name C:\APP\2024_02_02\O1_MF_1_231_LVRYFCX5_.ARC (oradcdc_redo.c:1009)

IN the above sample lines, the reading of archived redo log sequence# 230 was completed, Replicate is starting to process sequence# 231. In general the changing datas in sequence# 230 were applied to target endpoint database already if the current applying latency is not big and the task is running smoothly.

Hope this helps.

John.