{"id":293,"date":"2019-10-27T10:16:39","date_gmt":"2019-10-27T02:16:39","guid":{"rendered":"http:\/\/www.821121.com\/?p=293"},"modified":"2020-12-18T15:46:47","modified_gmt":"2020-12-18T07:46:47","slug":"ogg%e5%b8%b8%e7%94%a8%e5%91%bd%e4%bb%a4%e8%a1%8c%e7%95%8c%e9%9d%a2%e5%91%bd%e4%bb%a4%ef%bc%88%e4%ba%8c%ef%bc%89-add","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=293","title":{"rendered":"OGG\u5e38\u7528\u547d\u4ee4\uff08\u4e8c\uff09–CHECKPOINTTABLE"},"content":{"rendered":"

1\u3001ADD CHECKPOINTTABLE<\/h1>\n

\u5bf9\u4e8eJava\u590d\u5236\uff0cOracle GoldenGate\u5e94\u7528\u7a0b\u5e8f\u9002\u914d\u5668\u6216Oracle GoldenGate\u5927\u6570\u636e\u65e0\u6548\u3002
\n\u7528\u4e8eADD CHECKPOINTTABLE\u5728\u76ee\u6807\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u68c0\u67e5\u70b9\u8868\u3002\u590d\u5236\u4f7f\u7528\u8be5\u8868\u6765\u7ef4\u62a4\u5176\u5728\u8def\u5f84\u4e2d\u7684\u8bfb\u53d6\u4f4d\u7f6e\u7684\u8bb0\u5f55\uff0c\u4ee5\u7528\u4e8e\u6062\u590d\u3002
\n\u5f3a\u70c8\u5efa\u8bae\u4f7f\u7528\u68c0\u67e5\u70b9\u8868\uff0c\u56e0\u4e3a\u5b83\u4f1a\u4f7f\u68c0\u67e5\u70b9\u6210\u4e3a\u590d\u5236\u4e8b\u52a1\u7684\u4e00\u90e8\u5206\u3002\u4e0e\u5728\u5355\u72ec\u4f7f\u7528\u68c0\u67e5\u70b9\u6587\u4ef6\u7684\u60c5\u51b5\u4e0b\u76f8\u6bd4\uff0c\u8fd9\u4f7fReplicat\u5728\u67d0\u4e9b\u60c5\u51b5\u4e0b\u66f4\u5bb9\u6613\u6062\u590d\u3002\u4f46\u662f\uff0c\u5728\u5c06\u590d\u5236\u914d\u7f6e\u4e3a\u9488\u5bf9Oracle\u76ee\u6807\u6570\u636e\u5e93\u4ee5\u96c6\u6210\u6a21\u5f0f\u8fd0\u884c\u65f6\uff0c\u8bf7\u52ff\u4f7f\u7528\u68c0\u67e5\u70b9\u8868\u3002\u5728\u8be5\u6a21\u5f0f\u4e0b\u4e0d\u9700\u8981\u3002
\n\u5982\u679cCHECKPOINTTABLE\u5728GLOBALS\u6587\u4ef6\u4e2d\u4f7f\u7528\u53c2\u6570\u6307\u5b9a\u4e00\u4e2a\u8868\uff0c\u5219\u8be5\u8868\u53ef\u4ee5\u7528\u4f5cOracle GoldenGate\u5b9e\u4f8b\u4e2d\u6240\u6709\u590d\u5236\u7ec4\u7684\u9ed8\u8ba4\u68c0\u67e5\u70b9\u8868 \u3002\u4e00\u4e2a\u4ee5\u4e0a\u7684Oracle GoldenGate\u5b9e\u4f8b\uff08\u591a\u4e2a\u5b89\u88c5\uff09\u53ef\u4ee5\u4f7f\u7528\u540c\u4e00\u68c0\u67e5\u70b9\u8868\u3002\u5373\u4f7f\u5728\u4e0d\u540c\u5b9e\u4f8b\u4e2d\u5b58\u5728\u76f8\u540c\u7684\u590d\u5236\u7ec4\u540d\u79f0\uff0cOracle GoldenGate\u4e5f\u4f1a\u8ddf\u8e2a\u68c0\u67e5\u70b9\u3002
\n\u4f7f\u7528\u6b64\u547d\u4ee4\u4e4b\u524d\uff0c\u8bf7\u4f7f\u7528DBLOGIN\u8be5\u547d\u4ee4\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u3002\u4e0d\u8981\u66f4\u6539\u6b64\u8868\u4e2d\u5217\u7684\u540d\u79f0\u6216\u5c5e\u6027\u3002\u4f46\u662f\uff0c\u60a8\u53ef\u4ee5\u66f4\u6539\u8868\u5b58\u50a8\u5c5e\u6027\u3002<\/p>\n

\u8bed\u6cd5\uff1a
\nADD CHECKPOINTTABLE [[container. | catalog.]owner.table]<\/p>\n

container. | catalog.
\nOracle\u53ef\u63d2\u62d4\u6570\u636e\u5e93\uff08\u5982\u679c\u9002\u7528\uff09\u3002\u5982\u679c\u8fd9\u4e2a\u9009\u9879\u88ab\u5ffd\u7565\uff0c\u53ef\u63d2\u62d4\u6570\u636e\u5e93\u9ed8\u8ba4\u4e3a\u4e00\u4e2a\u4e0e\u76f8\u5173\u8054\u7684SOURCEDB\uff0cUSERID\u6216USERIDALIAS\u6240\u8ff0\u7684\u90e8\u5206DBLOGIN \u547d\u4ee4\uff08\u53d6\u51b3\u4e8e\u6570\u636e\u5e93\uff09\u3002<\/p>\n

owner.table
\n\u8981\u521b\u5efa\u7684\u68c0\u67e5\u70b9\u8868\u7684\u6240\u6709\u8005\u548c\u540d\u79f0\u3002\u8be5\u540d\u79f0\u4e0d\u80fd\u5305\u542b\u4efb\u4f55\u7279\u6b8a\u5b57\u7b26\uff0c\u4f8b\u5982\u5f15\u53f7\uff0c\u53cd\u659c\u6760\uff0c\u7f8e\u5143\u7b26\u53f7\u548c\u767e\u5206\u53f7\u3002MySQL\u68c0\u67e5\u70b9\u8868\u7684\u540d\u79f0\u6700\u591a\u53ef\u4ee5\u5305\u542b30\u4e2a\u5b57\u7b26\u3002<\/p>\n

\u6240\u6709\u8005\u548c\u540d\u79f0\u53ef\u4ee5\uff0c\u5982\u679c\u4f60\u6b63\u5728\u4f7f\u7528\u6b64\u8868\u4f5c\u4e3a\u9ed8\u8ba4\u7684\u68c0\u67e5\u70b9\u8868\uff0c\u53ef\u4ee5\u7701\u7565\u5b83\u5217\u51fa CHECKPOINTTABLE \u4e86\u5728GLOBALS \u6587\u4ef6\u4e2d\u3002<\/p>\n

\u5efa\u8bae\uff08\u4f46\u4e0d\u662f\u5fc5\u9700\uff09\u5728\u4e13\u7528\u4e8eOracle GoldenGate\u7684\u67b6\u6784\u4e2d\u521b\u5efa\u8868\u3002\u5982\u679c\u672a\u6307\u5b9a\u6240\u6709\u8005\u548c\u540d\u79f0\uff0c\u5219\u4f1a\u57fa\u4e8e\u53c2\u6570\u6587\u4ef6CHECKPOINTTABLE\u4e2d\u7684GLOBALS \u53c2\u6570\u521b\u5efa\u9ed8\u8ba4\u8868 \u3002<\/p>\n

\u8bb0\u5f55\u8868\u7684\u540d\u79f0\uff0c\u56e0\u4e3a\u60a8\u5c06\u9700\u8981\u5b83\u6765\u67e5\u770b\u7edf\u8ba1\u4fe1\u606f\u6216\u5728\u9700\u8981\u65f6\u5220\u9664\u8868\u3002\u5728MA\u4e2d\uff0c\u68c0\u67e5\u70b9\u8868\u7684\u9ed8\u8ba4\u67b6\u6784\u7531\u4e3a\u6bcf\u4e2a\u90e8\u7f72\u5b9a\u4e49\u7684Oracle GoldenGate\u7528\u6237\u63a7\u5236\u3002\u8bf7\u53c2\u9605 \u300a\u4f7f\u7528Oracle GoldenGate\u5fae\u670d\u52a1\u67b6\u6784\u300b\u6307\u5357\u4e2d\u63cf\u8ff0\u7684\u201c\u5982\u4f55\u521b\u5efa\u90e8\u7f72\u201d\u8fc7\u7a0b\u7684\u6b65\u9aa47 \u3002<\/p>\n

\u4e3e\u4f8b1\uff1a<\/p>\n

GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> add checkpointtable ogg.checkpointtable\n\nSuccessfully created checkpoint table ogg.checkpointtable.\n\nGGSCI (oracle11g as ogg@orcl) 3> <\/code><\/pre>\n
\u4e3e\u4f8b2\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> view params .\/GLOBALS\n\nGGSCHEMA ogg\nCHECKPOINTTABLE ogg.checkpointtable\n\nGGSCI (oracle11g as ogg@orcl) 3> add checkpointtable\n\nNo checkpoint table specified. Using GLOBALS specification ogg.checkpointtable...\n\nSuccessfully created checkpoint table ogg.checkpointtable.<\/code><\/pre>\n
2\u3001CLEANUP CHECKPOINTTABLE<\/h1>\n
\u5bf9\u4e8eJava\u590d\u5236\uff0cOracle GoldenGate\u5e94\u7528\u7a0b\u5e8f\u9002\u914d\u5668\u6216Oracle GoldenGate\u5927\u6570\u636e\u65e0\u6548\u3002<\/p>\n
\u4f7f\u7528CLEANUP CHECKPOINTTABLE\u4ece\u68c0\u67e5\u70b9\u8868\u4e2d\u5220\u9664\u68c0\u67e5\u70b9\u8bb0\u5f55\u65f6\uff0c\u6709\u4e00\u4e2a\u4e0e\u5b83\u5728\u5de5\u4f5c\u7684Oracle GoldenGate\u76ee\u5f55\uff08\u4eceGGSCI\u542f\u52a8\uff09\u76f8\u5173\u8054\u7684\u68c0\u67e5\u70b9\u6587\u4ef6\u3002\u6b64\u547d\u4ee4\u4ec5\u5e94\u7528\u4e8e\u5df2\u5220\u9664\u7684\u526f\u672c\u3002\u6b64\u547d\u4ee4\u7684\u76ee\u7684\u662f\u5220\u9664\u4e0d\u518d\u9700\u8981\u7684\u68c0\u67e5\u70b9\u8bb0\u5f55\uff0c\u56e0\u4e3a\u7ec4\u5df2\u66f4\u6539\u6216\u6587\u4ef6\u5df2\u79fb\u52a8\u3002<\/p>\n
\u4f7f\u7528\u6b64\u547d\u4ee4\u4e4b\u524d\uff0c\u8bf7\u4f7f\u7528DBLOGIN\u8be5\u547d\u4ee4\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u3002<\/p>\n
\u8bed\u6cd5\uff1a
\nCLEANUP CHECKPOINTTABLE [[container. | catalog.]owner.table]<\/p>\n
container. | catalog.
\nOracle\u53ef\u63d2\u62d4\u6570\u636e\u5e93\uff08\u5982\u679c\u9002\u7528\uff09\u3002\u5982\u679c\u8fd9\u4e2a\u9009\u9879\u88ab\u5ffd\u7565\uff0c\u4ea7\u54c1\u76ee\u5f55\u6216\u6570\u636e\u5e93\u53ef\u63d2\u62d4\u9ed8\u8ba4\u4e3a\u4e0e\u8be5\u76f8\u5173\u8054\u7684\u4e00\u4e2aSOURCEDB\uff0c USERID\u6216USERIDALIAS\u6240\u8ff0\u7684\u90e8\u5206DBLOGIN\u547d\u4ee4\uff08\u53d6\u51b3\u4e8e\u6570\u636e\u5e93\uff09\u3002<\/p>\n
owner.table
\n\u8981\u6e05\u9664\u7684\u68c0\u67e5\u70b9\u8868\u7684\u6240\u6709\u8005\u548c\u540d\u79f0\u3002\u5982\u679c\u672a\u6307\u5b9a\u6240\u6709\u8005\u548c\u540d\u79f0\uff0c\u5219\u53d7\u5f71\u54cd\u7684\u8868\u662f\u4f7f\u7528\u53c2\u6570\u6587\u4ef6CHECKPOINTTABLE\u4e2d\u7684GLOBALS \u53c2\u6570\u6307\u5b9a\u7684\u8868\u3002<\/p>\n
\u4e3e\u4f8b1\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> CLEANUP CHECKPOINTTABLE ogg.checkpointtable\n\nNothing to clean up in checkpoint table ogg.checkpointtable.<\/code><\/pre>\n
\u4e3e\u4f8b2\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> view params .\/GLOBALS\n\nGGSCHEMA ogg\nCHECKPOINTTABLE ogg.ggschkpt\n\nGGSCI (oracle11g as ogg@orcl) 3> CLEANUP CHECKPOINTTABLE\n\nNo checkpoint table specified. Using GLOBALS specification ogg.ggschkpt...\n\nNothing to clean up in checkpoint table ogg.ggschkpt.<\/code><\/pre>\n
3\u3001DELETE CHECKPOINTTABLE<\/h1>\n
\u5bf9\u4e8eJava\u590d\u5236\uff0cOracle GoldenGate\u5e94\u7528\u7a0b\u5e8f\u9002\u914d\u5668\u6216Oracle GoldenGate\u5927\u6570\u636e\u65e0\u6548\u3002<\/p>\n
\u7528\u4e8eDELETE CHECKPOINTTABLE\u4ece\u6570\u636e\u5e93\u4e2d\u5220\u9664\u68c0\u67e5\u70b9\u8868\u3002\u4f7f\u7528\u6b64\u547d\u4ee4\u4e4b\u524d\uff0c\u8bf7\u4f7f\u7528DBLOGIN\u8be5\u547d\u4ee4\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u3002<\/p>\n
\u8bed\u6cd5\uff1a
\nDELETE CHECKPOINTTABLE [[container. | catalog.]owner.table] [!]<\/p>\n
container. | catalog.
\nOracle\u53ef\u63d2\u62d4\u6570\u636e\u5e93\uff08\u5982\u679c\u9002\u7528\uff09\u3002\u5982\u679c\u8fd9\u4e2a\u9009\u9879\u88ab\u5ffd\u7565\uff0c\u4ea7\u54c1\u76ee\u5f55\u6216\u6570\u636e\u5e93\u53ef\u63d2\u62d4\u9ed8\u8ba4\u4e3a\u4e0e\u8be5\u76f8\u5173\u8054\u7684\u4e00\u4e2aSOURCEDB\uff0c USERID\u6216USERIDALIAS\u90e8\u5206\uff08\u53d6\u51b3\u4e8e\u6570\u636e\u5e93\uff09\u7684\u7684DBLOGIN\u547d\u4ee4\u3002<\/p>\n
owner.table
\n\u8981\u5220\u9664\u7684\u68c0\u67e5\u70b9\u8868\u7684\u6240\u6709\u8005\u548c\u540d\u79f0\u3002\u5982\u679c\u6240\u6709\u8005\u548c\u540d\u79f0\u4e0e\u6587\u4ef6\u4e2d\u7684CHECKPOINTTABLE \u53c2\u6570 \u6307\u5b9a\u7684\u540d\u79f0\u548c\u540d\u79f0\u76f8\u540c\uff0c\u5219\u4e0d\u9700\u8981\u8fd9\u4e9b\u540d\u79f0GLOBALS\u3002<\/p>\n
!
\n\u7ed5\u8fc7\u63d0\u793a\u786e\u8ba4\u5220\u9664\u8868\u7684\u63d0\u793a\u3002<\/p>\n
\u4e3e\u4f8b1\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> DELETE CHECKPOINTTABLE ogg.checkpointtable\nThis checkpoint table may be required for other installations.  Are you sure you want to delete this checkpoint table? yes\n\nSuccessfully deleted checkpoint table ogg.checkpointtable.<\/code><\/pre>\n
\u4e3e\u4f8b2\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> view params .\/GLOBALS\n\nGGSCHEMA ogg\nCHECKPOINTTABLE ogg.checkpointtable\n\nGGSCI (oracle11g as ogg@orcl) 3> DELETE CHECKPOINTTABLE\n\nNo checkpoint table specified. Using GLOBALS specification ogg.checkpointtable...\nThis checkpoint table may be required for other installations.  Are you sure you want to delete this checkpoint table? yes\n\nSuccessfully deleted checkpoint table ogg.checkpointtable.<\/code><\/pre>\n
\u4e3e\u4f8b3\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> DELETE CHECKPOINTTABLE ogg.checkpointtable !\n\nSuccessfully deleted checkpoint table ogg.checkpointtable.<\/code><\/pre>\n
\u4e3e\u4f8b4\uff1a<\/p>\n
\u8981\u5728\u5173\u8054\u7684\u590d\u5236\u7ec4\u4fdd\u6301\u6d3b\u52a8\u72b6\u6001\u65f6\u505c\u6b62\u4f7f\u7528\u68c0\u67e5\u70b9\u8868\uff0c\u8bf7\u6309\u7167\u4e0b\u5217\u6b65\u9aa4\u64cd\u4f5c\uff1a\n1.\u8fd0\u884cGGSCI\u6216\u7ba1\u7406\u5ba2\u6237\u7aef\u3002\n2.\u505c\u6b62\u590d\u5236\u3002\nSTOP REPLICAT group\n3.\u5220\u9664\u201c\u590d\u5236\u201d\u7ec4\uff0c\u7136\u540e\u4f7f\u7528\u4ee5\u4e0b\u547d\u4ee4\u5c06\u5176\u91cd\u65b0\u6dfb\u52a0\u3002\nDELETE REPLICAT group\nADD REPLICAT group, EXTTRAIL trail, NODBCHECKPOINT\n4.\u9000\u51faGGSCI\u6216Admin Client\uff0c\u7136\u540e\u91cd\u65b0\u542f\u52a8\u3002\n5.\u518d\u6b21\u542f\u52a8\u590d\u5236\u3002\nSTART REPLICAT group\n6.\u4f7f\u7528\u6570\u636e\u5e93DBLOGIN\u7684\u9002\u5f53\u8eab\u4efd\u9a8c\u8bc1\u9009\u9879\uff0c\u4f7f\u7528\u547d\u4ee4\u767b\u5f55\u6570\u636e\u5e93\u3002\u4f7f\u7528\u6570\u636e\u5e93DBLOGIN\u7684\u9002\u5f53\u8eab\u4efd\u9a8c\u8bc1\u9009\u9879\uff0c\u4f7f\u7528\u547d\u4ee4\u767b\u5f55\u6570\u636e\u5e93\u3002\n7.\u4f7f\u7528\u5220\u9664\u68c0\u67e5\u70b9\u8868DELETE CHECKPOINTTABLE\u3002\n\u5982\u679c\u5728Replicat\u4ecd\u5728\u8fd0\u884c\u4e14\u6b63\u5728\u53d1\u751f\u4e8b\u52a1\u7684\u540c\u65f6\u5220\u9664\u4e86\u68c0\u67e5\u70b9\u8868\uff0c\u5219Replicat\u4f1a\u5f02\u5e38\u7ed3\u675f\uff0c\u5e76\u51fa\u73b0\u4e00\u4e2a\u9519\u8bef\uff0c\u5373\u627e\u4e0d\u5230\u68c0\u67e5\u70b9\u8868\u3002\u4f46\u662f\uff0c\u68c0\u67e5\u70b9\u4ecd\u4fdd\u7559\u5728\u78c1\u76d8\u4e0a\u7684\u68c0\u67e5\u70b9\u6587\u4ef6\u4e2d\u3002\u8981\u6062\u590d\u5904\u7406\uff0c\u8bf7\u4ee5\u76f8\u540c\u7684\u540d\u79f0\u91cd\u65b0\u6dfb\u52a0\u68c0\u67e5\u70b9\u8868\u3002\u8ddf\u8e2a\u4e2d\u7684\u6570\u636e\u5c06\u7ee7\u7eed\u590d\u5236\u3002\u7136\u540e\uff0c\u60a8\u53ef\u4ee5\u5220\u9664\u68c0\u67e5\u70b9\u8868\u3002<\/code><\/pre>\n
4\u3001INFO CHECKPOINTTABLE<\/h1>\n
\u5bf9\u4e8eJava\u590d\u5236\uff0cOracle GoldenGate\u5e94\u7528\u7a0b\u5e8f\u9002\u914d\u5668\u6216Oracle GoldenGate\u5927\u6570\u636e\u65e0\u6548\u3002<\/p>\n
\u4f7f\u7528INFO CHECKPOINTTABLE\u786e\u8ba4\u68c0\u67e5\u70b9\u8868\u7684\u5b58\u5728\u548c\u67e5\u770b\u65e5\u671f\u548c\u5b83\u7684\u521b\u5efa\u65f6\u95f4\u3002<\/p>\n
\u4f7f\u7528\u6b64\u547d\u4ee4\u4e4b\u524d\uff0c\u8bf7\u4f7f\u7528DBLOGIN\u8be5\u547d\u4ee4\u5efa\u7acb\u6570\u636e\u5e93\u8fde\u63a5\u3002<\/p>\n
\u8bed\u6cd5\uff1a
\nINFO CHECKPOINTTABLE [[container. | catalog.]owner.table]<\/p>\n
container. | catalog.
\nOracle\u53ef\u63d2\u62d4\u6570\u636e\u5e93\uff08\u5982\u679c\u9002\u7528\uff09\u3002\u5982\u679c\u8fd9\u4e2a\u9009\u9879\u88ab\u5ffd\u7565\uff0c\u4ea7\u54c1\u76ee\u5f55\u6216\u6570\u636e\u5e93\u53ef\u63d2\u62d4\u9ed8\u8ba4\u4e3a\u4e0e\u8be5\u76f8\u5173\u8054\u7684\u4e00\u4e2aSOURCEDB\uff0c USERID\u6216USERIDALIAS\u6240\u8ff0\u7684\u90e8\u5206DBLOGIN\u547d\u4ee4\uff08\u53d6\u51b3\u4e8e\u6570\u636e\u5e93\uff09\u3002<\/p>\n
owner.table
\n\u68c0\u67e5\u70b9\u8868\u7684\u6240\u6709\u8005\u548c\u540d\u79f0\u3002\u5982\u679c\u6240\u6709\u8005\u548c\u540d\u79f0\u4e0e\u6587\u4ef6\u4e2d\u7684CHECKPOINTTABLE\u53c2\u6570 \u6307\u5b9a\u7684\u540d\u79f0\u548c\u540d\u79f0\u76f8\u540c\uff0c\u5219\u4e0d\u9700\u8981\u8fd9\u4e9b\u540d\u79f0 GLOBALS\u3002\u60a8\u53ef\u4ee5\u4f7f\u7528\u901a\u914d\u7b26\uff08*\uff09\u3002<\/p>\n
\u4e3e\u4f8b1\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> INFO CHECKPOINTTABLE ogg.checkpointtable\n\nCheckpoint table ogg.checkpointtable created 2017-11-26 10:46:43.<\/code><\/pre>\n
5\u3001UPGRADE CHECKPOINTTABLE<\/h1>\n
\u5bf9\u4e8eJava\u590d\u5236\uff0cOracle GoldenGate\u5e94\u7528\u7a0b\u5e8f\u9002\u914d\u5668\u6216Oracle GoldenGate\u5927\u6570\u636e\u65e0\u6548\u3002<\/p>\n
\u5347\u7ea7Oracle GoldenGate\u65f6\uff0c\u4f7f\u7528UPGRADE CHECKPOINTTABLE\u547d\u4ee4\u6dfb\u52a0\u8865\u5145\u68c0\u67e5\u70b9\u8868\u3002<\/p>\n
\u8bed\u6cd5\uff1a
\nUPGRADE CHECKPOINTTABLE [[container. | catalog.]owner.table]<\/p>\n
container. | catalog.
\nOracle\u53ef\u63d2\u62d4\u6570\u636e\u5e93\u6216SQL \/ MX\u76ee\u5f55\uff08\u5982\u679c\u9002\u7528\uff09\u3002\u5982\u679c\u8fd9\u4e2a\u9009\u9879\u88ab\u5ffd\u7565\uff0c\u4ea7\u54c1\u76ee\u5f55\u6216\u6570\u636e\u5e93\u53ef\u63d2\u62d4\u9ed8\u8ba4\u4e3a\u4e0e\u8be5\u76f8\u5173\u8054\u7684\u4e00\u4e2a SOURCEDB\uff0cUSERID\u6216 USERIDALIAS\u6240\u8ff0\u7684\u90e8\u5206DBLOGIN \u547d\u4ee4\uff08\u53d6\u51b3\u4e8e\u6570\u636e\u5e93\uff09\u3002<\/p>\n
owner.table
\n\u68c0\u67e5\u70b9\u8868\u7684\u6240\u6709\u8005\u548c\u540d\u79f0\u3002\u5982\u679c\u6240\u6709\u8005\u548c\u540d\u79f0\u4e0e\u6587\u4ef6\u4e2d\u7684CHECKPOINTTABLE\u53c2\u6570 \u6307\u5b9a\u7684\u540d\u79f0\u548c\u540d\u79f0\u76f8\u540c\uff0c\u5219\u4e0d\u9700\u8981\u8fd9\u4e9b\u540d\u79f0 GLOBALS\u3002<\/p>\n
\u4e3e\u4f8b1\uff1a<\/p>\n
GGSCI (oracle11g) 1> dblogin userid ogg, password ogg\nSuccessfully logged into database.\n\nGGSCI (oracle11g as ogg@orcl) 2> UPGRADE CHECKPOINTTABLE ogg.checkpointtable\n\nUpgrade operation was not performed because the checkpoint table ogg.checkpointtable is already upgraded.<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
1\u3001ADD CHECKPOINTTABLE \u5bf9\u4e8eJ<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-293","post","type-post","status-publish","format-standard","hentry","category-ogg"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=293"}],"version-history":[{"count":4,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions"}],"predecessor-version":[{"id":1165,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/293\/revisions\/1165"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}