{"id":1414,"date":"2018-05-15T10:17:14","date_gmt":"2018-05-15T02:17:14","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1414"},"modified":"2018-05-15T10:17:14","modified_gmt":"2018-05-15T02:17:14","slug":"goldengate%e5%ad%a6%e4%b9%a04-oracle-to-oracle-workshop-demonstration","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1414","title":{"rendered":"GoldenGate\u5b66\u4e604–Oracle to Oracle workshop demonstration"},"content":{"rendered":"

GoldenGate for Oracle to Oracle
\n1. Environments;
\n 1. Source Database:
\n 1. Oracle:11g R2;
\n 2. Ip Address:192.168.10.11;
\n 3. Hostname:ggsource.snda.com;
\n 4. Oracle SID:ggsource;
\n 2. Target Database:
\n 1. Oracle:11g R2;
\n 2. Ip Address:192.168.10.12;
\n 3. Hostname:ggtarget.snda.com;
\n 4. Oracle SID:ggtarget.snda.com;
\n2. Oracle to Oracle configuration;
\n3. Prepare the Environment;
\n 1. Description:
\n 1. The GoldenGate software must be installed on both the source and target systems;
\n 2. The installation includes a sample database and scripts to generate initial data as well as subsequent update operations;
\n 3. The source and target tables are created and loaded with initial data;
\n 4. the GoldenGate Manager processes are also started so that other processes may be configured and started;
\n 2. \u51c6\u5907\u6d4b\u8bd5\u6570\u636e:
\n 1. \u5206\u522b\u5728\u6e90\u6570\u636e\u5e93\u548c\u76ee\u6807\u6570\u636e\u5e93\u521b\u5efagg\u7528\u6237,\u5e76\u8d4b\u4e88\u4e00\u5b9a\u7684\u6743\u9650:create user gg identified by gg default tablespace example;grant connect, resource to gg;(\u4e00\u5b9a\u8981\u4fdd\u8bc1\u8868\u662flogging\u7684,select table_name, tablespace_name, logging, owner from dba_tables where owner=’GG’;)
\n 2. \u5206\u522b\u5728\u6e90\u6570\u636e\u5e93\u548c\u76ee\u6807\u6570\u636e\u5e93\u7684gg\u7528\u6237\u4e0b\u521b\u5efa\u6d4b\u8bd5\u4f7f\u7528\u7684\u8868(\u811a\u672c\u662fGoldenGate\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684demo_ora_create.sql\u6587\u4ef6);
\n 3. \u53ea\u5728\u6e90\u6570\u636e\u5e93\u7684\u6d4b\u8bd5\u8868\u4e2d\u6dfb\u52a0\u6d4b\u8bd5\u6570\u636e(\u811a\u672c\u662fGoldenGate\u76ee\u5f55\u4e0b\u7684demo_ora_insert.sql\u6587\u4ef6);
\n 3. Configure the Manager process on the source and target:
\n 1. Create the Manager parameter file;
\n 2. Use edit to assign a port(7809 default),\u5176\u5b9e\u662f\u7f16\u8f91\u4e86\/gg11\/dirprm\/mgr.prm\u6587\u4ef6;
\n 3. Start the Manager and View the Manager process;
\n 4. \u67e5\u770b\u540e\u53f0\u8fdb\u7a0b\u9a8c\u8bc1:ps -ef | grep mgr;
\n 5. \u53ef\u4ee5\u901a\u8fc7\u76f4\u63a5\u6253\u5f00\u65e5\u5fd7\u6587\u4ef6(\/gg11\/dirrpt\/MGR.rpt\u6587\u4ef6)\u6216\u8005\u4f7f\u7528view report mgr\u547d\u4ee4\u67e5\u770bManager\u7684\u65e5\u5fd7;
\n 4. Supplemental Logging:
\n 1. Add database level supplmental logging on source and target:done when GoldenGate installed;
\n 2. Add table level supplemental logging on srouce and target;
\n 3. Verify that supplemental logging infos;
\n4. Configure Initial Data Load;
\n 1. Initial Load Methods:
\n 1. Oracle GoldenGate Methods;
\n 2. Database-specific Methods:
\n 1. Backup\/Restore;
\n 2. Export\/Import;
\n 3. SQL scripts;
\n 4. Break mirror;
\n 5. Transportable tablespaces;
\n 6. Note:
\n 1. Run a test initial load early on for timing and sizing;
\n 2. Run the actual initial load after starting change capture on the source;
\n 3. Current use;
\n 2. Initial data capture:
\n 1. add the initial load capture batch task group:GGSCI> add extract eint, sourceistable;(sourceistable \u53c2\u6570\u4ee3\u8868\u8fd9\u662finitial data);
\n 2. configure the initial load capture parameter file:GGSCI> edit params eint<\/unique>;
\n 3. Initial data delivery:
\n 1. add the initial load delivery batch task:GGSCI>add replicat rini<\/unique>, specialrun;(specialrun:Create a Replicat special run as a task)
\n 2. configure the initial load delivery parameter file;(assumetargetdefs:\u5047\u5b9a\u76ee\u6807\u6570\u636e\u5e93\u548c\u6e90\u6570\u636e\u5e93\u8868\u7ed3\u6784\u4e00\u81f4;discardfile:\u5931\u8d25\u7684\u8bb0\u5f55\u8bb0\u5f55\u7684\u6587\u4ef6;)
\n 4. Execute the initial load process:
\n 1. start extract process:start extract eint<\/unique>;
\n 2. view the results on the target system:view report rini<\/unique>;
\n 3. \u5728\u76ee\u6807\u6570\u636e\u5e93\u4e2d\u67e5\u770b\u6570\u636e;
\n5. Configure Change Capture(online mode);
\n 1. Extract can be configured to:
\n 1. Capture changed data from database logs;
\n 2. Capture data directly from source tables for initial data load;
\n 3. Write the data to a local or remote trail or file;
\n 2. add the extract group:add extract eora<\/unique>, tranlog, begin now, threads ;
\n 3. create the extract parameter file;
\n 4. define the GoldenGate trail:add rmttrail .\/dirdat\/, extract eora, megabytes 5;(default 10M size)
\n 5. start the capture process:start extract eora<\/unique>;
\n 6. \u53ef\u4ee5\u901a\u8fc7view report eorasd\u67e5\u770b\u65e5\u5fd7;
\n6. Configure Change Delivery;
\n 1. set up the checkpoint table;
\n 1. create a GLOBALS file on the target system;(exit and save)
\n 2. activate the GLOBALS parameters;
\n 2. Configure Change Delivery;
\n 1. add the replicat group;
\n 2. create replicat parameter file;
\n 3. start the replicat process;
\n7. Generate Activity and Verify the Results;
\n 1. exceute miscellaneous update, insert and delete operations on source system;
\n 2. verify results on the source system;
\n 3. verify results on the target system;
\n 4. turn off error handling;
\n8. Parameter Files Knowlege:
\n 1. Editing Parameter Files:
\n 1. Edit parameter files to configure GoldenGate processes;
\n 2. The GLOBALS parameter file is identified by its file path:GGSCI>edit params .\/GLOBALS;
\n 3. Manager and utility parameter files are identified by keywords:GGSCI>edit params mgr\/defgen;
\n 4. Extract and Replicat parameter files are identified by the process groiup name:GGSCI>edit params ;
\n 2. GLOBALS Versus Process Parameters:
\n 1. GLOBALS parameter apply to all processes:
\n 1. set when Manager starts;
\n 2. reside in \/GOLBALS;
\n 2. Process parameters apply to a specific process(Manager, Extract, Server Collector, Replicat, Utilities):
\n 1. set when the process starts;
\n 2. override GOLBALS settings;
\n 3. reside by defaults in the dirprm directory in files named .prm;
\n 4. most apply to all tables processed but some can be specified at the table level;
\n 3.
\nGLOBALS Parameters:
\n 1. Control things common to all processes in a GoldenGate instance;
\n 2. Can be overridden by parameters at the process level;
\n 3. Must be created before any processes are started;
\n 4. Must exit GGSCI to save;
\n 5. Once set, rarely changed;
\n 6. MGRSERVNAME:defines a unique Manager service name;
\n 7. CHECKPOINTTABLE:Defines the table name used for Replicat’s checkpoint table;<\/process><\/goldengate><\/group><\/unique><\/trail><\/instances><\/unique><\/p>\n","protected":false},"excerpt":{"rendered":"

GoldenGate for Oracle to Oracle 1. Environments; 1. Sou […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-1414","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1414"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1414\/revisions"}],"predecessor-version":[{"id":1415,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1414\/revisions\/1415"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1414"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}