Oracle Golden Gate

                                Migrating Golden gate from Active Data Guard to Primary 1. GG set up in Primary DB – Ops.DBA team  [2-4 days needed for setup] a. New setup of GG – on Primary i. Unix team 1. Create user 2. Create Group 3. Folder Permissions 4. Setup of PowerBroker a. 2 teams need to be added : Ops.DBA, EIMSGG ii. Install GG software 1. No reboot required b. Confirm ports are opened from Primary DB to Exadata and Teradata i. Have scripts to run to check ii. EIMSGG to get confirmation ports are already open 1. If not, then need to submit port opening request [takes 1-2 weeks] c. WO raised to Ops.DBA for i. SW installation ii. Approvals required iii. Ops.DBA to raise SSH access Unix.  Then set up permissions for GG d. Verification by EIMSGG team [post software installation and necessary permission granted as above] 2. GG Replication for sample tables – EIMSGG team [1 day] a. EIMSGG team will test GG replication on one table f

                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of log