Oracle GoldenGate Technical Architecture
\n1. Objectives:
\n 1. Describe Oracle GoldenGate uses;
\n 2. Lean the components of Oracle GoldenGate;
\n 3. Explain change capture and delivery(with and without a dump);
\n 4. Explain inital data load;
\n 5. Contrast batch and online operation;
\n 6. Explain Oracle GoldenGate checkpointing;
\n 7. Describe Oracle GoldenGate parameters, process groups and GGSCI commands;
\n2. Oracle GoldenGate Users:
\n 1. Primarily userd for change data capture and delivery from database transaction logs;
\n 2. Can optionally be used for initial load directly from database tables:
\n 1. Especially usefull for synchronizing heterogeneous databases,\u5bf9\u5f02\u6784\u6570\u636e\u5e93\u4e4b\u95f4\u540c\u6b65\u6570\u636e\u7279\u522b\u6709\u7528;
\n 2. Database-specific methods may be preferable for homogeneous configurations,\u540c\u6784\u6570\u636e\u5e93\u4e4b\u95f4\u6700\u597d\u4f7f\u7528\u6570\u636e\u5e93\u672c\u8eab\u7684\u65b9\u6cd5;
\n3. Oracle GlodenGate Components:
\n 1. Extract:process,source;
\n 2. Data Pump:process,source;
\n 3. Replicat:process,target;
\n 4. Trails or Extract files:file,source and target;
\n 5. Checkpoints:process;
\n 6. Manager:process,source and target;
\n 7. Collector:process,target;
\n4. \u4f7f\u7528\u4e2d\u7684\u5404\u79cd\u573a\u666f:
\n 1. Change Data Capture and Delivery;
\n 2. Change Data Capture and Delivery using a Data Pump;
\n 3. Bidirectional Configuration;
\n 4. Initial Load;
\n5. Abount the trails:
\n 1. To support the continuous extraction and replication of database changes, Oracle GoldenGate stores the captured changes temporarily on disk in a series of files called a trail;
\n 2. A trail can exist on the source or target system, or an intermediary system, depending on your configuration;
\n 3. On the local system it’s know as an extract trail(or local trail), On a remote system it’s known as a remote trail;
\n 4. All files names in a trail begin with the same two characters which you assign when you create the trail(max 10m default). As files are created, each name is appended with a unique, six-digit serial number from 000000 through 999999, for example:\/gg11\/dirdat\/tr000018;
\n6. Data Pump:In most business cases, you should use a data pump, some reasons for using a data pump include the followint;
\n 1. Protection against network and target failures;
\n 2. Implementing serveral phases of data filtering or transformation;
\n 3. Consolidating data from many sources to a central target;
\n 4. Synchronizing one source with multiple targets;
\n7. Procesing Methods:
\n 1. Oracle GoldenGate can be configured for the following purposes:
\n 1. A static extraction of selected data records from one database and loading of those records to another database;
\n 2. Online or batch extraction and replication of selected transactional data changes and DDL changes(for supported database) to keep source and target data consistent;
\n 3. Extraction from database and replication to a file outside the database;
\n 2. Methods:
\n 1. An online process runs until stopped by a user, you can use online processes to continuously extract and replicate transactional changes and DDL changes(where supported);
\n 2. A bach run, or special run, process extracts or replicates database changes that were generated within know begin and end points;
\n 3. A task is a special type of batch run process and is used for certain initial load methods. A task is a configuration in which Extract communicates directly with Replicat over TCP\/OP. Neither a Collector process nor temporary disk storage in a trail or file is used;
\n8. Checkpointing:Capture, Pump, and Delivery save positions to a checkpoint file so they can recover in case of failure;
\n9. Parameters, Process Groups and Commands:
\n 1. GoldenGate processes are configured by ASCII parameter files;
\n 2. A process group consists of:
\n 1. An Extract or Replicat process;
\n 2. Associated parameter file;
\n 3. Associated checkpoint file;
\n 4. Any other files associated with that process;
\n 5. Each process group on a system must have a unique group name;
\n 3. Processes are added and started using the GoldenGate Software Command Interface(GGSCI) with the group name;
\n 4. GGSCI commands also add trails, check process status,etc;<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle GoldenGate Technical Architecture 1. Objectives: […]<\/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-1410","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1410","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=1410"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1410\/revisions"}],"predecessor-version":[{"id":1411,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1410\/revisions\/1411"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1410"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}