| About the Author |
|
xxvii | |
| About the Technical Reviewer |
|
xxix | |
| Acknowledgments |
|
xxxi | |
| Introduction |
|
xxxiii | |
|
|
|
1 | (114) |
|
Chapter 1 Introduction to Oracle GoldenGate (OGG) |
|
|
3 | (8) |
|
What's So Magical About Oracle GoldenGate? |
|
|
3 | (2) |
|
|
|
5 | (1) |
|
Available Replication Options |
|
|
5 | (2) |
|
Advantages of Oracle GoldenGate |
|
|
7 | (1) |
|
When to Use Oracle GoldenGate? |
|
|
7 | (1) |
|
Oracle GoldenGate vs. Streams |
|
|
8 | (1) |
|
Oracle GoldenGate vs. Data Guard |
|
|
8 | (1) |
|
Oracle GoldenGate vs. SharePlex |
|
|
9 | (1) |
|
Oracle GoldenGate 12c New Features |
|
|
10 | (1) |
|
|
|
10 | (1) |
|
|
|
11 | (14) |
|
Overview of the Components |
|
|
12 | (2) |
|
|
|
12 | (1) |
|
|
|
12 | (1) |
|
|
|
13 | (1) |
|
|
|
13 | (1) |
|
|
|
14 | (1) |
|
|
|
14 | (1) |
|
|
|
14 | (1) |
|
Support for Non-Oracle Databases |
|
|
14 | (1) |
|
|
|
15 | (8) |
|
Unidirectional Replication |
|
|
15 | (1) |
|
Bidirectional Replication |
|
|
16 | (2) |
|
|
|
18 | (1) |
|
|
|
19 | (2) |
|
|
|
21 | (2) |
|
|
|
23 | (2) |
|
Chapter 3 Oracle GoldenGate Pre-installation Tasks |
|
|
25 | (16) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
|
|
25 | (1) |
|
Configuring Your Database and Server for Oracle GoldenGate |
|
|
26 | (3) |
|
Enable Logging for Oracle Databases |
|
|
27 | (1) |
|
Enable Logging for Sybase Databases |
|
|
27 | (1) |
|
Enable Logging for Microsoft SQL Server Databases |
|
|
28 | (1) |
|
|
|
29 | (4) |
|
Supported Data Types for Oracle Databases |
|
|
29 | (2) |
|
Supported Data Types for SYBASE Databases |
|
|
31 | (1) |
|
Supported Data Types for MySQL Databases |
|
|
32 | (1) |
|
Supported Data Types for SQL Server Databases |
|
|
33 | (1) |
|
Supported Data Types for DB2 Databases on LUW |
|
|
33 | (1) |
|
Supported Data Types for DB2 Databases on z/OS |
|
|
33 | (1) |
|
|
|
33 | (2) |
|
Database Operations Captured for Oracle Databases |
|
|
33 | (1) |
|
Database Operations Captured on Sybase Databases |
|
|
34 | (1) |
|
Database Operations Captured on MySQL Databases |
|
|
34 | (1) |
|
Database Operations Captured on SQL Server Databases |
|
|
34 | (1) |
|
Database Operations Captured on DB2 Databases for LUW |
|
|
35 | (1) |
|
Database Operations Captured on Sybase Databases for z/OS |
|
|
35 | (1) |
|
Designing Your GoldenGate Replication Setup |
|
|
35 | (3) |
|
Why Choose Standard Naming Conventions? |
|
|
35 | (1) |
|
Naming Capture and Delivery Process |
|
|
35 | (1) |
|
|
|
36 | (2) |
|
Database Privileges for GoldenGate Users |
|
|
38 | (2) |
|
OGG User Permissions in Oracle Databases |
|
|
38 | (1) |
|
OGG User Permissions in Sybase Databases |
|
|
39 | (1) |
|
OGG User Permissions in IBM DB2 Databases |
|
|
39 | (1) |
|
OGG User Permissions in MySQL Databases |
|
|
39 | (1) |
|
OGG User Permissions in Teradata Databases |
|
|
40 | (1) |
|
|
|
40 | (1) |
|
Chapter 4 Installing Oracle GoldenGate |
|
|
41 | (24) |
|
|
|
41 | (1) |
|
Setting Up Environmental Variables |
|
|
42 | (1) |
|
Setting Up Database Logging |
|
|
42 | (1) |
|
Setting Up User Privileges |
|
|
43 | (1) |
|
Installing Oracle GoldenGate on Unix/Linux |
|
|
43 | (15) |
|
Step 1 Log In as the Linux Superuser |
|
|
43 | (1) |
|
Step 2 Navigate to the GoldenGate Directory |
|
|
44 | (1) |
|
Step 3 Copy or FTP the GoldenGate Software File from the Local System or Remote Server |
|
|
44 | (1) |
|
Step 4 Locate the Installer |
|
|
44 | (1) |
|
Step 5 Begin Installation |
|
|
44 | (7) |
|
|
|
51 | (1) |
|
Step 7 Create Subdirectories |
|
|
52 | (1) |
|
Step 8 Configure the Manager Port |
|
|
52 | (1) |
|
Step 9 Start/Stop the Manager |
|
|
53 | (1) |
|
Step 10 Check Supplemental Logging for the Database |
|
|
53 | (1) |
|
|
|
54 | (1) |
|
Step 12 Install Oracle GoldenGate on the Target Machine |
|
|
54 | (1) |
|
|
|
55 | (1) |
|
Step 14 Create the Definition File |
|
|
55 | (1) |
|
Step 15 Enable Supplemental Logging for Oracle GoldenGate |
|
|
56 | (1) |
|
Step 16 Initial Data Synchronization |
|
|
56 | (1) |
|
Step 17 Start the Manager, Extract, and Replicat, and Test the Result |
|
|
57 | (1) |
|
|
|
58 | (1) |
|
Parameters in the Response File |
|
|
59 | (1) |
|
|
|
59 | (1) |
|
|
|
60 | (3) |
|
|
|
62 | (1) |
|
|
|
62 | (1) |
|
|
|
62 | (1) |
|
|
|
63 | (1) |
|
|
|
63 | (2) |
|
Chapter 5 Classic vs. Integrated Capture and Apply |
|
|
65 | (18) |
|
|
|
65 | (3) |
|
|
|
65 | (1) |
|
|
|
66 | (1) |
|
|
|
67 | (1) |
|
|
|
68 | (1) |
|
|
|
68 | (1) |
|
|
|
68 | (1) |
|
Support for Multitenant Databases |
|
|
69 | (1) |
|
Implementing Classic and Integrated Captures |
|
|
69 | (5) |
|
Creating a Classic Capture |
|
|
69 | (2) |
|
Creating an On-Source Integrated Capture |
|
|
71 | (1) |
|
Creating an Integrated Capture Using a Downstream Mining Database |
|
|
72 | (2) |
|
Monitoring an Integrated Capture |
|
|
74 | (1) |
|
Upgrading Classic Capture Mode to Integrated Capture Mode |
|
|
75 | (3) |
|
Creating a Classic Capture |
|
|
75 | (1) |
|
Upgrading to an Integrated Capture |
|
|
76 | (2) |
|
Implementing Classic and Integrated Apply |
|
|
78 | (2) |
|
|
|
78 | (1) |
|
Creating an Integrated Apply |
|
|
78 | (2) |
|
Capture and Apply Modes, Mix and Match |
|
|
80 | (1) |
|
|
|
80 | (2) |
|
|
|
82 | (1) |
|
Chapter 6 Capturing DDL Changes |
|
|
83 | (20) |
|
|
|
83 | (1) |
|
|
|
84 | (1) |
|
Limitations with DDL Replication |
|
|
84 | (1) |
|
|
|
85 | (1) |
|
How Does DDL Replication Work? |
|
|
86 | (1) |
|
|
|
86 | (1) |
|
|
|
86 | (1) |
|
DDL Capture in Classic Capture Mode |
|
|
87 | (2) |
|
An Example of Classic Capture DDL |
|
|
89 | (7) |
|
DDL Capture in Integrated Capture Mode |
|
|
96 | (1) |
|
Selective DDL Replication with an Oracle Source DB |
|
|
96 | (4) |
|
Selective DDL Replication Using DDLAUX.addRule() |
|
|
97 | (2) |
|
Selective DDL Replication Using the DDL Parameter |
|
|
99 | (1) |
|
|
|
100 | (1) |
|
DDL Replication in Active-Active Mode (Bidirectional Replication) |
|
|
101 | (1) |
|
DDL Replication in a Cascading Replication Setup |
|
|
101 | (1) |
|
DDL Replication in a Heterogeneous Environment |
|
|
101 | (1) |
|
|
|
102 | (1) |
|
Chapter 7 Performing the Initial Load |
|
|
103 | (12) |
|
Preparing for the Initial Load |
|
|
103 | (2) |
|
Initial Load Using the Database Utility |
|
|
105 | (1) |
|
Initial Load Using SQLLOADER |
|
|
106 | (2) |
|
Initial Load Using the Direct Load Method |
|
|
108 | (1) |
|
Initial Load Using BULKLOAD to sqlloader |
|
|
109 | (1) |
|
|
|
110 | (3) |
|
|
|
113 | (2) |
|
Part II Advanced Configurations |
|
|
115 | (78) |
|
Chapter 8 Oracle GoldenGate Commands |
|
|
117 | (24) |
|
Data Transformation Using Column Conversion Functions |
|
|
117 | (3) |
|
|
|
120 | (8) |
|
Native Non-GGSCI Commands and Utilities |
|
|
128 | (11) |
|
|
|
128 | (1) |
|
|
|
129 | (1) |
|
|
|
129 | (10) |
|
|
|
139 | (2) |
|
Chapter 9 Advanced Processing |
|
|
141 | (12) |
|
Data Transformation in Oracle GoldenGate |
|
|
141 | (2) |
|
|
|
141 | (1) |
|
Data Transformation Methods |
|
|
141 | (1) |
|
Using Colmap for Column Mapping |
|
|
142 | (1) |
|
Data Transformation Examples |
|
|
142 | (1) |
|
|
|
143 | (1) |
|
|
|
143 | (1) |
|
|
|
144 | (3) |
|
|
|
147 | (2) |
|
Using Sqlexec as a Parameter to a TABLE or MAP Statement |
|
|
147 | (1) |
|
Using Sqlexec to Run Stored Procedures |
|
|
148 | (1) |
|
Using Sqlexec to Run as a Stand-Alone Parameter |
|
|
149 | (1) |
|
Macros in Oracle GoldenGate |
|
|
149 | (1) |
|
Oracle GoldenGate Auditing |
|
|
150 | (2) |
|
|
|
152 | (1) |
|
Chapter 10 Advanced Features |
|
|
153 | (20) |
|
|
|
153 | (3) |
|
|
|
153 | (1) |
|
CDR for Active-Active Replication |
|
|
154 | (1) |
|
Supported Data Types for CDR |
|
|
154 | (1) |
|
|
|
154 | (1) |
|
Conflicts During an Insert Operation |
|
|
155 | (1) |
|
Conflicts During an Update Operation |
|
|
155 | (1) |
|
Conflicts During a Delete Operation |
|
|
156 | (1) |
|
|
|
156 | (2) |
|
|
|
158 | (2) |
|
Oracle GoldenGate Performance Tuning |
|
|
160 | (4) |
|
Best Practices for Configuring Your Oracle GoldenGate Replication Environment |
|
|
160 | (1) |
|
Determining the Current Performance Statistics |
|
|
160 | (1) |
|
|
|
161 | (1) |
|
Enable Supplemental Logging |
|
|
161 | (1) |
|
|
|
161 | (1) |
|
Tuning Tcpbufsize and Tcpflushbytes |
|
|
162 | (1) |
|
|
|
162 | (1) |
|
|
|
162 | (1) |
|
Streams Pool for Integrated Extract and Replicat |
|
|
163 | (1) |
|
|
|
163 | (1) |
|
|
|
164 | (7) |
|
Encrypting Database Passwords |
|
|
164 | (1) |
|
Generating a Custom Encryption Key |
|
|
165 | (1) |
|
|
|
165 | (1) |
|
Steps for Creating a Wallet and Master Key |
|
|
166 | (1) |
|
|
|
166 | (1) |
|
Encrypt and Decrypt Trail Files |
|
|
167 | (1) |
|
Encrypt Data Sent Over a Network |
|
|
168 | (1) |
|
Using an Oracle GoldenGate Credential Store |
|
|
168 | (3) |
|
|
|
171 | (2) |
|
Chapter 11 Upgrading Oracle GoldenGate |
|
|
173 | (6) |
|
|
|
173 | (1) |
|
|
|
173 | (1) |
|
|
|
174 | (1) |
|
Upgrading Oracle GoldenGate on the Source |
|
|
175 | (1) |
|
|
|
175 | (1) |
|
Install the New Version of GoldenGate |
|
|
176 | (1) |
|
Convert Supplemental Log Group Version |
|
|
176 | (1) |
|
|
|
176 | (1) |
|
Upgrading Oracle GoldenGate on the Target |
|
|
176 | (1) |
|
|
|
176 | (1) |
|
Install the New Version of GoldenGate |
|
|
176 | (1) |
|
Upgrade the Checkpoint Table |
|
|
177 | (1) |
|
|
|
177 | (1) |
|
|
|
177 | (1) |
|
Start GoldenGate and Monitor Replication |
|
|
177 | (1) |
|
|
|
178 | (1) |
|
Chapter 12 Bidirectional Replication |
|
|
179 | (14) |
|
Key Points Before Setting Up OGG Bidirectional Replication |
|
|
180 | (1) |
|
|
|
180 | (2) |
|
Handling Data Loopbacks in Oracle Databases |
|
|
180 | (1) |
|
Handling Data Loopbacks in All Supported Databases |
|
|
181 | (1) |
|
Handling Data Loopbacks in Teradata Databases |
|
|
181 | (1) |
|
Handling Data Loopbacks by Identifying Replicat Transactions |
|
|
182 | (1) |
|
CDR in Bidirectional Replication |
|
|
182 | (6) |
|
Setting Up OGG Bidirectional Replication |
|
|
182 | (4) |
|
Adding Conflict Detection and Resolution |
|
|
186 | (1) |
|
CDR When Machine A is a Trusted Source and Always Wins |
|
|
186 | (1) |
|
CDR When Both Sites Are Equally Trusted |
|
|
187 | (1) |
|
DBFS Configuration for OGG Bidirectional Replication |
|
|
188 | (3) |
|
Step 1 Install the Patch for bug-9651229 |
|
|
188 | (1) |
|
Step 2 Configure DBFS Sequences |
|
|
189 | (1) |
|
Step 3 Create the New DBFS File Systems for OGG Replication |
|
|
189 | (1) |
|
Step 4 Configure the Extract/Replicat Processes |
|
|
190 | (1) |
|
|
|
191 | (2) |
|
Part III Managing Oracle GoldenGate |
|
|
193 | (244) |
|
Chapter 13 Oracle GoldenGate Management Pack Part 1 |
|
|
195 | (82) |
|
Oracle GoldenGate Monitor |
|
|
195 | (1) |
|
|
|
196 | (1) |
|
Install Oracle WebLogic Server |
|
|
196 | (17) |
|
Install the Oracle GoldenGate Monitor Server |
|
|
213 | (10) |
|
|
|
214 | (1) |
|
|
|
214 | (1) |
|
|
|
214 | (9) |
|
Create the OGG Monitor Repository Using RCU |
|
|
223 | (11) |
|
Create the WebLogic Server Domain Using the Configuration Wizard |
|
|
234 | (18) |
|
Configure the OGG Monitor Server |
|
|
252 | (3) |
|
Configure the JMX Server Properties |
|
|
254 | (1) |
|
SMTP, SNMP, and CLI Alert Properties |
|
|
254 | (1) |
|
Start the OGG Monitor Server |
|
|
255 | (7) |
|
Start the OGG Monitor Console |
|
|
262 | (3) |
|
Install the Oracle GoldenGate Monitor Agent |
|
|
265 | (4) |
|
Create the OGG Monitor Agent Instances |
|
|
269 | (1) |
|
Configure the OGG Monitor Agent Instances |
|
|
270 | (4) |
|
Configure the OGG Monitor Agent for the OGG Monitor Server |
|
|
270 | (3) |
|
Configure the OGG Monitor Agent When Using the OEM Plug-in for Oracle GoldenGate |
|
|
273 | (1) |
|
Create a Wallet When Using the OGG Monitor |
|
|
273 | (1) |
|
Create a Wallet When Using the OGG OEM Plug-In |
|
|
274 | (1) |
|
|
|
274 | (1) |
|
Start the OGG Monitor Agent |
|
|
274 | (1) |
|
|
|
275 | (2) |
|
Chapter 14 Oracle GoldenGate Management Pack Part II |
|
|
277 | (32) |
|
Oracle GoldenGate Enterprise Manager Plug-In |
|
|
277 | (1) |
|
Installing the OGG Plug-in for EM |
|
|
277 | (3) |
|
|
|
277 | (1) |
|
|
|
278 | (1) |
|
|
|
278 | (1) |
|
Creating an Oracle Wallet |
|
|
279 | (1) |
|
Configuring the OGG Instance to Run with OEM |
|
|
279 | (1) |
|
Starting the OGG Instance |
|
|
280 | (1) |
|
Oracle GoldenGate Director |
|
|
280 | (1) |
|
|
|
281 | (1) |
|
|
|
281 | (1) |
|
|
|
281 | (1) |
|
|
|
281 | (1) |
|
OGG Director Administrator |
|
|
281 | (1) |
|
Why Use the OGG Director? |
|
|
281 | (1) |
|
Installing the OGG Director Server |
|
|
281 | (12) |
|
|
|
282 | (1) |
|
|
|
282 | (1) |
|
|
|
282 | (1) |
|
|
|
282 | (11) |
|
Using Command-Line Installation |
|
|
293 | (1) |
|
Start and Stop the OGG Director Server |
|
|
293 | (1) |
|
Installing the OGG Director Client |
|
|
294 | (10) |
|
|
|
294 | (1) |
|
|
|
294 | (1) |
|
|
|
294 | (6) |
|
Starting the OGG Director Client |
|
|
300 | (1) |
|
Starting the OGG Director Administrator |
|
|
301 | (2) |
|
Adding, Changing, and Deleting User Accounts |
|
|
303 | (1) |
|
Adding the OGG Data Source |
|
|
303 | (1) |
|
Configuring the OGG Monitor Agent |
|
|
304 | (1) |
|
Viewing and Configuring the Monitor Settings |
|
|
304 | (1) |
|
Starting the OGG Director Web |
|
|
304 | (1) |
|
Managing Oracle GoldenGate Using Custom Scripts |
|
|
304 | (3) |
|
Monitoring the Stopped Manager and Stopped/Abended Extract/Replicat Processes |
|
|
304 | (3) |
|
|
|
307 | (2) |
|
Chapter 15 Ensuring Data Integrity with Veridata |
|
|
309 | (78) |
|
|
|
309 | (1) |
|
|
|
310 | (2) |
|
|
|
312 | (1) |
|
|
|
312 | (1) |
|
Installing the OGG Veridata Server |
|
|
313 | (9) |
|
|
|
313 | (1) |
|
|
|
314 | (8) |
|
Create the OGG Veridata Repository Using RCU |
|
|
322 | (10) |
|
Create an Oracle WebLogic Domain for OGG Veridata |
|
|
332 | (16) |
|
Start Veridata Managed Server |
|
|
348 | (5) |
|
Install the OGG Veridata Agent |
|
|
353 | (5) |
|
Deploy the OGG Veridata Agent |
|
|
358 | (1) |
|
Start and Stop the Veridata Agent |
|
|
359 | (2) |
|
Creating and Running OGG Veridata Compare Jobs |
|
|
361 | (21) |
|
|
|
382 | (3) |
|
Executing Vericom Commands |
|
|
382 | (2) |
|
|
|
384 | (1) |
|
Running a Job Using Vericom |
|
|
385 | (1) |
|
Uninstalling OGG Veridata |
|
|
385 | (1) |
|
|
|
386 | (1) |
|
Chapter 16 Troubleshooting Oracle GoldenGate |
|
|
387 | (24) |
|
|
|
387 | (1) |
|
Where to Look for Errors? |
|
|
388 | (3) |
|
|
|
388 | (1) |
|
|
|
389 | (1) |
|
|
|
390 | (1) |
|
Troubleshooting Using the LOGDUMP Utility |
|
|
391 | (1) |
|
Troubleshooting Using SHOWSYNTAX |
|
|
392 | (1) |
|
Performing a Sanity Check |
|
|
392 | (1) |
|
Troubleshooting Examples: Issues with the Extract Processes |
|
|
393 | (2) |
|
Extract Abended Due to Privilege Issue |
|
|
393 | (1) |
|
Extract Abended/Stopped Due to Disk Space Full |
|
|
394 | (1) |
|
Extract Abended Due to Network Communication Error |
|
|
394 | (1) |
|
Extract Abended Due to Memory Allocation Error |
|
|
394 | (1) |
|
Extract Abended Due to ORA-03135 |
|
|
394 | (1) |
|
Troubleshooting Examples: Issues with Replicat Processes |
|
|
395 | (2) |
|
Replicat Abended/Stopped Due to Missing Checkpoint Table |
|
|
395 | (1) |
|
Replicat Abended/Stopped Due to Corrupt Checkpoint Table or Missing Data in Checkpoint Table |
|
|
395 | (1) |
|
Replicat Abended Due to Table Structure or Data Inconsistency Error |
|
|
396 | (1) |
|
Replicat Abended Due to Error Processing DDL Statement |
|
|
396 | (1) |
|
Replicat Abended Due to Table Not Present in Target Schema |
|
|
396 | (1) |
|
Replicat Abended Due to Discard File Full |
|
|
397 | (1) |
|
Troubleshooting Examples: Data Sync Issues |
|
|
397 | (2) |
|
Troubleshooting Examples: DDL Capture Issue |
|
|
399 | (5) |
|
Troubleshooting Examples: Trail Files Corruption |
|
|
404 | (3) |
|
Corrupt Trail on the Source |
|
|
405 | (1) |
|
Corrupt Trail on the Target |
|
|
406 | (1) |
|
Using LOGDUMP to Point the Replicat to a Good RBA |
|
|
406 | (1) |
|
|
|
407 | (1) |
|
Error Handling in Oracle GoldenGate |
|
|
407 | (3) |
|
|
|
410 | (1) |
|
Chapter 17 Using Oracle GoldenGate Adapters |
|
|
411 | (26) |
|
Generating Flat Files in Real Time |
|
|
411 | (2) |
|
|
|
413 | (1) |
|
Downloading OGG Application Adapters |
|
|
413 | (1) |
|
Installing the OGG Application Adapter |
|
|
413 | (1) |
|
|
|
413 | (3) |
|
Creating the OGG User and Role |
|
|
416 | (1) |
|
Preparing the Database for Flat-File Extraction |
|
|
417 | (1) |
|
Adding a Checkpoint Table |
|
|
418 | (1) |
|
Generating the Table Definitions |
|
|
418 | (1) |
|
Creating the Flat-File Adapter Properties File |
|
|
418 | (1) |
|
Creating the Primary Extract |
|
|
419 | (1) |
|
Creating the User Exit Extract |
|
|
420 | (1) |
|
|
|
420 | (1) |
|
|
|
420 | (2) |
|
Flat-File Adapter Properties |
|
|
422 | (6) |
|
Troubleshooting Your Flat-File Configuration |
|
|
428 | (1) |
|
|
|
429 | (1) |
|
|
|
429 | (4) |
|
Implementation Overview for JMS Delivery |
|
|
429 | (1) |
|
|
|
429 | (1) |
|
Configuring the Primary and Data Pump Extracts on the Source Database Server |
|
|
430 | (1) |
|
Configuring Data Integration on the Target Server |
|
|
431 | (2) |
|
|
|
433 | (3) |
|
Implementation Overview for JMS Capture |
|
|
433 | (1) |
|
|
|
433 | (1) |
|
Configuring the VAM Extract |
|
|
434 | (1) |
|
Configuring the VAM Properties File |
|
|
434 | (1) |
|
Creating a Definition File for JMS Message |
|
|
435 | (1) |
|
Configuring the Data Pump Extract |
|
|
436 | (1) |
|
Configuring the Replicat on the Target Server |
|
|
436 | (1) |
|
|
|
436 | (1) |
|
Part IV Exploring GoldenGate Possibilities |
|
|
437 | |
|
Chapter 18 Configuring Oracle GoldenGate HA |
|
|
439 | (18) |
|
HA Using Oracle Clusterware |
|
|
439 | (2) |
|
Oracle Clusterware for OGG |
|
|
440 | (1) |
|
|
|
440 | (1) |
|
Setting Up the Oracle ACFS File System |
|
|
441 | (5) |
|
Installing Oracle GoldenGate HA |
|
|
446 | (1) |
|
|
|
447 | (9) |
|
Step 1 Create a Minimum of a Two-Node System with Oracle GoldenGate |
|
|
447 | (1) |
|
Step 2 Create a VIP for the Oracle GoldenGate Application |
|
|
447 | (2) |
|
Step 3 Create the Agent Script |
|
|
449 | (2) |
|
Step 4 Add a Clusterware Resource for the Oracle GoldenGate Application |
|
|
451 | (1) |
|
Step 5 Start the Resource Using Oracle Clusterware |
|
|
451 | (1) |
|
Step 6 Manage the Application |
|
|
452 | (1) |
|
|
|
453 | (3) |
|
|
|
456 | (1) |
|
Chapter 19 Oracle GoldenGate for Big Data |
|
|
457 | (34) |
|
Downloading Oracle GoldenGate for Big Data |
|
|
458 | (1) |
|
Installing Oracle GoldenGate for Big Data |
|
|
458 | (3) |
|
Running the OGG Java Adapter with the Replicat Process |
|
|
458 | (2) |
|
Running the OGG Java Adapter with the Extract Process |
|
|
460 | (1) |
|
Oracle GoldenGate Adapter for Apache Flume |
|
|
461 | (1) |
|
|
|
461 | (1) |
|
|
|
461 | (1) |
|
|
|
461 | (1) |
|
|
|
462 | (4) |
|
Download and Install Maven |
|
|
462 | (1) |
|
|
|
462 | (1) |
|
Build the OGG Adapter for Flume |
|
|
463 | (2) |
|
Configure the OGG Adapter for Flume |
|
|
465 | (1) |
|
|
|
466 | (1) |
|
Create the Replicat Process |
|
|
466 | (1) |
|
Start the OGG Adapter for Flume |
|
|
467 | (1) |
|
|
|
467 | (1) |
|
Oracle GoldenGate Big Data Adapter for HDFS |
|
|
468 | (1) |
|
|
|
469 | (4) |
|
Download and Install Maven |
|
|
469 | (1) |
|
|
|
469 | (1) |
|
Build the OGG Adapter for HDFS |
|
|
470 | (2) |
|
Configure the OGG Adapter for HDFS |
|
|
472 | (1) |
|
|
|
473 | (1) |
|
Create the Replicat Process |
|
|
473 | (1) |
|
Start the OGG Adapter for HDFS |
|
|
473 | (1) |
|
|
|
474 | (1) |
|
Oracle GoldenGate Adapter for Hive |
|
|
475 | (1) |
|
|
|
476 | (3) |
|
Download and Install Maven |
|
|
476 | (1) |
|
|
|
476 | (1) |
|
Build the OGG Adapter for Hive |
|
|
476 | (2) |
|
Configure the OGG Adapter for Hive |
|
|
478 | (1) |
|
|
|
479 | (2) |
|
Create a Replicat Process |
|
|
480 | (1) |
|
|
|
480 | (1) |
|
|
|
481 | (1) |
|
Start the OGG Adapter for Hive |
|
|
481 | (1) |
|
|
|
481 | (2) |
|
Oracle GoldenGate Adapter for HBase |
|
|
483 | (1) |
|
|
|
484 | (3) |
|
Download and Install Maven |
|
|
484 | (1) |
|
|
|
484 | (1) |
|
Build the OGG Adapter for HBase |
|
|
484 | (2) |
|
Configure the OGG Adapter for HBase |
|
|
486 | (1) |
|
|
|
487 | (1) |
|
Create the Replicat Process |
|
|
488 | (1) |
|
Start the OGG Adapter for HBase |
|
|
488 | (1) |
|
|
|
488 | (2) |
|
|
|
490 | (1) |
|
Chapter 20 Oracle GoldenGate for Non-Oracle Databases |
|
|
491 | (16) |
|
OGG for Sybase to Sybase Replication |
|
|
491 | (3) |
|
OGG for Sybase to Oracle Replication |
|
|
494 | (2) |
|
OGG for MySQL to MySQL Replication |
|
|
496 | (3) |
|
OGG for Oracle to MySQL Replication |
|
|
499 | (2) |
|
OGG for DB2 to Oracle Replication |
|
|
501 | (3) |
|
OGG for MS SQL Server to Oracle Replication |
|
|
504 | (2) |
|
|
|
506 | (1) |
|
Chapter 21 Oracle GoldenGate for the Cloud |
|
|
507 | |
|
|
|
507 | (2) |
|
|
|
509 | (1) |
|
|
|
510 | (17) |
|
Create the Oracle Cloud Account |
|
|
510 | (5) |
|
|
|
515 | (1) |
|
Create the Oracle Database Cloud - DBaaS Instance |
|
|
516 | (9) |
|
|
|
525 | (2) |
|
|
|
527 | (2) |
|
Creating the SOCKS5 Proxy on the Local Server |
|
|
527 | (1) |
|
Creating the SOCKS5 Proxy on a DMZ Server |
|
|
528 | (1) |
|
Replication Configurations Using GGCS |
|
|
529 | (3) |
|
On-Premise to Cloud Replication |
|
|
529 | (1) |
|
Cloud to Cloud Replication |
|
|
530 | (1) |
|
Cloud to On-Premise Replication |
|
|
531 | (1) |
|
Support for a Non-Oracle Cloud |
|
|
532 | (3) |
|
|
|
535 | |