{"id":1018,"date":"2024-06-05T20:33:20","date_gmt":"2024-06-05T12:33:20","guid":{"rendered":"https:\/\/cn.raksmart.com\/blog\/host\/4142.html"},"modified":"2024-06-05T20:33:20","modified_gmt":"2024-06-05T12:33:20","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:\/\/cn.raksmart.com\/blog\/knowledge\/1018.html","title":{"rendered":"ogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e"},"content":{"rendered":"<div class=\"entry-content e-content\" itemprop=\"description articleBody\">\n<p>\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\u6587<strong>raksmart<a rel=\"noreferrer noopener\" aria-label=\"\u7f8e\u56fd\u670d\u52a1\u5668\uff08\u5728\u65b0\u7a97\u53e3\u6253\u5f00\uff09\" href=\"https:\/\/cn.raksmart.com\/\" target=\"_blank\">\u7f8e\u56fd\u670d\u52a1\u5668<\/a><\/strong>\u5c06\u4ecb\u7ecdogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e<\/p>\n<p class=\"has-text-color has-vivid-red-color\">\u4e00\u3001\u5b89\u88c5Oracle goldengate<\/p>\n<p>\u76f4\u63a5\u89e3\u538b\u5373\u53ef<\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ ls<\/p>\n<p>fbo_ggs_Linux_x86_ora11g_32bit.tar <\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ tar -xvf<br \/>\nfbo_ggs_Linux_x86_ora11g_32bit.tar<\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ rm -rf<br \/>\nfbo_ggs_Linux_x86_ora11g_32bit.tar<\/p>\n<p class=\"has-text-color has-vivid-red-color\">\u4e8c\u3001\u6570\u636e\u5e93\u4e2d\u7684\u914d\u7f6e\u4e0e\u51c6\u5907<\/p>\n<p>\u6253\u5f00\u6570\u636e\u5e93\u6700\u5c0f\u9644\u52a0\u65e5\u5fd7\uff08\u6e90\u7aef\uff09<\/p>\n<p>SQL&gt; select supplemental_log_data_min<br \/>\nfrom v$database;<\/p>\n<p>SUPPLEME<\/p>\n<p>\u2014\u2014\u2013<\/p>\n<p>NO<\/p>\n<p>SQL&gt; alter database add supplemental log<br \/>\ndata;<\/p>\n<p>Database altered.<\/p>\n<p>SQL&gt; ALTER SYSTEM ARCHIVE LOG CURRENT;<\/p>\n<p>System altered.<\/p>\n<p>\u5efa\u7acbOGG\u6570\u636e\u5e93\u7528\u6237\u5e76\u6388\u4e88\u6743\u9650\uff08\u6e90\u7aef\uff09   \u63a8\u8350\u9605\u8bfb\uff1a<a href=\"https:\/\/cn.raksmart.com\/blog\/knowledge\/1002.html\">CPANEL\u4e0eWHM\u7684\u533a\u522b<\/a><\/p>\n<p>SQL&gt; CREATE USER goldengate IDENTIFIED<br \/>\nBY goldengate;<\/p>\n<p>User created.<\/p>\n<p>SQL&gt; GRANT CONNECT TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT CREATE SESSION TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT ALTER SESSION TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT RESOURCE TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT SELECT ANY DICTIONARY TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT SELECT ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT FLASHBACK ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT ALTER ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>\u5efa\u7acbOGG\u6570\u636e\u5e93\u7528\u6237\u5e76\u6388\u4e88\u6743\u9650\uff08\u76ee\u6807\u7aef\uff09<\/p>\n<p>\u8fd9\u91ccgoldengate\u6240\u9700\u8981\u7684\u6743\u9650\u8981\u6bd4\u6e90\u7aef\u7684\u591a  \u63a8\u8350\u9605\u8bfb\uff1a<a href=\"https:\/\/cn.raksmart.com\/blog\/knowledge\/974.html\">RLWRAP\u7684\u5b89\u88c5\u4e0e\u6ce8\u610f\u4e8b\u9879<\/a><\/p>\n<p>SQL&gt; CREATE USER goldengate IDENTIFIED<br \/>\nBY goldengate;<\/p>\n<p>User created.<\/p>\n<p>SQL&gt; GRANT ALTER SESSION TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT CREATE SESSION TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT CONNECT TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT RESOURCE TO goldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT SELECT ANY DICTIONARY TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT SELECT ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT FLASHBACK ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT INSERT ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT UPDATE ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p>SQL&gt; GRANT DELETE ANY TABLE TO<br \/>\ngoldengate;<\/p>\n<p>Grant succeeded.<\/p>\n<p class=\"has-text-color has-vivid-red-color\">\u4e09\u3001goldengate\u4e2d\u7684\u914d\u7f6e<\/p>\n<p>1.\u76ee\u6807\u548c\u6e90\u7684\u51c6\u5907<\/p>\n<p>\u6267\u884c.\/ggsci<\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ .\/ggsci<\/p>\n<p>.\/ggsci: error while loading shared<br \/>\nlibraries: libnnz11.so: cannot open shared object file: No such file or<br \/>\ndirectory<\/p>\n<p>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<a href=\"https:\/\/cn.raksmart.com\/blog\/knowledge\/943.html\">\u4ec0\u4e48\u662fWEB SERVICE\uff1f<\/a><\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ vi<br \/>\n\/home\/oracle\/profile<\/p>\n<p>export LD_LIBRARY_PATH=$ORACLE_HOME\/lib<\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ .<br \/>\n\/home\/oracle\/profile<\/p>\n<p>[oracle@tomato-@ORACLE_SID ggs]$ .\/ggsci<\/p>\n<p>Oracle GoldenGate Command Interpreter for<br \/>\nOracle<\/p>\n<p>Version 11.2.1.0.1<br \/>\nOGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO<\/p>\n<p>Linux, x86, 32bit (optimized), Oracle 11g<br \/>\non Apr 23 2012 08:09:25<\/p>\n<p>Copyright (C) 1995, 2012, Oracle and\/or its<br \/>\naffiliates. All rights reserved.<\/p>\n<p>GGSCI (tomato.oracle.com) 1&gt;<\/p>\n<p>\u521b\u5efa\u6240\u9700\u6587\u4ef6\u5939<\/p>\n<p>GGSCI (tomato.oracle.com) 1&gt; create<br \/>\nsubdirs<\/p>\n<p>Creating subdirectories under current<br \/>\ndirectory \/oracle\/ggs<\/p>\n<p>Parameter files \/oracle\/ggs\/dirprm: already<br \/>\nexists<\/p>\n<p>Report files \/oracle\/ggs\/dirrpt: created<\/p>\n<p>Checkpoint files \/oracle\/ggs\/dirchk:<br \/>\ncreated<\/p>\n<p>Process status files \/oracle\/ggs\/dirpcs:<br \/>\ncreated<\/p>\n<p>SQL script files \/oracle\/ggs\/dirsql:<br \/>\ncreated<\/p>\n<p>Database definitions files<br \/>\n\/oracle\/ggs\/dirdef: created<\/p>\n<p>Extract data files \/oracle\/ggs\/dirdat: created<\/p>\n<p>Temporary files \/oracle\/ggs\/dirtmp: created<\/p>\n<p>Stdout files \/oracle\/ggs\/dirout: created<\/p>\n<p>\u914d\u7f6eManager\u8fdb\u7a0b\u5e76\u6253\u5f00<\/p>\n<p>GGSCI (potato.oracle.com) 2&gt; edit param<br \/>\nmgr<\/p>\n<p>port 7809\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2013\u6307\u5b9a\u7aef\u53e3\u53f7<\/p>\n<p>GGSCI (linfan) 7&gt; START MGR<\/p>\n<p>Manager started.<\/p>\n<p>2.\u76ee\u6807\u7aef\u7684\u914d\u7f6e<\/p>\n<p>\u52a0\u5165trandata\uff08\u8868\u7ea7\u9644\u52a0\u65e5\u5fd7\uff09<\/p>\n<p>GGSCI (potato.oracle.com) 4&gt; dblogin<br \/>\nuserid goldengate , password goldengate<\/p>\n<p>Successfully logged into database.<\/p>\n<p>GGSCI (potato.oracle.com) 5&gt; add<br \/>\ntrandata lala.*<\/p>\n<p>2017-03-06 20:11:24 WARNING OGG-00869 No<br \/>\nunique key is defined for table \u2018STUDENT\u2019. All viable columns will be used to<br \/>\nrepresent the key, but may not guarantee uniqueness. KEYCOLS may be used to<br \/>\ndefine the key.<\/p>\n<p>Logging of supplemental redo data enabled<br \/>\nfor table LALA.STUDENT.<\/p>\n<p>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<a href=\"https:\/\/cn.raksmart.com\/blog\/website\/wordpress\/835.html\">\u4ec0\u4e48\u662fWORDPRESS\uff1f<\/a><\/p>\n<p>\u6dfb\u52a0EXTRACT\u8fdb\u7a0b\u5e76\u914d\u7f6e<\/p>\n<p>GGSCI (potato.oracle.com) 6&gt; ADD EXTRACT<br \/>\ncapdb1, TRANLOG, BEGIN NOW\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2014\u6dfb\u52a0\u8fdb\u7a0b<\/p>\n<p>EXTRACT added.<\/p>\n<p>GGSCI (potato.oracle.com) 7&gt; ADD<br \/>\nEXTTRAIL \/oracle\/ggs\/dirdat\/lt, EXTRACT capdb1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2014\u6539\u8fdb\u4f7f\u7528\u672c\u5730\u961f\u5217<\/p>\n<p>EXTTRAIL added.<\/p>\n<p>GGSCI (potato.oracle.com) 8&gt; EDIT PARAM<br \/>\ncapdb1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\n\u2014\u914d\u7f6e\u8fdb\u7a0b\u53c2\u6570<\/p>\n<p>EXTRACT capdb1<\/p>\n<p>SETENV (ORACLE_HOME =<br \/>\n\u201c\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\u201d)<\/p>\n<p>SETENV (ORACLE_SID = DB1) <\/p>\n<p>USERID goldengate, PASSWORD goldengate<\/p>\n<p>EXTTRAIL \/oracle\/ggs\/dirdat\/lt<\/p>\n<p>TABLE lala.*<\/p>\n<p>\u6dfb\u52a0\u914d\u7f6epump\u8fdb\u7a0b<\/p>\n<p>GGSCI (potato.oracle.com) 9&gt; ADD EXTRACT<br \/>\npumpdb12, EXTTRAILSOURCE \/oracle\/ggs\/dirdat\/lt, BEGIN NOW<\/p>\n<p>EXTRACT added.<\/p>\n<p>GGSCI (potato.oracle.com) 10&gt; ADD<br \/>\nRMTTRAIL \/oracle\/ggs\/dirdat\/rt, EXTRACT pumpdb12<\/p>\n<p>RMTTRAIL added.<\/p>\n<p>GGSCI (potato.oracle.com) 11&gt; EDIT PARAM<br \/>\npumpdb12<\/p>\n<p>EXTRACT pumpdb12<\/p>\n<p>SETENV (ORACLE_HOME =<br \/>\n\u201c\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\u201d) <\/p>\n<p>SETENV (ORACLE_SID = DB1) <\/p>\n<p>USERID goldengate, PASSWORD goldengate<\/p>\n<p>RMTHOST tomato, MGRPORT 7809<\/p>\n<p>rmttrail \/oracle\/ggs\/dirdat\/rt<\/p>\n<p>TABLE lala.*<\/p>\n<p>\u5c06\u914d\u7f6e\u597d\u7684\u4e24\u4e2a\u8fdb\u7a0b\u5f00\u542f<\/p>\n<p>GGSCI (potato.oracle.com) 49&gt; start<br \/>\ncapdb1<\/p>\n<p>Sending START request to MANAGER \u2026<\/p>\n<p>EXTRACT CAPDB1 starting<\/p>\n<p>GGSCI (potato.oracle.com) 50&gt; start<br \/>\npumpdb12<\/p>\n<p>Sending START request to MANAGER \u2026<\/p>\n<p>EXTRACT PUMPDB12 starting<\/p>\n<p>GGSCI (potato.oracle.com) 51&gt; info all<\/p>\n<p>Program Status Group Lag at Chkpt Time<br \/>\nSince Chkpt<\/p>\n<p>MANAGER RUNNING <\/p>\n<p>EXTRACT RUNNING CAPDB1 00:38:04 00:00:01 <\/p>\n<p>EXTRACT RUNNING PUMPDB12 00:00:00 00:00:00<\/p>\n<p>3.\u914d\u7f6e\u6e90\u7aef<\/p>\n<p>\u6dfb\u52a0\u8fdb\u7a0bREPLICAT\u8fdb\u7a0b<\/p>\n<p>GGSCI (tomato.oracle.com) 10&gt; dblogin<br \/>\nuserid goldengate , password goldengate\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2014\u9996\u5148\u5148\u8981\u767b\u5f55<\/p>\n<p>Successfully logged into database.<\/p>\n<p>GGSCI (tomato.oracle.com) 11&gt; ADD<br \/>\nCHECKPOINTTABLE goldengate.checkpoint\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u2014\u6dfb\u52a0\u68c0\u67e5\u70b9\u8868<\/p>\n<p>Successfully created checkpoint table<br \/>\ngoldengate.checkpoint.<\/p>\n<p>GGSCI (tomato.oracle.com) 12&gt; ADD<br \/>\nREPLICAT repdb2, EXTTRAIL \/oracle\/ggs\/dirdat\/rt, BEGIN NOW, CHECKPOINTTABLE<br \/>\ngoldengate.checkpoint<\/p>\n<p>REPLICAT added.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u2014\u6dfb\u52a0REPLICAT\u8fdb\u7a0b\uff0c\u5e76\u4e14\u4f7f\u7528CHECKPOINTTABLE\u65b9\u5f0f<\/p>\n<p>GGSCI (tomato.oracle.com) 13&gt; EDIT PARAM<br \/>\nrepdb2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\n\u2014\u914d\u7f6eREPLICAT\u8fdb\u7a0b<\/p>\n<p>REPLICAT repdb2<\/p>\n<p>SETENV (ORACLE_HOME =<br \/>\n\u201c\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\u201d)<\/p>\n<p>SETENV (ORACLE_SID = DB2)<\/p>\n<p>ASSUMETARGETDEFS<\/p>\n<p>USERID goldengate, PASSWORD goldengate<\/p>\n<p>MAP lala.*, TARGET lala.*<\/p>\n<p>\u5f00\u542f\u8be5\u8fdb\u7a0b<\/p>\n<p>GGSCI (tomato.oracle.com) 14&gt; start<br \/>\nrepdb2<\/p>\n<p>Sending START request to MANAGER \u2026<\/p>\n<p>REPLICAT REPDB2 starting<\/p>\n<p>GGSCI (tomato.oracle.com) 15&gt; info all<\/p>\n<p>Program Status Group Lag at Chkpt Time<br \/>\nSince Chkpt<\/p>\n<p>MANAGER RUNNING <\/p>\n<p>REPLICAT RUNNING REPDB2 00:00:00 00:00:03<\/p>\n<p class=\"has-text-color has-vivid-red-color\">\u56db\u3001\u8fdb\u884c\u73af\u5883\u6d4b\u8bd5<\/p>\n<p>\u6e90\u7aef\u63d2\u5165\u4e00\u6761\u6570\u636e<\/p>\n<p>SQL&gt; insert into student<br \/>\nvalues(1,\u2019zhangsan\u2019);<\/p>\n<p>1 row created.<\/p>\n<p>SQL&gt; commit<\/p>\n<p>Commit complete.<\/p>\n<p>\u76ee\u6807\u7aef\u67e5\u770b\u5f97\u5230\u8fd9\u6761\u6570\u636e<\/p>\n<p>GGSCI (tomato.oracle.com) 18&gt; stats<br \/>\nrepdb2<\/p>\n<p>Sending STATS request to REPLICAT REPDB2<br \/>\n\u2026<\/p>\n<p>Start of Statistics at 2017-03-06 23:49:04.<\/p>\n<p>Replicating from LALA.STUDENT to<br \/>\nLALA.STUDENT:<\/p>\n<p>*** Total statistics since 2017-03-06<br \/>\n21:42:56 ***<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal inserts 1.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Total updates 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal deletes 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal discards 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal operations 1.00<\/p>\n<p>*** Daily statistics since 2017-03-06<br \/>\n21:42:56 ***<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal inserts 1.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal updates 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal deletes 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal discards 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal operations 1.00<\/p>\n<p>*** Hourly statistics since 2017-03-06<br \/>\n23:00:00 ***<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nNo database operations have been performed.<\/p>\n<p>*** Latest statistics since 2017-03-06<br \/>\n21:42:56 ***<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal inserts 1.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal updates 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal deletes 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal discards 0.00<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nTotal operations 1.00<\/p>\n<p>End of Statistics.<\/p>\n<p>SQL&gt; select * from student;<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\nID NAME<\/p>\n<p>\u2014\u2014\u2014- \u2014\u2014\u2014\u2014\u2014<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\n1 zhangsan<\/p>\n<p>\u73af\u5883\u642d\u5efa\u6210\u529f \u66f4\u591a\u5185\u5bb9\u8bf7\u9605\u8bfb\uff1a<a href=\"https:\/\/cn.raksmart.com\/blog\/knowledge\/695.html\">\u4ec0\u4e48\u662fDOCKER<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\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\u2026 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[1002],"class_list":["post-1018","post","type-post","status-publish","format-standard","hentry","category-knowledge","tag-ogg"],"_links":{"self":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts\/1018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/comments?post=1018"}],"version-history":[{"count":0,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts\/1018\/revisions"}],"wp:attachment":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/media?parent=1018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/categories?post=1018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/tags?post=1018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}