Posts

Migrating Golden gate from Active Data Guard to Primary

-
                                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 sam...
Post a Comment
Read more

Oracle Golden Gate FAQ

-
Image
                                                      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...
1 comment
Read more