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