-
                         syllabus for ogg 12c exam Exam Number: 1Z0-447

Oracle GoldenGate (OGG) Overview
? Describe OGG functional overview and common topologies
? Describe OGG Veridata and Management Pack functionality
? Describe the difference between real-time data integration replication and Data Manipulation Language (DML) replication

Architecture Overview
? Describe OGG components
? Create the two types of Capture processes for Oracle database
? Create the three types of Replicat processes
? Explain the difference between an Extract and Pump, and local and remote trails
? Configure OGG's process recovery mechanism

Install and Configure OGG
? Download and Install OGG, and differentiate between various installers (zip, OUI, tar)
? Synchronize source and target databases with the Initial Load
? Prepare database for OGG CDC and check databases with OGG schema check script
? Configure OGG Replication component parameter files
? Configure the OGG Command Interface to create OGG processes
? Describe how to identify and resolve issues in heterogeneous replication, and provide appropriate solutions
? Configure OGG utilities

Parameters
? Describe and compare GLOBALS versus MANAGER parameters
? Create solutions using component parameters for replication requirements
? Install OGG parameters
? Explain and identify parameters specific for non-Oracle databases

Mapping and Transformation Overview
? Implement use cases for transformation functions
? Implement macros

Configuration Options
? Describe OGG configuration options (Data Definition Language (DDL), compression and encryption options)
? Configure OGG event actions based on use cases
? Troubleshoot conflict detection and resolution
? Configure Integrated Capture, Replicat, and deployment options

Managing and Monitoring Oracle GoldenGate
? Manage OGG command and data security
? Implement and troubleshoot OGG Monitoring
? Explain the configuration and management of the  Enterprise Manager 12c plug-in
? Implement and troubleshoot OGG Veridata

Comments

Post a Comment

Popular posts from this blog

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 Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of log
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:                  1586.3900894393 (6815719025849)  Redo Seq:             74058 Redo RBA:             104066064          Status:               Running            ------------------------------------------------------------ XID:            
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the forward operations Reversing the ordering of database operations in an extract file, a series of extract
Read more