{"id":1499,"date":"2020-02-06T22:27:27","date_gmt":"2020-02-06T14:27:27","guid":{"rendered":"https:\/\/www.charflower.com\/?p=1499"},"modified":"2020-02-15T15:13:16","modified_gmt":"2020-02-15T07:13:16","slug":"%e5%9f%ba%e4%ba%8ewindows%e5%b9%b3%e5%8f%b0oracle-rac-19c%e6%9e%84%e5%bb%bagoldengate-19%e5%85%a5%e9%97%a8","status":"publish","type":"post","link":"https:\/\/www.charflower.com\/?p=1499","title":{"rendered":"\u57fa\u4e8eWindows\u5e73\u53f0Oracle RAC 19c\u6784\u5efaGoldenGate 19\u5165\u95e8"},"content":{"rendered":"\n<p>\u75c5\u6bd2\u8086\u8650\uff0c\u56fd\u96be\u5f53\u5934\uff0c\u5c11\u51fa\u95e8\uff0c\u591a\u601d\u8003\uff01<\/p>\n\n\n\n<p>\u5b89\u88c5\u73af\u5883\/\u4ecb\u8d28\u51c6\u5907\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>en_windows_server_2019_x64_dvd_3c2cf1202.iso\nWINDOWS.X64_193000_grid_home.zip\nWINDOWS.X64_193000_db_home.zip\n191004_fbo_ggs_Windows_x64_shiphome.zip\nvcredist_x64-2012CU4.exe\nvcredist_x64-2013.exe\nVC_redist.x64-2017.exe\n--\n\u5176\u4e2dSOURCE\u4e00\u4fa7\u4e3a\u539f\u67092\u8282\u70b919c RAC\u73af\u5883\uff0cTARGET\u4e00\u4fa7\u4e3a\u5355\u70b9ASM+CDB\n(\u542c\u8bf4Oracle 20c\u5f00\u59cb\u53ea\u652f\u6301CDB\u6a21\u5f0f\u4e86\uff0c\u672c\u6587\u4ec5\u4ecb\u7ecdCDB\u5bb9\u5668\u6570\u636e\u5e93\u7684GG\u90e8\u7f72\uff0c\n\u4f20\u7edf\u6a21\u5f0f\u7684\u6587\u7ae0\u592a\u591a\u4e86\uff0c\u5c31\u4e0d\u591a\u8bf4\u4e86\u3002)<\/code><\/pre>\n\n\n\n<p>\u5728\u4e09\u4e2a19c\u8282\u70b9\u5206\u522b\u5b89\u88c5OGG 19\uff0c\u5b89\u88c5\u8fc7\u7a0b\u975e\u5e38\u7b80\u5355\uff0c\u4f46\u914d\u7f6e\u8fc7\u7a0b\u771f\u7684\u5f88\u7e41\u7410\uff0c\u672c\u6587\u5148\u4ece\u6700\u7b80\u5355\u7684\u5355\u70b9RAC\u5355\u5411\u590d\u5236\u8bf4\u8d77\uff0c\u5148\u6709\u4e2a\u601d\u60f3\u51c6\u5907\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"777\" height=\"694\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-46.png\" alt=\"\" class=\"wp-image-1505\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-46.png 777w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-46-300x268.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-46-768x686.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><figcaption>target\u5e73\u53f0\u76f8\u5173\u4fe1\u606f\uff1aAD\u6210\u5458\u3001ASM+CDB\u3001\u672c\u6587\u4ee5PDB2\u590d\u5236\u5230PDB2\u4e3a\u4f8b\u3002<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"641\" height=\"777\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-47.png\" alt=\"\" class=\"wp-image-1506\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-47.png 641w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-47-247x300.png 247w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><figcaption>\u6dfb\u52a0PDB2\u7684\u4fa6\u542c\u5668\u4fe1\u606f\uff0csource\u7aef\u4e5f\u9700\u8981\u6dfb\u52a0\uff0c\u4e0d\u7136\u540e\u7eeddblogin\u4f1a\u62a5\u9519\u3002<\/figcaption><\/figure>\n\n\n\n<p><strong>\u5173\u4e8e\u73af\u5883\u53d8\u91cf\u7684\u91cd\u8981\u63d0\u9192\uff1a<\/strong><\/p>\n\n\n\n<p>If there is one instance of Oracle on the system, the Registry settings for ORACLE_HOME and ORACLE_SID should be sufficient for Oracle oldenGate. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"914\" height=\"575\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-64.png\" alt=\"\" class=\"wp-image-1545\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-64.png 914w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-64-300x189.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-64-768x483.png 768w\" sizes=\"(max-width: 914px) 100vw, 914px\" \/><\/figure>\n\n\n\n<p>If those settings are incorrect in the Registry and cannot be changed, you can set an override as follows.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"612\" height=\"569\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-58.png\" alt=\"\" class=\"wp-image-1530\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-58.png 612w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-58-300x279.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><figcaption>\u5355\u5b9e\u4f8bOS\u6dfb\u52a0\u4e0a\u56fe\u73af\u5883\u53d8\u91cf\u662f\u6ca1\u6709\u5f71\u54cd\u7684\uff0c\u4f46\u662fRAC\u8282\u70b9\u4e0a\u6dfb\u52a0\u7684\u8bdd\u4f1a\u5bfc\u81f4GI\u96c6\u7fa4\u670d\u52a1\u62a5\u9519\u3002\u4e0d\u6dfb\u52a0\u4e0a\u8ff0\u53d8\u91cf\uff0c\u4f1a\u5728GGSCI\u4e0b\u6267\u884cdblogin\u65f6\u51fa\u73b0\u8b66\u62a5\u4fe1\u606f(WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.)\uff0c\u4f46\u4e0d\u5f71\u54cd\u64cd\u4f5c\u7ed3\u679c\u3002<\/figcaption><\/figure>\n\n\n\n<p>\u5b98\u65b9\u6587\u6863\u5bf9\u4e8eWindows\u5e73\u53f0\u4e0a\u7684\u8bf4\u660e\u771f\u7684\u5f88\u5dee\u52b2\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"711\" height=\"819\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-65.png\" alt=\"\" class=\"wp-image-1549\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-65.png 711w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-65-260x300.png 260w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/figure>\n\n\n\n<p>\u7ec8\u6781\u5efa\u8bae\u5c06ORACLE_HOME\u548cORACLE_SID\u52a0\u5165\u5230prm\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c\u8fd9\u867d\u7136\u662f\u5b98\u65b9\u9488\u5bf9Linux\u7684\u5efa\u8bae\uff0c\u4f46\u5bf9Windows\u5e73\u53f0\u4f9d\u7136\u6709\u6548\u3002<\/p>\n\n\n\n<p>\u63a5\u4e0b\u6765\u662fGUI\u5b89\u88c5\u8fc7\u7a0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"882\" height=\"662\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-41.png\" alt=\"\" class=\"wp-image-1500\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-41.png 882w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-41-300x225.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-41-768x576.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><figcaption>\u5f00\u59cbGG\u5b89\u88c5\uff0c\u9ed8\u8ba4\u9009\u62e9\u6700\u65b0\u7248\u672c\uff0c\u672c\u6587\u4e5f\u662f\u57fa\u4e8e\u6700\u65b0\u7248\u672c\uff1b<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"882\" height=\"664\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-42.png\" alt=\"\" class=\"wp-image-1501\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-42.png 882w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-42-300x226.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-42-768x578.png 768w\" sizes=\"(max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"883\" height=\"664\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-43.png\" alt=\"\" class=\"wp-image-1502\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-43.png 883w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-43-300x226.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-43-768x578.png 768w\" sizes=\"(max-width: 883px) 100vw, 883px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"880\" height=\"663\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-44.png\" alt=\"\" class=\"wp-image-1503\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-44.png 880w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-44-300x226.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-44-768x579.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"881\" height=\"664\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-45.png\" alt=\"\" class=\"wp-image-1504\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-45.png 881w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-45-300x226.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-45-768x579.png 768w\" sizes=\"(max-width: 881px) 100vw, 881px\" \/><\/figure>\n\n\n\n<p>\u9488\u5bf9GG\u505a\u57fa\u7840\u914d\u7f6e\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"719\" height=\"317\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-56.png\" alt=\"\" class=\"wp-image-1523\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-56.png 719w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-56-300x132.png 300w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><figcaption>source\u7aef\u914d\u7f6e<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"761\" height=\"375\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-54.png\" alt=\"\" class=\"wp-image-1521\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-54.png 761w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-54-300x148.png 300w\" sizes=\"(max-width: 761px) 100vw, 761px\" \/><figcaption>target\u7aef\u914d\u7f6e<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>\u5728ogg\u5b89\u88c5\u76ee\u5f55\u4e0b\u6267\u884c\u4ee5\u4e0b\u547d\u4ee4\u6ce8\u518cGG\u670d\u52a1\u5e76\u751f\u6210\u4e8b\u4ef6\u65e5\u5fd7\uff1b\nC:\\app\\19.0.0\\ogg>.\\install.exe addservice addevents\n\u5982\u679c\u662f\u5220\u9664\u8fd9\u4e24\u9879\uff0c\u5219\u6267\u884cinstall deleteevents deleteservice<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"440\" height=\"500\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-55.png\" alt=\"\" class=\"wp-image-1522\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-55.png 440w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-55-264x300.png 264w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/><figcaption>\u5982\u679c\u8be5\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\uff0c\u8bf7\u91cd\u542f\u8be5\u8282\u70b9OS\u540e\u670d\u52a1\u81ea\u52a8\u542f\u52a8\u3002<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"596\" height=\"537\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-48.png\" alt=\"\" class=\"wp-image-1507\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-48.png 596w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-48-300x270.png 300w\" sizes=\"(max-width: 596px) 100vw, 596px\" \/><figcaption>\u6700\u540e\u91cd\u65b0\u6253\u5f00\u6570\u636e\u5e93\uff1aalter database open;<br>\u5f00\u542fRAC\u4e0b\u7684\u5f52\u6863\u65e5\u5fd7\uff0c\u9700\u8981\u7279\u522b\u6ce8\u610f\u4e24\u4e2a\u8282\u70b9\u90fd\u8981shutdown\u540e\u91cd\u65b0mount\u624d\u80fd\u5f00\u542f\u3002<\/figcaption><\/figure>\n\n\n\n<p>source\u4e0etarget\u4e24\u4fa7\u5747\u4f5c\u5982\u4e0b\u914d\u7f6e\uff0c\u6838\u5fc3\u5c31\u662f\u521b\u5efa\u4e00\u4e2aCDB\u67b6\u6784\u4e0b\u5b9e\u73b0\u96c6\u6210\u6a21\u5f0f\u590d\u5236\u7684\u8d26\u53f7\u548c\u524d\u63d0\u73af\u5883\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER C##GGADMIN IDENTIFIED BY oracle_123 DEFAULT TABLESPACE USERS;\nGRANT CREATE SESSION, DBA TO C##GGADMIN;\nEXECUTE DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE('C##GGADMIN',CONTAINER=>'ALL')\nGRANT DBA TO C##GGADMIN CONTAINER=ALL;\nALTER SYSTEM SET UNDO_RETENTION=86400 SCOPE=BOTH;\nGRANT FLASHBACK ANY TABLE TO C##GGADMIN;\nALTER DATABASE ADD SUPPLEMENTAL LOG DATA;\nGRANT ALTER SESSION TO C##GGADMIN;\nGRANT SET CONTAINER TO C##GGADMIN;\nSELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'C##GGADMIN';\nALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE;<\/code><\/pre>\n\n\n\n<p>SOURCE\u4e00\u4fa7ggsci\u4e0b\u542f\u7528\u6307\u5b9atable\u7684\u9644\u52a0\u65e5\u5fd7\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DBLOGIN USERID C##GGADMIN@PDB2, PASSWORD oracle_123\nADD SCHEMATRANDATA PDB2.C##GGADMIN\n\u6216\u8005\nADD TRANDATA PDB2.C##GGADMIN.TCUSTMER\nADD TRANDATA PDB2.C##GGADMIN.TCUSTORD<\/code><\/pre>\n\n\n\n<p>ggsci\u4e0bedit params mgr<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PORT 7809\nPURGEOLDEXTRACTS C:\\app\\19.0.0\\ogg\\dirdat\\sr*, USECHECKPOINTS, MINKEEPHOURS 2<\/code><\/pre>\n\n\n\n<p> ggsci\u4e0bedit params .\/globals<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MGRSERVNAME GGSMGR<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"781\" height=\"517\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-49.png\" alt=\"\" class=\"wp-image-1508\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-49.png 781w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-49-300x199.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-49-768x508.png 768w\" sizes=\"(max-width: 781px) 100vw, 781px\" \/><figcaption>source\u4e00\u4fa7\u521b\u5efa\u4e0a\u56fe\u4e24\u4e2a\u6587\u4ef6<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Change Data Capture parameter file to extract\n-- source table changes\n--\nEXTRACT ext1\nSETENV (ORACLE_HOME = \"C:\\app\\19.0.0\\database\")\nSETENV (ORACLE_SID = \"orcl1\")\nUSERID C##GGADMIN, PASSWORD oracle_123\nLOGALLSUPCOLS\nUPDATERECORDFORMAT COMPACT\nEXTTRAIL C:\\app\\19.0.0\\ogg\\dirdat\\sr\nSOURCECATALOG pdb2\nTABLE pdb2.C##GGADMIN.TCUSTMER;\nTABLE pdb2.C##GGADMIN.TCUSTORD;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Data Pump parameter file to read the local\n-- trail of table changes\n--\nEXTRACT pmp1\nSETENV (ORACLE_HOME = \"C:\\app\\19.0.0\\database\")\nSETENV (ORACLE_SID = \"orcl1\")\nUSERID C##GGADMIN, PASSWORD oracle_123\nRMTHOST ggtarget, MGRPORT 7809\nRMTTRAIL C:\\app\\19.0.0\\ogg\\dirdat\\tg\nSOURCECATALOG pdb2\nTABLE pdb2.C##GGADMIN.TCUSTMER;\nTABLE pdb2.C##GGADMIN.TCUSTORD;<\/code><\/pre>\n\n\n\n<p>TARGET\u4e00\u4fa7\u7684\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>ggsci\u521b\u5efa\u6587\u4ef6edit params .\/globals<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MGRSERVNAME GGSMGR\nCHECKPOINTTABLE C##GGADMIN.ggchkpt\n--\u5b9a\u4e49\u4ee5\u4e0b\u8f93\u51fa\u8def\u5f84\uff0c\u4e0d\u662f\u5fc5\u987b\uff0c\u4f46\u5982\u679c\u53d1\u73b0.\/dirdat\u8fd9\u79cd\u8def\u5f84\u6709\u95ee\u9898\u65f6\u53ef\u4ee5\u5c1d\u8bd5\u4f7f\u7528Windows\u76d8\u7b26\u8def\u5f84\u65b9\u5f0f\u3002\u5b9a\u4e49\u8be5\u53c2\u6570\u540e\u9700\u8981stop mgr\u540e\u9000\u51faggsci\u91cd\u65b0\u8fdb\u5165\u624d\u4f1a\u751f\u6548\uff1b\nALLOWOUTPUTDIR c:\\app\\19.0.0\\ogg\\<\/code><\/pre>\n\n\n\n<p>edit params mgr\u7684\u5185\u5bb9<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PORT 7809\nPURGEOLDEXTRACTS c:\\app\\19.0.0\\ogg\\dirdat\\tg*, USECHECKPOINTS, MINKEEPHOURS 2<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"709\" height=\"192\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-50.png\" alt=\"\" class=\"wp-image-1509\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-50.png 709w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-50-300x81.png 300w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><figcaption>target\u4e00\u4fa7\u521b\u5efa\u4e0a\u56fe\u6587\u4ef6<\/figcaption><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>REPLICAT rep1\nSETENV (ORACLE_HOME = \"C:\\app\\19.0.0\\database\")\nSETENV (ORACLE_SID = \"orcl\")\nUSERID c##ggadmin@pdb2, PASSWORD oracle_123\nASSUMETARGETDEFS\nMAP pdb2.C##GGADMIN.*, TARGET pdb2.C##GGADMIN.*;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\u914d\u7f6e\u6d41\u7a0b\u5982\u4e0b\uff1a\nOn the source system\n\u00bb Create an OGG User\n\u00bb Add supplemental log data for update operations.\n\u00bb Create an Extract parameter file on source Unix system. \n\u00bb Register Extract in database\n\u00bb Set up an initial Extract checkpoint on source Unix system.\n\u00bb Create Remote Trail File\n\u00bb Start Extract\nOn the target system\n\u00bb Create an OGG User\n\u00bb Create a Replicat parameter file on target Unix system.\n\u00bb Set up an initial Replicat checkpoint on target Unix system.<\/code><\/pre>\n\n\n\n<p><strong>\u51e0\u4e2a\u8e29\u5751\u603b\u7ed3\u4e00\u4e0b\uff1a<\/strong><\/p>\n\n\n\n<p>1\u3001\u5982\u679cggsci.exe\u53cc\u51fb\u62a5MSVCR1xx.DLL\u9519\u8bef\uff0c\u547d\u4ee4\u884c\u8fd0\u884cggsci.exe\u6ca1\u6709\u53cd\u5e94\uff0c\u5219\u8bf4\u660evcredist_x64-2013.exe\u6ca1\u6709\u5b89\u88c5\uff1b<\/p>\n\n\n\n<p>2\u3001\u5982\u679cdblogin\u65e0\u6cd5\u76f4\u63a5\u767b\u5f55\u5230PDB2\uff0c\u5219\u8bf4\u660etnsname\u4e2d\u6ca1\u6709\u6dfb\u52a0PDB\u90e8\u5206\uff1b<\/p>\n\n\n\n<p>3\u3001\u5982\u679c\u9047\u5230extract\/datapmp\/replicat\u65e0\u6cd5\u542f\u52a8\u7684\u60c5\u51b5\uff0c\u5219\u8868\u660e\u914d\u7f6e\u53c2\u6570\u6709\u95ee\u9898(\u4ece\u522b\u5904\u76f4\u63a5copy\u8fc7\u6765\u7684\u53c2\u6570\u4e0d\u4e00\u5b9a\u76f4\u63a5\u53ef\u7528\u54e6\uff01)\uff0c\u53ef\u4ee5\u56de\u5230ogg\u76ee\u5f55\u6267\u884c\u914d\u7f6e\u68c0\u67e5\uff0c\u6839\u636e\u8f93\u51fa\u4fe1\u606f\uff0c\u8c03\u6574\u76f8\u5173\u53c2\u6570\u3002\u672c\u6587\u4e2d\u7684\u53c2\u6570\u7ecf\u8fc7\u5b9e\u9645\u9a8c\u8bc1\u3002<\/p>\n\n\n\n<p>.\\extract.exe paramfile .\\dirprm\\extora.prm<\/p>\n\n\n\n<p>.\\replicat.exe paramfile .\\dirprm\\replcat1.prm<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"733\" height=\"755\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-57.png\" alt=\"\" class=\"wp-image-1526\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-57.png 733w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-57-291x300.png 291w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"735\" height=\"1024\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-51-735x1024.png\" alt=\"\" class=\"wp-image-1510\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-51-735x1024.png 735w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-51-215x300.png 215w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-51.png 763w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"725\" height=\"1024\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-52-725x1024.png\" alt=\"\" class=\"wp-image-1511\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-52-725x1024.png 725w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-52-212x300.png 212w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-52.png 769w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"861\" height=\"642\" src=\"http:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-53.png\" alt=\"\" class=\"wp-image-1512\" srcset=\"https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-53.png 861w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-53-300x224.png 300w, https:\/\/www.charflower.com\/wp-content\/uploads\/2020\/02\/image-53-768x573.png 768w\" sizes=\"(max-width: 861px) 100vw, 861px\" \/><figcaption>\u6e90\u7aef\u589e\u5220\u6539\u67e5\u7684\u52a8\u4f5c\u4f1a\u5b9e\u65f6\u540c\u6b65\u5230\u76ee\u6807\u7aef<\/figcaption><\/figure>\n\n\n\n<p>GoldenGate\u9886\u57df\u7684\u6280\u672f\u6587\u7ae0\u66f4\u65b0\u975e\u5e38\u6ede\u540e\uff0c\u53ef\u89c1\u6280\u672f\u751f\u6001\u5f88\u5c01\u95ed\u3002\u7f51\u7edc\u4e0a\u8fde\u7bc7\u50cf\u6837\u7684\u5173\u4e8e12c\u4e0bCDB\u6a21\u5f0f\u914d\u7f6eGG\u7684\u6587\u7ae0\u90fd\u627e\u4e0d\u5230\uff0c\u672c\u6587\u63d0\u5347\u523019c\u4e0b\u7684CDB\u73af\u5883\uff0c\u7b97\u662f\u4e00\u70b9\u5fae\u8584\u4e4b\u529b\u5e0c\u671b\u5bf9\u8bfb\u8005\u6709\u5e2e\u52a9\uff01<\/p>\n\n\n\n<p>\u7167\u4f8b\u4ee5\u4e0b\u662f\u89c6\u9891\u914d\u7f6e\u8fc7\u7a0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/youtu.be\/oiwLImsHFXA\n<\/div><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>https:\/\/youtu.be\/oiwLImsHFXA<\/code><\/pre>\n\n\n\n<p>2020\/2\/15\u66f4\u65b0\u2014\u2014rac21\u4e0a\u7684\u914d\u7f6e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PS C:\\Windows\\system32> cd C:\\app\\19.0.0\\ogg\\\nPS C:\\app\\19.0.0\\ogg> .\\ggsci.exe\n\nOracle GoldenGate Command Interpreter for Oracle\nVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO\nWindows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39\nOperating system character set identified as windows-1252.\n\nCopyright (C) 1995, 2019, Oracle and\/or its affiliates. All rights reserved.\n\n\n\nGGSCI (rac21) 1> edit params .\/GLOBALS\n\n\nGGSCI (rac21) 2> stop mgr\nManager process is required by other GGS processes.\nAre you sure you want to stop it (y\/n)?y\n\nSending STOP request to MANAGER ...\n\n2020-02-15 13:18:08  ERROR   OGG-15162  There was a problem sending a message to MANAGER (Timeout waiting for message).\n\n\nGGSCI (rac21) 3> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING\n\n\nGGSCI (rac21) 4> stop mgr\nManager process is required by other GGS processes.\nAre you sure you want to stop it (y\/n)?y\n\nSending STOP request to MANAGER ...\n\n2020-02-15 13:26:17  ERROR   OGG-15162  There was a problem sending a message to MANAGER (Timeout waiting for message).\n\n\nGGSCI (rac21) 5> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING\n\n\nGGSCI (rac21) 6> exit\nPS C:\\app\\19.0.0\\ogg> .\\ggsci.exe\n\nOracle GoldenGate Command Interpreter for Oracle\nVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO\nWindows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39\nOperating system character set identified as windows-1252.\n\nCopyright (C) 1995, 2019, Oracle and\/or its affiliates. All rights reserved.\n\n\n\nGGSCI (rac21) 1> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     STOPPED\n\n\nGGSCI (rac21) 2> start mgr\nManager started.\n\n\nGGSCI (rac21) 3> add extract ext1, integrated tranlog, begin now\nEXTRACT (Integrated) added.\n\n\nGGSCI (rac21) 4> add exttrail C:\\app\\19.0.0\\ogg\\dirdat\\sr, extract ext1, megabytes 100\nEXTTRAIL added.\n\nGGSCI (rac21) 5> dblogin userid c##ggadmin password oracle_123\n\n2020-02-15 13:29:16  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.\nSuccessfully logged into database CDB$ROOT.\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 7> register extract ext1 database container (PDB2)\n\n2020-02-15 13:32:02  INFO    OGG-02003  Extract EXT1 successfully registered with database at SCN 5107033.\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 9> edit params pmp1\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 10> add extract pmp1, exttrailsource C:\\app\\19.0.0\\ogg\\dirdat\\sr begin now\nEXTRACT added.\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 11> add rmttrail C:\\app\\19.0.0\\ogg\\dirdat\\tg extract pmp1\nRMTTRAIL added.\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 12> start ext1\n\nSending START request to MANAGER ...\nEXTRACT EXT1 starting\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 13> start pmp1\n\nSending START request to MANAGER ...\nEXTRACT PMP1 starting\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 14> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING\nEXTRACT     RUNNING     EXT1        00:03:18      00:00:06\nEXTRACT     RUNNING     PMP1        00:01:14      00:00:01\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 15> info pmp1\n\nEXTRACT    PMP1      Last Started 2020-02-15 13:35   Status RUNNING\nCheckpoint Lag       00:00:00 (updated 00:00:09 ago)\nProcess ID           7864\nLog Read Checkpoint  File C:\\app\\19.0.0\\ogg\\dirdat\\sr000000000\n                     2020-02-15 13:37:16.000000  RBA 2208\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 16> info pmp1\n\nEXTRACT    PMP1      Last Started 2020-02-15 13:35   Status RUNNING\nCheckpoint Lag       00:00:00 (updated 00:00:01 ago)\nProcess ID           7864\nLog Read Checkpoint  File C:\\app\\19.0.0\\ogg\\dirdat\\sr000000000\n                     2020-02-15 13:38:13.000000  RBA 2385\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 17> add trandata pdb2.c##ggadmin\nERROR: The catalog name is missing. Fully qualified name for table pdb2.c##ggadmin is required for root database.\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 18> add trandata pdb2.c##ggadmin.*\n\n2020-02-15 13:54:20  INFO    OGG-15132  Logging of supplemental redo data enabled for table PDB2.C##GGADMIN.TCUSTMER.\n\n2020-02-15 13:54:20  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table PDB2.C##GGADMIN.TCUSTMER.\n\n2020-02-15 13:54:20  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table PDB2.C##GGADMIN.TCUSTMER.\n\n2020-02-15 13:54:20  INFO    OGG-15132  Logging of supplemental redo data enabled for table PDB2.C##GGADMIN.TCUSTORD.\n\n2020-02-15 13:54:20  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table PDB2.C##GGADMIN.TCUSTORD.\n\n2020-02-15 13:54:20  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table PDB2.C##GGADMIN.TCUSTORD.\n\n2020-02-15 13:54:21  INFO    OGG-10471  ***** Oracle Goldengate support information on table C##GGADMIN.TCUSTMER *****\nOracle Goldengate support native capture on table C##GGADMIN.TCUSTMER.\nOracle Goldengate marked following column as key columns on table C##GGADMIN.TCUSTMER: CUST_CODE.\n\n2020-02-15 13:54:21  INFO    OGG-10471  ***** Oracle Goldengate support information on table C##GGADMIN.TCUSTORD *****\nOracle Goldengate support native capture on table C##GGADMIN.TCUSTORD.\nOracle Goldengate marked following column as key columns on table C##GGADMIN.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 19> stats pmp1\n\nSending STATS request to EXTRACT PMP1 ...\n\nStart of Statistics at 2020-02-15 14:07:01.\n\nOutput to C:\\app\\19.0.0\\ogg\\dirdat\\tg:\n\nExtracting from PDB2.C##GGADMIN.TCUSTMER to PDB2.C##GGADMIN.TCUSTMER:\n\n*** Total statistics since 2020-02-15 13:37:21 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\n*** Daily statistics since 2020-02-15 13:37:21 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\n*** Hourly statistics since 2020-02-15 14:00:00 ***\n        Total inserts                                      1.00\n        Total updates                                      0.00\n        Total deletes                                      0.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   1.00\n\n*** Latest statistics since 2020-02-15 13:37:21 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\nEnd of Statistics.\n\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 20>\n\nGGSCI (rac21 as c##ggadmin@orcl1\/CDB$ROOT) 20><\/code><\/pre>\n\n\n\n<p>ggtarget\u4e00\u4fa7\u914d\u7f6e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PS C:\\Windows\\system32> cd C:\\app\\19.0.0\\ogg\\\nPS C:\\app\\19.0.0\\ogg> .\\ggsci.exe\n\nOracle GoldenGate Command Interpreter for Oracle\nVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO\nWindows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39\nOperating system character set identified as windows-1252.\n\nCopyright (C) 1995, 2019, Oracle and\/or its affiliates. All rights reserved.\nGGSCI (ggtarget) 1> edit params .\/GLOBALS\nGGSCI (ggtarget) 2> exit\nPS C:\\app\\19.0.0\\ogg> .\\ggsci.exe\n\nOracle GoldenGate Command Interpreter for Oracle\nVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO\nWindows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39\nOperating system character set identified as windows-1252.\n\nCopyright (C) 1995, 2019, Oracle and\/or its affiliates. All rights reserved.\n\n\n\nGGSCI (ggtarget) 1> dblogin userid c##ggadmin password oracle_123\n\n2020-02-15 13:18:22  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.\nSuccessfully logged into database CDB$ROOT.\n\nGGSCI (ggtarget as c##ggadmin@orcl\/CDB$ROOT) 2> start mgr\nManager started.\n\n\nGGSCI (ggtarget as c##ggadmin@orcl\/CDB$ROOT) 3> exit\nPS C:\\app\\19.0.0\\ogg> .\\ggsci.exe\n\nOracle GoldenGate Command Interpreter for Oracle\nVersion 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO\nWindows x64 (optimized), Oracle 19c on Oct 19 2019 22:34:39\nOperating system character set identified as windows-1252.\n\nCopyright (C) 1995, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nGGSCI (ggtarget) 1> edit params rep1\n\nGGSCI (ggtarget) 2> dblogin userid c##ggadmin@pdb2 password oracle_123\n\n2020-02-15 13:20:42  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.\nSuccessfully logged into database PDB2.\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 3> add replicat rep1 integrated exttrail c:\\app\\19.0.0\\ogg\\dirdat\\target\nERROR: EXTTRAIL file portion must be two characters.\n\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 4> add replicat rep1 integrated exttrail c:\\app\\19.0.0\\ogg\\dirdat\\tg\nREPLICAT (Integrated) added.\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 5> add checkpointtable\n\nNo checkpoint table specified. Using GLOBALS specification C##GGADMIN.ggchkpt...\nLogon catalog name PDB2 will be used for table specification PDB2.C##GGADMIN.ggchkpt.\nERROR: Failed creating checkpoint table C##GGADMIN.ggchkpt.\n\nOCI Error ORA (status = 955-ORA-00955: name is already used by an existing object).\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 6> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\n\nMANAGER     RUNNING\nREPLICAT    STOPPED     REP1        00:00:00      00:01:05\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 7> start rep1\n\nSending START request to MANAGER ...\nREPLICAT REP1 starting\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 8> info all\n\nProgram     Status      Group       Lag at Chkpt  Time Since Chkpt\nMANAGER     RUNNING\nREPLICAT    RUNNING     REP1        00:00:00      00:00:08\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 16> info rep1\n\nREPLICAT   REP1      Last Started 2020-02-15 13:23   Status RUNNING\nINTEGRATED\nCheckpoint Lag       00:00:00 (updated 00:00:09 ago)\nProcess ID           2732\nLog Read Checkpoint  File c:\\app\\19.0.0\\ogg\\dirdat\\tg000000000\n                     2020-02-15 13:56:07.026000  RBA 2761\n\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 17> info rep1 detail\n\nREPLICAT   REP1      Last Started 2020-02-15 13:23   Status RUNNING\nINTEGRATED\nCheckpoint Lag       00:00:00 (updated 00:00:05 ago)\nProcess ID           2732\nLog Read Checkpoint  File c:\\app\\19.0.0\\ogg\\dirdat\\tg000000000\n                     2020-02-15 13:56:17.126000  RBA 2761\n\nINTEGRATED Replicat\nDBLOGIN Provided, inbound server name is OGG$REP1 in ATTACHED state\n\n\nCurrent Log BSN value: (no data)\n\nLow Watermark CSN value: 5161678\n(All source transactions prior to this scn have been applied)\n\nHigh Watermark CSN value: 5169957\n(Some source transactions between this scn and the low watermark may have been applied)\n\n  Extract Source                          Begin             End\n\n  c:\\app\\19.0.0\\ogg\\dirdat\\tg000000000    * Initialized *   2020-02-15 13:56\n  c:\\app\\19.0.0\\ogg\\dirdat\\tg000000000    * Initialized *   First Record\n  c:\\app\\19.0.0\\ogg\\dirdat\\tg000000000    * Initialized *   First Record\n\n\nCurrent directory    C:\\app\\19.0.0\\ogg\n\nReport file          C:\\app\\19.0.0\\ogg\\dirrpt\\REP1.rpt\nParameter file       C:\\app\\19.0.0\\ogg\\dirprm\\REP1.prm\nCheckpoint file      C:\\app\\19.0.0\\ogg\\dirchk\\REP1.cpr\nCheckpoint table     C##GGADMIN.ggchkpt\nProcess file\nError log            C:\\app\\19.0.0\\ogg\\ggserr.log\n\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 18> stats rep1\n\nSending STATS request to REPLICAT REP1 ...\n\nStart of Statistics at 2020-02-15 14:07:47.\n\n\nIntegrated Replicat Statistics:\n\n        Total transactions                                 4.00\n        Redirected                                         0.00\n        Replicated procedures                              0.00\n        DDL operations                                     0.00\n        Stored procedures                                  0.00\n        Datatype functionality                             0.00\n        Operation type functionality                       0.00\n        Event actions                                      0.00\n        Direct transactions ratio                          0.00%\n\nReplicating from PDB2.C##GGADMIN.TCUSTMER to PDB2.C##GGADMIN.TCUSTMER:\n\n*** Total statistics since 2020-02-15 13:37:32 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\n*** Daily statistics since 2020-02-15 13:37:32 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\n*** Hourly statistics since 2020-02-15 14:00:00 ***\n        Total inserts                                      1.00\n        Total updates                                      0.00\n        Total deletes                                      0.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   1.00\n\n*** Latest statistics since 2020-02-15 13:37:32 ***\n        Total inserts                                      3.00\n        Total updates                                      1.00\n        Total deletes                                      1.00\n        Total upserts                                      0.00\n        Total discards                                     0.00\n        Total operations                                   5.00\n\nEnd of Statistics.\n\n\nGGSCI (ggtarget as c##ggadmin@orcl\/PDB2) 19><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u75c5\u6bd2\u8086\u8650\uff0c\u56fd\u96be\u5f53\u5934\uff0c\u5c11\u51fa\u95e8\uff0c\u591a\u601d\u8003\uff01 \u5b89\u88c5\u73af\u5883\/\u4ecb\u8d28\u51c6\u5907\uff1a \u5728\u4e09\u4e2a19c\u8282\u70b9\u5206\u522b\u5b89\u88c5OGG 19\uff0c\u5b89\u88c5\u8fc7\u7a0b\u975e\u5e38&hellip; <a class=\"more-link\" href=\"https:\/\/www.charflower.com\/?p=1499\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u57fa\u4e8eWindows\u5e73\u53f0Oracle RAC 19c\u6784\u5efaGoldenGate 19\u5165\u95e8<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":1516,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[37,59],"tags":[64,56,57],"_links":{"self":[{"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/posts\/1499"}],"collection":[{"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.charflower.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1499"}],"version-history":[{"count":22,"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/posts\/1499\/revisions"}],"predecessor-version":[{"id":1559,"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/posts\/1499\/revisions\/1559"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.charflower.com\/index.php?rest_route=\/wp\/v2\/media\/1516"}],"wp:attachment":[{"href":"https:\/\/www.charflower.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.charflower.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.charflower.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}