本文主要是介绍当CDC总是找一个非常老的SCN号而无法启动预定时,如何重置日志点,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
源端是ORACLE目标端是DB2:
目标端:获取预定名EBA3GRP的当前的bookmark
[cdcuser@p0-pbd-pbd-db2 bin]$ ./dmshowbookmark -I IYLINST -s EBA3GRP -v
Bookmark for instance "IYLINST" and Source ID "EBA3GRP":
Hex encoded: 00030800F48B64F47B0116C3907D470200010002609001F0010116C3907D470200010002609001F00100000000
Unable to decode the bookmark.
Use dmdecodebookmark with the hex encoded value on the source to interpret the bookmark contents.
源端:转换bookmark到SCN号
$ ./dmdecodebookmark -I S_EBADB2 -b 00030800F48B64F47B0116C3907D470200010002609001F0010116C3907D470200010002609001F00100000000
Bookmark value: 00030800F48B64F47B0116C3907D470200010002609001F0010116C3907D470200010002609001F00100000000
Header: 000308
Restart position: 1050310669435
Commit position: 1197281934663.2.1.155792.496.1
Current position: 1197281934663.2.1.155792.496.1.0
源端:重置该预定的日志点SCN号
$ ./dmsetbookmark -I S_EBADB2 -a -s EBA3GRP -l '1197281934663;1197281934663.0.0.0.0.0;1197281934663.0.0.0.0.0.0'
这篇关于当CDC总是找一个非常老的SCN号而无法启动预定时,如何重置日志点的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!