{"id":1018,"date":"2020-12-15T10:09:59","date_gmt":"2020-12-15T02:09:59","guid":{"rendered":"https:\/\/raksmart.cn\/blog\/?p=1018"},"modified":"2020-12-15T10:10:01","modified_gmt":"2020-12-15T02:10:01","slug":"ogg%e7%9a%84%e5%ae%89%e8%a3%85%e4%b8%8e%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/raksmart.cn\/blog\/knowledge\/1018.html","title":{"rendered":"ogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e"},"content":{"rendered":"\n

\u3000OGG \u662f\u4e00\u79cd\u57fa\u4e8e\u65e5\u5fd7\u7684\u7ed3\u6784\u5316\u6570\u636e\u590d\u5236\u8f6f\u4ef6,\u80fd\u591f\u5b9e\u73b0\u5927\u91cf\u4ea4\u6613\u6570\u636e\u7684\u5b9e\u65f6\u6355\u6349\uff0c\u53d8\u6362\u548c\u6295\u9012\uff0c\u5b9e\u73b0\u6e90\u6570\u636e\u5e93\u4e0e\u76ee\u6807\u6570\u636e\u5e93\u7684\u6570\u636e\u540c\u6b65\uff0c\u4fdd\u6301\u6700\u5c1110ms\u7684\u6570\u636e\u5ef6\u8fdf\u3002\u672c\u6587raksmart\u7f8e\u56fd\u670d\u52a1\u5668<\/a><\/strong>\u5c06\u4ecb\u7ecdogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e<\/p>\n\n\n\n

\u4e00\u3001\u5b89\u88c5Oracle goldengate<\/p>\n\n\n\n

\u76f4\u63a5\u89e3\u538b\u5373\u53ef<\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ ls<\/p>\n\n\n\n

fbo_ggs_Linux_x86_ora11g_32bit.tar <\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ tar -xvf\nfbo_ggs_Linux_x86_ora11g_32bit.tar<\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ rm -rf\nfbo_ggs_Linux_x86_ora11g_32bit.tar<\/p>\n\n\n\n

\u4e8c\u3001\u6570\u636e\u5e93\u4e2d\u7684\u914d\u7f6e\u4e0e\u51c6\u5907<\/p>\n\n\n\n

\u6253\u5f00\u6570\u636e\u5e93\u6700\u5c0f\u9644\u52a0\u65e5\u5fd7\uff08\u6e90\u7aef\uff09<\/p>\n\n\n\n

SQL> select supplemental_log_data_min\nfrom v$database;<\/p>\n\n\n\n

SUPPLEME<\/p>\n\n\n\n

——–<\/p>\n\n\n\n

NO<\/p>\n\n\n\n

SQL> alter database add supplemental log\ndata;<\/p>\n\n\n\n

Database altered.<\/p>\n\n\n\n

SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;<\/p>\n\n\n\n

System altered.<\/p>\n\n\n\n

\u5efa\u7acbOGG\u6570\u636e\u5e93\u7528\u6237\u5e76\u6388\u4e88\u6743\u9650\uff08\u6e90\u7aef\uff09 \u63a8\u8350\u9605\u8bfb\uff1aCPANEL\u4e0eWHM\u7684\u533a\u522b<\/a><\/p>\n\n\n\n

SQL> CREATE USER goldengate IDENTIFIED\nBY goldengate;<\/p>\n\n\n\n

User created.<\/p>\n\n\n\n

SQL> GRANT CONNECT TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT CREATE SESSION TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT ALTER SESSION TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT RESOURCE TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT SELECT ANY DICTIONARY TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT SELECT ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT FLASHBACK ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT ALTER ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

\u5efa\u7acbOGG\u6570\u636e\u5e93\u7528\u6237\u5e76\u6388\u4e88\u6743\u9650\uff08\u76ee\u6807\u7aef\uff09<\/p>\n\n\n\n

\u8fd9\u91ccgoldengate\u6240\u9700\u8981\u7684\u6743\u9650\u8981\u6bd4\u6e90\u7aef\u7684\u591a \u63a8\u8350\u9605\u8bfb\uff1aRLWRAP\u7684\u5b89\u88c5\u4e0e\u6ce8\u610f\u4e8b\u9879<\/a><\/p>\n\n\n\n

SQL> CREATE USER goldengate IDENTIFIED\nBY goldengate;<\/p>\n\n\n\n

User created.<\/p>\n\n\n\n

SQL> GRANT ALTER SESSION TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT CREATE SESSION TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT CONNECT TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT RESOURCE TO goldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT SELECT ANY DICTIONARY TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT SELECT ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT FLASHBACK ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT INSERT ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT UPDATE ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

SQL> GRANT DELETE ANY TABLE TO\ngoldengate;<\/p>\n\n\n\n

Grant succeeded.<\/p>\n\n\n\n

\u4e09\u3001goldengate\u4e2d\u7684\u914d\u7f6e<\/p>\n\n\n\n

1.\u76ee\u6807\u548c\u6e90\u7684\u51c6\u5907<\/p>\n\n\n\n

\u6267\u884c.\/ggsci<\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ .\/ggsci<\/p>\n\n\n\n

.\/ggsci: error while loading shared\nlibraries: libnnz11.so: cannot open shared object file: No such file or\ndirectory<\/p>\n\n\n\n

ps\uff1a\u82e5\u662f\u62a5\u9519\uff0c\u5728oracle\u7684profile\u6587\u4ef6\u52a0\u5165\u4e00\u884c\u8bed\u53e5\u5373\u53ef \u66f4\u591a\u5185\u5bb9\u8bf7\u9605\u8bfb\uff1a\u4ec0\u4e48\u662fWEB SERVICE\uff1f<\/a><\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ vi\n\/home\/oracle\/profile<\/p>\n\n\n\n

export LD_LIBRARY_PATH=$ORACLE_HOME\/lib<\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ .\n\/home\/oracle\/profile<\/p>\n\n\n\n

[oracle@tomato-@ORACLE_SID ggs]$ .\/ggsci<\/p>\n\n\n\n

Oracle GoldenGate Command Interpreter for\nOracle<\/p>\n\n\n\n

Version 11.2.1.0.1\nOGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO<\/p>\n\n\n\n

Linux, x86, 32bit (optimized), Oracle 11g\non Apr 23 2012 08:09:25<\/p>\n\n\n\n

Copyright (C) 1995, 2012, Oracle and\/or its\naffiliates. All rights reserved.<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 1><\/p>\n\n\n\n

\u521b\u5efa\u6240\u9700\u6587\u4ef6\u5939<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 1> create\nsubdirs<\/p>\n\n\n\n

Creating subdirectories under current\ndirectory \/oracle\/ggs<\/p>\n\n\n\n

Parameter files \/oracle\/ggs\/dirprm: already\nexists<\/p>\n\n\n\n

Report files \/oracle\/ggs\/dirrpt: created<\/p>\n\n\n\n

Checkpoint files \/oracle\/ggs\/dirchk:\ncreated<\/p>\n\n\n\n

Process status files \/oracle\/ggs\/dirpcs:\ncreated<\/p>\n\n\n\n

SQL script files \/oracle\/ggs\/dirsql:\ncreated<\/p>\n\n\n\n

Database definitions files\n\/oracle\/ggs\/dirdef: created<\/p>\n\n\n\n

Extract data files \/oracle\/ggs\/dirdat: created<\/p>\n\n\n\n

Temporary files \/oracle\/ggs\/dirtmp: created<\/p>\n\n\n\n

Stdout files \/oracle\/ggs\/dirout: created<\/p>\n\n\n\n

\u914d\u7f6eManager\u8fdb\u7a0b\u5e76\u6253\u5f00<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 2> edit param\nmgr<\/p>\n\n\n\n

port 7809              –\u6307\u5b9a\u7aef\u53e3\u53f7<\/p>\n\n\n\n

GGSCI (linfan) 7> START MGR<\/p>\n\n\n\n

Manager started.<\/p>\n\n\n\n

2.\u76ee\u6807\u7aef\u7684\u914d\u7f6e<\/p>\n\n\n\n

\u52a0\u5165trandata\uff08\u8868\u7ea7\u9644\u52a0\u65e5\u5fd7\uff09<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 4> dblogin\nuserid goldengate , password goldengate<\/p>\n\n\n\n

Successfully logged into database.<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 5> add\ntrandata lala.*<\/p>\n\n\n\n

2017-03-06 20:11:24 WARNING OGG-00869 No\nunique key is defined for table ‘STUDENT’. All viable columns will be used to\nrepresent the key, but may not guarantee uniqueness. KEYCOLS may be used to\ndefine the key.<\/p>\n\n\n\n

Logging of supplemental redo data enabled\nfor table LALA.STUDENT.<\/p>\n\n\n\n

ps\uff1a\u8fd9\u91cc\u7684WARNING\u662f\u56e0\u4e3alala\u7528\u6237\u4e0b\u7684student\u8868\u6ca1\u6709\u4e3b\u952e\uff0c\u6240\u4ee5\u628a\u6240\u6709\u7684\u5217\u90fd\u52a0\u5165\u9644\u52a0\u65e5\u5fd7 \u4e86\u89e3\u66f4\u591a\u76f8\u5173\u77e5\u8bc6\u8bf7\u9605\u8bfb\uff1a\u4ec0\u4e48\u662fWORDPRESS\uff1f<\/a><\/p>\n\n\n\n

\u6dfb\u52a0EXTRACT\u8fdb\u7a0b\u5e76\u914d\u7f6e<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 6> ADD EXTRACT\ncapdb1, TRANLOG, BEGIN NOW                         —\u6dfb\u52a0\u8fdb\u7a0b<\/p>\n\n\n\n

EXTRACT added.<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 7> ADD\nEXTTRAIL \/oracle\/ggs\/dirdat\/lt, EXTRACT capdb1             —\u6539\u8fdb\u4f7f\u7528\u672c\u5730\u961f\u5217<\/p>\n\n\n\n

EXTTRAIL added.<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 8> EDIT PARAM\ncapdb1                                             \n—\u914d\u7f6e\u8fdb\u7a0b\u53c2\u6570<\/p>\n\n\n\n

EXTRACT capdb1<\/p>\n\n\n\n

SETENV (ORACLE_HOME =\n“\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1”)<\/p>\n\n\n\n

SETENV (ORACLE_SID = DB1) <\/p>\n\n\n\n

USERID goldengate, PASSWORD goldengate<\/p>\n\n\n\n

EXTTRAIL \/oracle\/ggs\/dirdat\/lt<\/p>\n\n\n\n

TABLE lala.*<\/p>\n\n\n\n

\u6dfb\u52a0\u914d\u7f6epump\u8fdb\u7a0b<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 9> ADD EXTRACT\npumpdb12, EXTTRAILSOURCE \/oracle\/ggs\/dirdat\/lt, BEGIN NOW<\/p>\n\n\n\n

EXTRACT added.<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 10> ADD\nRMTTRAIL \/oracle\/ggs\/dirdat\/rt, EXTRACT pumpdb12<\/p>\n\n\n\n

RMTTRAIL added.<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 11> EDIT PARAM\npumpdb12<\/p>\n\n\n\n

EXTRACT pumpdb12<\/p>\n\n\n\n

SETENV (ORACLE_HOME =\n“\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1”) <\/p>\n\n\n\n

SETENV (ORACLE_SID = DB1) <\/p>\n\n\n\n

USERID goldengate, PASSWORD goldengate<\/p>\n\n\n\n

RMTHOST tomato, MGRPORT 7809<\/p>\n\n\n\n

rmttrail \/oracle\/ggs\/dirdat\/rt<\/p>\n\n\n\n

TABLE lala.*<\/p>\n\n\n\n

\u5c06\u914d\u7f6e\u597d\u7684\u4e24\u4e2a\u8fdb\u7a0b\u5f00\u542f<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 49> start\ncapdb1<\/p>\n\n\n\n

Sending START request to MANAGER …<\/p>\n\n\n\n

EXTRACT CAPDB1 starting<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 50> start\npumpdb12<\/p>\n\n\n\n

Sending START request to MANAGER …<\/p>\n\n\n\n

EXTRACT PUMPDB12 starting<\/p>\n\n\n\n

GGSCI (potato.oracle.com) 51> info all<\/p>\n\n\n\n

Program Status Group Lag at Chkpt Time\nSince Chkpt<\/p>\n\n\n\n

MANAGER RUNNING <\/p>\n\n\n\n

EXTRACT RUNNING CAPDB1 00:38:04 00:00:01 <\/p>\n\n\n\n

EXTRACT RUNNING PUMPDB12 00:00:00 00:00:00<\/p>\n\n\n\n

3.\u914d\u7f6e\u6e90\u7aef<\/p>\n\n\n\n

\u6dfb\u52a0\u8fdb\u7a0bREPLICAT\u8fdb\u7a0b<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 10> dblogin\nuserid goldengate , password goldengate                   —\u9996\u5148\u5148\u8981\u767b\u5f55<\/p>\n\n\n\n

Successfully logged into database.<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 11> ADD\nCHECKPOINTTABLE goldengate.checkpoint                          —\u6dfb\u52a0\u68c0\u67e5\u70b9\u8868<\/p>\n\n\n\n

Successfully created checkpoint table\ngoldengate.checkpoint.<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 12> ADD\nREPLICAT repdb2, EXTTRAIL \/oracle\/ggs\/dirdat\/rt, BEGIN NOW, CHECKPOINTTABLE\ngoldengate.checkpoint<\/p>\n\n\n\n

REPLICAT added.                                                   \n                            —\u6dfb\u52a0REPLICAT\u8fdb\u7a0b\uff0c\u5e76\u4e14\u4f7f\u7528CHECKPOINTTABLE\u65b9\u5f0f<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 13> EDIT PARAM\nrepdb2                                               \n—\u914d\u7f6eREPLICAT\u8fdb\u7a0b<\/p>\n\n\n\n

REPLICAT repdb2<\/p>\n\n\n\n

SETENV (ORACLE_HOME =\n“\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1”)<\/p>\n\n\n\n

SETENV (ORACLE_SID = DB2)<\/p>\n\n\n\n

ASSUMETARGETDEFS<\/p>\n\n\n\n

USERID goldengate, PASSWORD goldengate<\/p>\n\n\n\n

MAP lala.*, TARGET lala.*<\/p>\n\n\n\n

\u5f00\u542f\u8be5\u8fdb\u7a0b<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 14> start\nrepdb2<\/p>\n\n\n\n

Sending START request to MANAGER …<\/p>\n\n\n\n

REPLICAT REPDB2 starting<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 15> info all<\/p>\n\n\n\n

Program Status Group Lag at Chkpt Time\nSince Chkpt<\/p>\n\n\n\n

MANAGER RUNNING <\/p>\n\n\n\n

REPLICAT RUNNING REPDB2 00:00:00 00:00:03<\/p>\n\n\n\n

\u56db\u3001\u8fdb\u884c\u73af\u5883\u6d4b\u8bd5<\/p>\n\n\n\n

\u6e90\u7aef\u63d2\u5165\u4e00\u6761\u6570\u636e<\/p>\n\n\n\n

SQL> insert into student\nvalues(1,’zhangsan’);<\/p>\n\n\n\n

1 row created.<\/p>\n\n\n\n

SQL> commit<\/p>\n\n\n\n

Commit complete.<\/p>\n\n\n\n

\u76ee\u6807\u7aef\u67e5\u770b\u5f97\u5230\u8fd9\u6761\u6570\u636e<\/p>\n\n\n\n

GGSCI (tomato.oracle.com) 18> stats\nrepdb2<\/p>\n\n\n\n

Sending STATS request to REPLICAT REPDB2\n…<\/p>\n\n\n\n

Start of Statistics at 2017-03-06 23:49:04.<\/p>\n\n\n\n

Replicating from LALA.STUDENT to\nLALA.STUDENT:<\/p>\n\n\n\n

*** Total statistics since 2017-03-06\n21:42:56 ***<\/p>\n\n\n\n

       \nTotal inserts 1.00<\/p>\n\n\n\n

        Total updates 0.00<\/p>\n\n\n\n

       \nTotal deletes 0.00<\/p>\n\n\n\n

       \nTotal discards 0.00<\/p>\n\n\n\n

       \nTotal operations 1.00<\/p>\n\n\n\n

*** Daily statistics since 2017-03-06\n21:42:56 ***<\/p>\n\n\n\n

       \nTotal inserts 1.00<\/p>\n\n\n\n

       \nTotal updates 0.00<\/p>\n\n\n\n

       \nTotal deletes 0.00<\/p>\n\n\n\n

       \nTotal discards 0.00<\/p>\n\n\n\n

       \nTotal operations 1.00<\/p>\n\n\n\n

*** Hourly statistics since 2017-03-06\n23:00:00 ***<\/p>\n\n\n\n

       \nNo database operations have been performed.<\/p>\n\n\n\n

*** Latest statistics since 2017-03-06\n21:42:56 ***<\/p>\n\n\n\n

       \nTotal inserts 1.00<\/p>\n\n\n\n

       \nTotal updates 0.00<\/p>\n\n\n\n

       \nTotal deletes 0.00<\/p>\n\n\n\n

       \nTotal discards 0.00<\/p>\n\n\n\n

       \nTotal operations 1.00<\/p>\n\n\n\n

End of Statistics.<\/p>\n\n\n\n

SQL> select * from student;<\/p>\n\n\n\n

       \nID NAME<\/p>\n\n\n\n

———- —————<\/p>\n\n\n\n

        \n1 zhangsan<\/p>\n\n\n\n

\u73af\u5883\u642d\u5efa\u6210\u529f \u66f4\u591a\u5185\u5bb9\u8bf7\u9605\u8bfb\uff1a\u4ec0\u4e48\u662fDOCKER<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u3000OGG \u662f\u4e00\u79cd\u57fa\u4e8e\u65e5\u5fd7\u7684\u7ed3\u6784\u5316\u6570\u636e\u590d\u5236\u8f6f\u4ef6,\u80fd\u591f\u5b9e\u73b0\u5927\u91cf\u4ea4\u6613\u6570\u636e\u7684\u5b9e\u65f6\u6355\u6349\uff0c\u53d8\u6362\u548c\u6295\u9012\uff0c\u5b9e\u73b0\u6e90\u6570\u636e… \u7ee7\u7eed\u9605\u8bfb ogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e<\/span><\/i><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[156],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1018"}],"collection":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/comments?post=1018"}],"version-history":[{"count":1,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1018\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/posts\/1018\/revisions\/1019"}],"wp:attachment":[{"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/media?parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/categories?post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raksmart.cn\/blog\/wp-json\/wp\/v2\/tags?post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}