Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

请问一下,Oracle全量+增量同步问题 是否会丢失数据 #1865

Open
4 tasks done
zhanghaiyang9999 opened this issue Dec 31, 2023 · 0 comments
Open
4 tasks done
Labels
question Further information is requested

Comments

@zhanghaiyang9999
Copy link

Search before asking

  • I had searched in the issues and found no similar question.

  • I had googled my question but i didn't get any help.

  • I had read the documentation: ChunJun doc but it didn't help me.

Description

oracle数据库在进行全量同步的时候,对其中一个表比如叫TEST插入了一些数据,但是没有提交,这个时候要开始同步,会获取系统当前的scn,假设此时获取到的scn为100,因为oracle数据库的scn一直在变化,获取到的这个当前的scn肯定是要大于刚对TEST表插入的数据记录。oracle的在线或者归档日志中,没有提交(COMMIT)的数据也会在里面显示,所以现在的情况是,对TEST表插入的记录的scn会小于100,全量同步时获取到的scn为100,所以当全量同步完以后,开始增量同步的时候,是从100开始进行增量同步,请问一下,在同步之前对TEST插入的数据会不会丢失?这么想起来看这些数据可能会丢失。
请教专家们,多谢!

Code of Conduct

@zhanghaiyang9999 zhanghaiyang9999 added the question Further information is requested label Dec 31, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

1 participant