Download Oracle GoldenGate 12c Fundamentals for Oracle_D84357GC10_ag PDF

TitleOracle GoldenGate 12c Fundamentals for Oracle_D84357GC10_ag
TagsOracle Database Computer Data Sql Databases Data Management
File Size1.6 MB
Total Pages180
Table of Contents
                            Oracle GoldenGate 12c:  Fundamentals for Oracle - Activity Guide
Table of Contents
Practices for Lesson 1: Introduction
	Practices for Lesson 1
Practices for Lesson 2: Technology Overview
	Practices for Lesson 2
Practices for Lesson 3: Oracle GoldenGate Architecture
	Practices for Lesson 3
Practices for Lesson 4: Installing Oracle GoldenGate
	Practices for Lesson 4: Overview
	Practice 4-1: Preparation and Installation
	Practice 4-2: Introduction to the GGSCI Command Interface
Practices for Lesson 5: Configuration Overview and Preparing the Environment
	Practices for Lesson 5: Overview
	Practice 5-1: Preparing Your Environment
	Practice 5-2: Creating the GLOBALS Parameter File
	Practice 5-3: Configuring and Starting Oracle GoldenGate Manager
	Practice 5-4: Using the TranData option
Practices for Lesson 6: Configuring Change Capture
	Practices for Lesson 6: Overview
	Practice 6-1: Setting Up the Extract and ExtTrail
	Practice 6-2: Setting Up an Extract Data Pump and Starting the Two Extracts
Practices for Lesson 7: Configuring Change Delivery
	Practices for Lesson 7: Overview
	Practice 7-1: Setting Up the Checkpoint Table on the Target System
	Practice 7-2: Setting Up Replicat Delivery
	Practice 7-3: Generating Data and Starting GoldenGate Processes
	Practice 7-4: Stopping Processes and Checking Statistics
Practices for Lesson 8: Extract Trail and Files
	Practices for Lesson 8: Overview
	Practice 8-1: Using the logdump Utility
Practices for Lesson 9: Configuring Initial Load
	Practices for Lesson 9: Overview
	Practice 9-1: Setting Up the Initial Load by Using the File to Replicat Method
	Practice 9-2: Setting Up the Initial Data Load by Using the Direct Load Method
	Practice 9-3: Putting it All Together
	Practice 9-4: Converting from Classic Mode to Integrated Mode
Practices for Lesson 10: Oracle GoldenGate Parameters
	Practices for Lesson 10: Overview
	Practice 10-1: Modifying Source Manager Parameters
	Practice 10-2: Modifying the Target Manager Parameters
	Practice 10-3: Modifying the Extract Parameters on the Source Database
Practices for Lesson 11: Data Selection and Filtering
	Practices for Lesson 11: Overview
	Practice 11-1: Increasing Performance by Splitting Replication Loads
	Practice 11-2: Increasing Performance by Coordinated Applies
Practices for Lesson 12: Additional Transformation Topics
	Practices for Lesson 12: Overview
	Practice 12-1: Modifying an Existing Set of Macros and Using User Tokens
Practices for Lesson 13: Configuration Options
	Practices for Lesson 13: Overview
	Practice 13-1: Setting Up the Database and Source Definitions File
	Practice 13-2: Oracle GoldenGate Encryption Using ENCKEYS
	Practice 13-3: Generating Transactions and Validating Results
	Practice 13-4: Encryption Using Wallets
Practices for Lesson 14: Bidirectional Replication
	Practices for Lesson 14: Overview
	Practice 14-1: Two-Way Active-Active Data Replication
	Practice 14-2: Conflict Detection and Resolution
Practices for Lesson 15: DDL Replication
	Practices for Lesson 15: Overview
	Practice 15-1: DDL Replication Database Setup
	Practice 15-2: DDL Replication Oracle GoldenGate Setup
                        
Document Text Contents
Page 1

Oracle GoldenGate 12c:
Fundamentals for Oracle

Activity Guide

D84357GC10

Edition 1.0

January 2014

D85202

O
ra

cl
e

In
te

rn
al

&
O

ra
cl

e
A

ca
de

m
y

U
se

O
nl

y

Page 2

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Disclaimer

This document contains proprietary information and is protected by copyright and
other intellectual property laws. You may copy and print this document solely for your
own use in an Oracle training course. The document may not be modified or altered
in any way. Except where your use constitutes "fair use" under copyright law, you
may not use, share, download, upload, copy, print, display, perform, reproduce,
publish, license, post, transmit, or distribute this document in whole or in part without
the express authorization of Oracle.

The information contained in this document is subject to change without notice. If you
find any problems in the document, please report them in writing to: Oracle University,
500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not
warranted to be error-free.

Restricted Rights Notice


If this documentation is delivered to the United States Government or anyone using
the documentation on behalf of the United States Government, the following notice is
applicable:

U.S. GOVERNMENT RIGHTS
The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or
disclose these training materials are restricted by the terms of the applicable Oracle
license agreement and/or the applicable U.S. Government contract.


Trademark Notice


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names
may be trademarks of their respective owners.




Author
Steve Friedberg

Technical Contributors
and Reviewers
Mack Bell
Joseph deBuzna
Pete Daly
Joe Greenwald
Steven George
Susan Jang
Naoki Kato
Juan Quezada Nunez
Randy Richeson
Doug Reid
Ranbir Singh
Jinyu Wang
Volker Zell

Editors
Aju Kumar
Richard Wallis

Graphic Designer
Seema Bopaiah

Publishers
Pavithran Adka
Jayanthy Keshavamurthy
Srividya Rameshkumar

O
ra

cl
e

I
n

te
rn

a
l &

O
ra

cl
e

A
ca

d
e

m
y

U
se

O
n

ly

Page 90

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 10: Oracle GoldenGate Parameters

Chapter 10 - Page 6

2. Activate the changes by bouncing (stopping, and starting, or restarting) the Manager to
make the changes take effect:

GGSCI (EURO)> Stop Manager
Manager process is required by other GGS processes.

Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...

Request processed.

Manager stopped.

GGSCI (EURO)> Start Manager
Manager started.

GGSCI (EURO)>

Note: You do not have to stop any of the Extracts or Replicats to bounce the Manager.
After they are running, they are independent of the Manager.
Note: If you do Stop mgr ! (by adding an exclamation point!), it will not prompt you for
“Are you sure?”

3. Verify that the Manager has started:

GGSCI (EURO)> Info mgr
Manager is running (IP port easthost.15001, Process ID 22613).


GGSCI (EURO)>

Your host name and PID will be different.
This completes Practice 10-2. Continue now with Practice 10-3.

O
ra

cl
e

In
te

rn
al

&
O

ra
cl

e
A

ca
de

m
y

U
se

O
nl

y

Page 91

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 10: Oracle GoldenGate Parameters

Chapter 10 - Page 7

Practice 10-3: Modifying the Extract Parameters on the Source
Database

Tasks
1. Using the Oracle GoldenGate Reference Manual (online or the

ggate12c_reference_oracle_e29392.pdf file located in the ~/Documents
directory), find the parameters that perform the following and add them to the
extwest.prm file before the Table listings. Modify the Extract parameter file on the
source database AMER_WEST_GGSCI tab for the following:

GGSCI (AMER)> Edit Param extwest


Controls whether or not statistics generated by the REPORT parameter are reset when a
new process report is created

Generates interim runtime statistics in a process report. Set this parameter to report at
one minute after midnight daily.

Forces report files to age on a regular schedule, instead of when a process starts. Set
this report roll-over parameter to occur at one minute after midnight daily.

Reports a count of transaction records processed since startup. Set this report
parameter to occur every 60 seconds, and report the number of operations per second
and the change in rate.

Writes a message to the report file after processing every 1000 records.

Only extracts data from the ACCOUNT_TRANS table if the account_trans_type is equal
to "CR"
Answer: __________________________________________________________

You can check your answers against a sample file in
~/labs/Section10/solutions/amer/extwest.prm. Look for these parameters later
in the macro best practices settings MACRO #bpsettings in Practice 12-4: “Modifying an
Existing Set of Macros and User Tokens.”

O
ra

cl
e

In
te

rn
al

&
O

ra
cl

e
A

ca
de

m
y

U
se

O
nl

y

Page 179

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 15: DDL Replication

Chapter 15 - Page 15

21. Verify that the transaction data was added to the AMER source because of parameter
DDLOptions AddTranData, Report. You know it had to be added because the
Replicat worked, but check for it anyway.

GGSCI (AMER)> Info TranData WEST.*

Logging of supplemental redo log data is enabled for table WEST.ACCOUNT.
Columns supplementally logged for table WEST.ACCOUNT: ACCOUNT_NUMBER.

Logging of supplemental redo log data is enabled for table WEST.ACCOUNT_TRANS.
Columns supplementally logged for table WEST.ACCOUNT_TRANS: ACCOUNT_NUMBER,
TRANS_NUMBER, ACCOUNT_TRANS_TS.

Logging of supplemental redo log data is enabled for table WEST.BRANCH.
Columns supplementally logged for table WEST.BRANCH: BRANCH_NUMBER.

Logging of supplemental redo log data is enabled for table WEST.BRANCH_ATM.
Columns supplementally logged for table WEST.BRANCH_ATM: BRANCH_NUMBER,
ATM_NUMBER, TRANS_NUMBER, ATM_TRANS_TS.

Logging of supplemental redo log data is enabled for table WEST.TELLER.
Columns supplementally logged for table WEST.TELLER: TELLER_NUMBER.

Logging of supplemental redo log data is enabled for table WEST.TELLER_TRANS.
Columns supplementally logged for table WEST.TELLER_TRANS: TELLER_NUMBER,
TRANS_NUMBER, TELLER_TRANS_TS.

GGSCI (AMER)>

This completes Practice 15-2. This completes the practices for Lesson 15. Stop here.

If you are in a classroom, ask the instructor whether you should leave the PCs running or not,
signed in, or logged off.


O
ra

cl
e

I
n

te
rn

a
l &

O
ra

cl
e

A
ca

d
e

m
y

U
se

O
n

ly

Page 180

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.

Practices for Lesson 15: DDL Replication

Chapter 15 - Page 16



O
ra

cl
e

In
te

rn
al

&
O

ra
cl

e
A

ca
de

m
y

U
se

O
nl

y

Similer Documents