ORACLE 11G GOLDENGATE CLASS

       ORACLE 11G GOLDENGATE ONLINE AND CLASSROOM COURSE

We are going to start ORACLE 11G Goldengate classes online and classroom.  Our location is bangalore. 



Pre-requisties:  ORACLE DBA knowledge
Platform: OEL 5.4 version
Duration: 30-40hrs
Contact:enquiry@amktechs.com
Contact:+91-8553162006

Please contact through email id, drop a your contact number so that we can call back.


Syllabus:

Chapter 1  Introduction to Oracle GoldenGate

Oracle GoldenGate supported processing methods and databases

Overview of the Oracle GoldenGate architecture

Overview of process types

Overview of groups

Overview of the Commit Sequence Number (CSN)

Chapter 2 Installing Oracle GoldenGate

Downloading Oracle GoldenGate  

Setting ORACLE_HOME and ORACLE_SID

Specifying Oracle variables on UNIX and Linux systems  

Specifying Oracle variables on Windows systems

Setting library paths for dynamic builds on UNIX

Preparing to install Oracle GoldenGate within a cluster

Installing as the Oracle user

Supported Oracle cluster storage

Deciding where to install Oracle GoldenGate binaries and files in the cluster  

Installing Oracle GoldenGate on Linux and UNIX

Installing Oracle GoldenGate on Windows  

Installing Oracle GoldenGate into a Windows Cluster  

Installing the Oracle GoldenGate files  

Specifying a custom Manager name

Installing Manager as a Windows service  

Integrating Oracle GoldenGate into a cluster  

General requirements in a cluster

Adding Oracle GoldenGate as a Windows cluster resource  

Installing support for Oracle sequences

Chapter3  Configuring Manager and Network Communications   

Overview of the Manager process  

Assigning Manager a port for local communication

Maintaining ports for remote connections through firewalls   

Choosing an internet protocol     

Recommended Manager parameters

Creating the Manager parameter file

Starting Manager    

Stopping Manager   

Chapter4  Getting started with the Oracle GoldenGate process interfaces  

Using the GGSCI commandline interface   

Using UNIX batch and shell scripts   

Using Oracle GoldenGate parameter files  

Supported characters in object names     

Specifying object names in Oracle GoldenGate input 

Chapter5  Using Oracle GoldenGate for live reporting    

Overview of the reporting configuration              

Considerations when choosing a reporting configuration        

Creating a standard reporting configuration             

Creating a reporting configuration with a data pump on the source system   

Creating a reporting configuration with a data pump on an intermediary system

Creating a cascading reporting configuration           

Chapter6  Using Oracle GoldenGate for realtime data distribution         

Overview of the datadistribution configuration           

Considerations for a datadistribution configuration    

Creating a data distribution configuration             

Chapter7  Configuring Oracle GoldenGate for realtime data warehousing      

Overview of the datawarehousing configuration             

Considerations for a data warehousing configuration      

Creating a data warehousing configuration             

Chapter8  Configuring Oracle GoldenGate to maintain a live standby database   

Overview of a live standby configuration               

Considerations for a live standby configuration           

Creating a live standby configuration                 

Moving user activity in a planned switchover           

Moving user activity in an unplanned failover            

Chapter9  Configuring Oracle GoldenGate for activeactive high availability   

Overview of an activeactive configuration            

Considerations for an activeactive configuration         

Preventing data looping                  

Creating an activeactive configuration              

Managing conflicts                     

Handling conflicts with the Oracle GoldenGate CDR feature      

Configuring Oracle GoldenGate CDR                

CDR example : All conflict types with USEMAX, OVERWRITE, DISCARD   

CDR example : UPDATEROWEXISTS with USEDELTA and USEMAX     

CRD example : UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE  

Chapter10  Mapping and manipulating data                 

Limitations of support                   

Parameters that control mapping and data integration           

Mapping between dissimilar databases              

Deciding where data mapping and conversion will take place       

Globalization considerations when mapping data            

Mapping columns                      

Selecting rows                        

Retrieving before values                    

Selecting columns                     

Selecting and converting SQL operations             

Using transaction history                    

Testing and transforming data                 

Using tokens 

                    

Chapter11  Handling Oracle GoldenGate processing errors            

Overview of Oracle GoldenGate error handling           

Handling Extract errors                    

Handling Replicat errors during DML operations           

Handling Replicat errors during DDL operations          

Handling TCP/IP errors                   

Maintaining updated error messages              

Resolving Oracle GoldenGate errors      

          

Chapter12  Associating replicated data with metadata              

Configuring Oracle GoldenGate to assume identical metadata      

Configuring Oracle GoldenGate to assume dissimilar metadata      

Configuring Oracle GoldenGate to use a combination of similar and dissimilar definitions

Chapter13  Configuring online change synchronization            

Overview of online change synchronization            

Configuring change synchronization to satisfy a specific topology    

Naming conventions for groups                

Creating a checkpoint table                  

Creating an online Extract group                  

Creating a trail                        

Creating a parameter file for online extraction                      

Creating an online Replicat group                

Creating a parameter file for online replication            

Controlling online processes                 

Deleting a process group     

            

Chapter14  Running an initial data load                    

Overview of initial data load methods              

Using parallel processing in an initial load            

Prerequisites for initial load                   

Loading data with a database utility                 

Loading data from file to Replicat                  

Loading data from file to database utility             

Loading data with an Oracle GoldenGate direct load          

Loading data with a direct bulk load to SQL*Loader            

Loading data with Teradata load utilities              

Chapter15  Customizing Oracle GoldenGate processing             

Overview of custom processing                

Executing commands, stored procedures, and queries with SQLEXEC    

Using Oracle GoldenGate macros to simplify and automate work      

Using user exits to extend Oracle GoldenGate capabilities          

Using the Oracle GoldenGate event marker system to raise database events    

Chapter16  Monitoring Oracle GoldenGate processing              

Overview of the Oracle GoldenGate monitoring tools          

Using the information commands in GGSCI             

Monitoring an Extract recovery                 

Monitoring lag                        

Monitoring processing volume                 

Using the error log                     

Using the process report                   

Using the discard file                      

Using the system logs                    

Reconciling time differences                 

Sending event messages to a NonStop system            

Getting more help with monitoring and tuning           

Chapter17  Performing administrative operations               

Overview of administrative operations             

Performing application patches                

Adding process groups

Initializing the transaction logs                 

Shutting down the system                 

Changing database attributes                   

Changing the size of trail files                

Chapter18  Undoing data changes with the Reverse utility            

Overview of the Reverse utility                 

Reverse utility restrictions                  

Configuring the Reverse utility                  

Creating process groups and trails for reverse processing       

Running the Reverse utility                    

Undoing the changes made by the Reverse utility