SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK PRO ORACLE GOLDENGATE FOR THE DBA
SUMMARY
-
Items Found: 201
- Chapter 1: Installation, Upgrade, and Removal 1
- Selecting the Correct Version 1
- Installing Oracle GoldenGate 12c 3
- Creating Subdirectories 8
- Viewing Inventory File Information 8
- Upgrading Oracle GoldenGate 9
- Removing Oracle GoldenGate 13
- Oracle Universal Installer Deinstall Option 14
- Hacking the oraInventory File 14
- Summary 15
- Chapter 2: Architecture 17
- Architectures 17
- Unidirectional Replication 17
- Bidirectional (Active-Active) Replication 18
- Real-Time Data Warehousing 18
- Real-Time Data Distribution 19
- Data Distribution via Messaging 20
- Understanding System Change Numbers 21
- Finding the System Change Number in Oracle 21
- GoldenGate Processes 22
- Manager Process 22
- Collector Process 23
- Capture Process 23
- Data Pump Process 25
- Delivery Process 26
- Trail Files 28
- Summary 28
- Chapter 3: Basic Replication Confi guration 29
- Profi ler 29
- Run Profi ler 29
- Parameter Files 31
- Extract Parameter File 32
- Data Pump Parameter File 32
- Replicat Parameter File 33
- Manager Parameter File 34
- Trail Files 34
- Sizing and Retention of Trail Files 35
- Obey Files 35
- Unidirectional Confi guration 36
- Prerequisites 36
- Create a GoldenGate User 40
- Granting Permissions to GoldenGate Users 40
- Building Source GoldenGate Environment 42
- Adding SCHEMATRANDATA or TRANDATA 43
- Edit Parameter Files 45
- Starting the Extract 47
- Extract (Data Pump) Process 48
- Instantiation 50
- Apply (Replicat) Process 51
- Adding the Apply (Replicat) Process 52
- Starting the Apply (Replicat) Process 53
- Summary 54
- Chapter 4: Tuning Oracle GoldenGate 55
- Different Types of Tuning 55
- Classic Process Tuning 56
- Tools for Tuning 57
- Tuning the Classic Processes 61
- Considerations When Using Multiple Process Groups 62
- Using Parallel Replicat Groups on the Target System 63
- Adding New Trails from the Extract 63
- Network Tuning 66
- Detecting Any Network Bottlenecks 66
- Workaround for Bandwidth Issues 67
- Compressing Data for Bandwidth Reduction 67
- Increasing the TCP/IP Packet Sizes 68
- Eliminating Disk I/O Bottlenecks 69
- Improving I/O Performance by System Confi guration 69
- Improving I/O Performance Within Oracle GoldenGate 70
- Managing Virtual Memory and Paging 70
- Applying Similar SQL Statements (Using Arrays) 71
- Full Table Scan Due to Absence of Keys 71
- Tuning Integrated Processes 71
- Tuning Tools for Integrated Processes 73
- Automatic Workload Repository Output 73
- Streams Performance Advisor 75
- x
- Database Performance Views 76
- Health Checks 77
- Summary 77
- Chapter 5: Monitoring Oracle GoldenGate 79
- Logs 79
- GoldenGate Service Error Log 79
- Process Reports 80
- Discard File 80
- Maintenance of Process Reports and Discard Files 81
- Monitoring Within Oracle GoldenGate 81
- INFO ALL Command 81
- STATS Command 82
- STATUS Command 83
- SEND Command 83
- LAG Command 85
- Scripting Oracle GoldenGate 86
- Graphical Tools for Monitoring 89
- GoldenGate Management Agent 89
- Oracle Enterprise Manager 90
- Summary 100
- Chapter 6: Data Verifi cation 101
- Obtain Software 102
- Oracle Fusion Middleware Infrastructure 102
- Oracle Java JDK 8 102
- Oracle GoldenGate Veridata Server 12c/Veridata Agent 12c 102
- WebLogic and Veridata Server Basic Requirements 102
- Example for an In-Memory Sort 103
- Veridata Agent Basic Requirements 103
- Preparing the Linux Operating System for WebLogic Infrastructure 104
- xi
- Creating WebLogic User and Groups 104
- Creating WebLogic Directory Structure 104
- Install the JDK for WebLogic Infrastructure 105
- Set Up Environment Variables for WebLogic Infrastructure 105
- Install WebLogic Infrastructure 106
- Installing Oracle Veridata Server 115
- Confi guration of the Oracle GoldenGate Veridata Repository Schema 124
- Confi guring the Domain for Oracle GoldenGate Veridata Server 134
- Installing the Oracle GoldenGate Veridata Agents 152
- Install the JDK for Oracle GoldenGate Veridata Agent 152
- Installing the Oracle GoldenGate Veridata Agent 153
- Deploying and Starting the Oracle GoldenGate Veridata Agent 161
- Starting the Veridata Application Server 162
- Confi gure Veridata Data Validation Connections 170
- Create Data Validation Job Group 172
- Create Data Validation Job 175
- Execute Veridata Data Validation 177
- Reviewing Data Verifi cation Job Results 178
- Executing Data Validation Repair 180
- Alternative Methods of Data Comparison 181
- Summary 186
- Chapter 7: Advanced Features 187
- Macros 187
- Creating a Macro 187
- Executing a Macro 188
- Tokens 190
- Defi ning Tokens 190
- Running Tokens 190
- Applying Tokens 192
- Heartbeat 193
- Traditional Heartbeat 193
- Integrated Heartbeat 203
- Functions 207
- IF Function 208
- Summary 209
- Chapter 8: Security 211
- User Security 211
- Encrypting the User Password 212
- Credential Stores 214
- GGSCI Command Security 215
- Summary 215
- Chapter 9: Data Integration 217
- Using Oracle GoldenGate to Create Flat Files 217
- Types of Flat Files 217
- Generating Flat Files 218
- Use Oracle GoldenGate to Create Native Database Loader Files 221
- Extract for Database Utility Usage 221
- Oracle GoldenGate User Exits 222
- Testing Data with Oracle GoldenGate 222
- Changing Data Using IF 224
- Summary 224
- Chapter 10: GoldenGate Utilities 225
- Oracle GoldenGate Error 225
- Logdump 226
- Accessing Trail File Data 229
- Defi nition Generator 233
- Confi gure Defgen 233
- Running Defgen 234
- Check Parameters 236
- Using Checkprm 236
- ConvChk 238
- Key Generator 238
- Summary 239
- Chapter 11: GoldenGate Studio and Oracle GoldenGate Monitor Agent 241
- Downloading Oracle GoldenGate Studio 241
- Installing Oracle GoldenGate Studio 242
- Confi guring Studio Repository 248
- Starting Oracle GoldenGate Studio 255
- Connecting to the Repository 257
- Disconnecting from the Repository 259
- Oracle GoldenGate Monitor Agent 259
- Installing Oracle GoldenGate Monitor Agent 260
- Confi gure Oracle GoldenGate Monitor Agent 265
- Create OGG Agent Instance 265
- Update the Agent Confi guration 266
- Assign Password to Agent Instance 266
- Enable Monitoring for GoldenGate 267
- Summary 268
- Chapter 12: Working with Oracle GoldenGate Studio 269
- Create Resources 270
- Defi ning a Database Resource 271
- Defi ning GoldenGate Instance Resource 273
- Create a Project 275
- Creating a Solution 278
- Creating a Mapping 282
- Different Types of Mappings 283
- Establishing Mappings 288
- xiv
- Assigning Mappings 291
- Creating Deployment Profi les 293
- Online Deployment 293
- Making Changes 298
- Offl ine Deployment 299
- Summary 301
- Index 303
