Email Us : sunilkumark11@gmail.com

CourseOracle GoldenGate
Time converter at worldtimebuddy.com
Cost Of The TrainingINR: 10,000
Total Duration2 Weeks
Each Session---
Trainer---
Start Date And Time---

Course Description
1. Introduction
   What is Golden Gate?
   Oracle Golden Gate Evolution. Oracle Golden Gate solutions
2. Oracle GoldenGate Architecture
   A number of system architecture solutions are offered for data replication and synchronization.
   Topologies supported by Golden Gate. Overview of the Oracle Golden Gate architecture.
   Components of Oracle Golden Gate. A simple architecture of golden gate.
3. Installation
   Prerequisites of golden gate Configuring Golden Gate.
   Download Golden Gate Binaries.
   Creation of a directory for Golden Gate Software.
   Set the environment Variables in bash profile.
   Create Custom Sub-Directories.
   Create Golden Gate Subdirectories from GGSCI.
   Configuring the Golden Gate Admin User, Tablespace and Golden Gate User.
   Enable Archive log and add Supplemental log data
4. Explaining the directories , Preparing the setup
   Explanation of Custom subdirectories. Explanation of Golden Gate subdirectories.
   Arranging the setup for golden Gate.
5. Explaining manager process ,extract and replicat.
   Set the parameter for manager process ,extract and replicat processes.
   Statuses of manager , extract and replicat processes.
   Responsibilities of manager , extract and replicat processes.
   Start the manager , extract and replicat processes.
   Stop the manager , extract and replicat processes.
6. Initial Load, Uni direction replication
   Create a Golden Gate Checkpoint table.
   Create an Extract group.
   Create a parameter file for the online Extract group.
   Create a Trail.
   Create a Replicat group.
   Create a parameter file for the online Replicat group.
   Start all the processes.
   Test Uni direction replication.
7. Configuring Data pump.
   Create a Golden Gate Checkpoint table.
   Create an Extract group.
   Create a parameter file for the online Extract group.
   Create a Trail.
   Create a datapump extract process. Set the parameters for data pump process
   Create a Replicat group.
   Create a parameter file for the online Replicat group.
   Start all the processes.
   Stop the network connection.
   Check the unidirection replication using datapump.
8. DDL synchronization with data pump ,DDL Removal.
   Run the scripts as sysdba. Run marker_setup.
   Set recyclebin off. Run ddl_setup.
   Run role_setup.
   Grant the ggs_gguser_role to gg_owner.
   Run the ddl_enable. Run the ddl_pin.
   Enable additional logging at the table level.
   Removing the DDL synchronization with the scripts.
9. Monitor Golden Gate
   Using different command to monitor
   Golden Gate environment.
   Statistics of all processes.
   Reports of all processes.
   Viewing error logs.
10. Bidirectional configuration (oracle - oracle)
   Explaining of Bidirectional configuration architecture.
   Set the parameters for checkpoint table on both source and target sides.
   Add the checkpoint table on both sides.
   Enable the DDL sync on both sides.
   Add the transactional data on both schemas on source and target respectively.
   Set the parameter files for all extract ,data pump and replicat processes.
   Testing of all the DML and DDL changes on both sides
11. Uninstalling Golden gate
   Stop all Golden Gate processes.
   Remove the Golden Gate files.
   Drop the golden gate users.
   
 

Thank You