Sumário Itens Encontrados: 485ontents at a GlanceAbout the AuthorAbout the Technical ReviewerAcknowledgmentsIntroductionPart I: Getting StartedChapter 1: Introduction to Oracle GoldenGate (OGG)Chapter 2: ArchitectureChapter 3: Oracle GoldenGate Pre-installation TasksChapter 4: Installing Oracle GoldenGateChapter 5: Classic vs Integrated Capture and ApplyChapter 6: Capturing DDL ChangesChapter 7: Performing the Initial LoadPart II: Advanced Confi gurationsChapter 8: Oracle GoldenGate CommandsChapter 9: Advanced ProcessingChapter 10: Advanced FeaturesChapter 11: Upgrading Oracle GoldenGateChapter 12: Bidirectional ReplicationPart III: Managing Oracle GoldenGateChapter 13: Oracle GoldenGate Management Pack Part IChapter 14: Oracle GoldenGate Management Pack Part IIChapter 15: Ensuring Data Integrity with VeridataChapter 16: Troubleshooting Oracle GoldenGateChapter 17: Using Oracle GoldenGate AdaptersPart IV: Exploring GoldenGate PossibilitiesChapter 18: Confi guring Oracle GoldenGate HAChapter 19: Oracle GoldenGate for Big DataChapter 20: Oracle GoldenGate for Non-Oracle DatabasesChapter 21: Oracle GoldenGate for the CloudChapter 22: Oracle GoldenGate StudioChapter 23: Undoing Data ChangesPart V: AppendixesChapter 24: Appendix A: OGG Heartbeat and CheckpointsChapter 25: Appendix B: Preparing for InterviewsChapter 26: Appendix C: Get Certifi edWhatâs So Magical About Oracle GoldenGate?Types of ReplicationAvailable Replication OptionsAdvantages of Oracle GoldenGateWhen to Use Oracle GoldenGate?Oracle GoldenGate vs StreamsOracle GoldenGate vs Data GuardOracle GoldenGate vs SharePlexOracle GoldenGate 12c New FeaturesSummaryOverview of the ComponentsExtractData PumpReplicatTrailsCollectorManagerCheckpointsSupport for Non-Oracle DatabasesSupported TopologiesUnidirectional ReplicationBidirectional ReplicationOne-to-Many ReplicationMany-to-One ReplicationPeer-to-Peer ReplicationMemory RequirementsDisk Space RequirementsNetwork RequirementsConfi guring Your Database and Server for Oracle GoldenGateEnable Logging for Oracle DatabasesEnable Logging for Sybase DatabasesEnable Logging for Microsoft SQL Server DatabasesSupported Data TypesSupported Data Types for Oracle DatabasesSupported Data Types for SYBASE DatabasesSupported Data Types for MySQL DatabasesSupported Data Types for SQL Server DatabasesSupported Data Types for DB2 Databases on LUWSupported Data Types for DB2 Databases on z/OSSupported OperationsDatabase Operations Captured for Oracle DatabasesDatabase Operations Captured on Sybase DatabasesDatabase Operations Captured on MySQL DatabasesDatabase Operations Captured on SQL Server DatabasesDatabase Operations Captured on DB2 Databases for LUWDatabase Operations Captured on Sybase Databases for z/OSDesigning Your GoldenGate Replication SetupWhy Choose Standard Naming Conventions?Naming Capture and Delivery ProcessKnow Your ApplicationDatabase Privileges for GoldenGate UsersOGG User Permissions in Oracle DatabasesOGG User Permissions in Sybase DatabasesOGG User Permissions in IBM DB2 DatabasesOGG User Permissions in MySQL DatabasesOGG User Permissions in Teradata DatabasesDownload the InstallerSetting Up Environmental VariablesSetting Up Database LoggingSetting Up User PrivilegesInstalling Oracle GoldenGate on Unix/LinuxStep 1: Log In as the Linux SuperuserStep 2: Navigate to the GoldenGate DirectoryStep 3: Copy or FTP the GoldenGate Software File from the Local System or Remote ServerStep 4: Locate the InstallerStep 5: Begin InstallationStep 6: Execute GGSCIStep 7: Create SubdirectoriesStep 8: Confi gure the Manager PortStep 9: Start/Stop the ManagerStep 10: Check Supplemental Logging for the Database Step 11: Add ExtractsStep 12: Install Oracle GoldenGate on the Target MachineStep 13: Add the ReplicatStep 14: Create the Defi nition FileStep 15: Enable Supplemental Logging for Oracle GoldenGateStep 16: Initial Data SynchronizationStep 17: Start the Manager,Extract,and Replicat,and Test the ResultSilent InstallationParameters in the Response FileOGG SubdirectoriesHandling Character SetUsing CHARSETUsing Escape SequencesUsing SOURCECHARSETUsing NLS_LANGOGG Capture ProcessClassic CaptureIntegrated CaptureIntegrated Capture ModesOGG Apply ProcessNonintegrated ApplyIntegrated ApplySupport for Multitenant DatabasesImplementing Classic and Integrated CapturesCreating a Classic CaptureCreating an On-Source Integrated CaptureCreating an Integrated Capture Using a Downstream Mining Database Monitoring an Integrated CaptureUpgrading Classic Capture Mode to Integrated Capture ModeUpgrading to an Integrated CaptureImplementing Classic and Integrated ApplyCreating a Classic ApplyCreating an Integrated ApplyCapture and Apply Modes,Mix and MatchCoordinated ReplicatWhat Is DDL Replication?Types of DDL ReplicationLimitations with DDL ReplicationDDL ScopeHow Does DDL Replication Work?On the Source MachineOn the Target MachineDDL Capture in Classic Capture ModeAn Example of Classic Capture DDLDDL Capture in Integrated Capture ModeSelective DDL Replication with an Oracle Source DBSelective DDL Replication Using DDLAUXaddRule()Selective DDL Replication Using the DDL ParameterUsing DUMPDDLDDL Replication in Active-Active Mode (Bidirectional Replication)DDL Replication in a Cascading Replication Setup DDL Replication in a Heterogeneous EnvironmentPreparing for the Initial LoadInitial Load Using the Database UtilityInitial Load Using SQLLOADERInitial Load Using the Direct Load MethodInitial Load Using BULKLOAD to sqlloaderInitial Load ExampleData Transformation Using Column Conversion FunctionsGGSCI CommandsNative Non-GGSCI Commands and UtilitiesDEFGENKEYGENLOGDUMPData Transformation in Oracle GoldenGateData Filter MethodsData Transformation MethodsUsing COLMAP for Column MappingData Transformation ExamplesUsing COLMATCHOGG User Tokens User ExitsSQLEXECUsing SQLEXEC as a Parameter to a TABLE or MAP StatementUsing SQLEXEC to Run Stored ProceduresUsing SQLEXEC to Run as a Stand-Alone ParameterMacros in Oracle GoldenGateOracle GoldenGate AuditingCollision HandlingHANDLECOLLISIONCDR for Active-Active ReplicationSupported Data Types for CDRTypes of Confl ictsConfl icts During an INSERT OperationConfl icts During an UPDATE OperationConfl icts During a DELETE OperationCDR ParametersCDR ExampleOracle GoldenGate Performance TuningBest Practices for Confi guring Your Oracle GoldenGate Replication EnvironmentDetermining the Current Performance StatisticsConfi gure Your DatabaseEnable Supplemental LoggingPASSTHRU or NOPASSTHRUTuning TCPBUFSIZE and TCPFLUSHBYTESBatch TransactionsUse Compression Streams Pool for Integrated Extract and ReplicatRANGE SplittingEncryption and SecurityEncrypting Database PasswordsGenerating a Custom Encryption KeyWallet and a Master KeySteps for Creating a Wallet and Master KeyRenew the Master KeyEncrypt and Decrypt Trail FilesEncrypt Data Sent Over a NetworkUsing an Oracle GoldenGate Credential StoreDownload the PatchInstall the PatchPre-upgrade TasksUpgrading Oracle GoldenGate on the SourceTake a BackupInstall the New Version of GoldenGateConvert Supplemental Log Group VersionVerify the UpgradeUpgrading Oracle GoldenGate on the TargetUpgrade the Checkpoint TablePost-upgrade TasksStart GoldenGate and Monitor ReplicationKey Points Before Setting Up OGG Bidirectional ReplicationHandling Data LoopbacksHandling Data Loopbacks in Oracle DatabasesHandling Data Loopbacks in All Supported DatabasesHandling Data Loopbacks in Teradata DatabasesHandling Data Loopbacks by Identifying Replicat TransactionsCDR in Bidirectional ReplicationSetting Up OGG Bidirectional ReplicationAdding Confl ict Detection and ResolutionCDR When Machine A is a Trusted Source and Always WinsCDR When Both Sites Are Equally TrustedDBFS Confi guration for OGG Bidirectional ReplicationStep 1: Install the Patch for bug-9651229Step 2: Confi gure DBFS SequencesStep 3: Create the New DBFS File Systems for OGG ReplicationStep 4: Confi gure the Extract/Replicat ProcessesOracle GoldenGate MonitorInstallation OverviewInstall Oracle WebLogic ServerInstall the Oracle GoldenGate Monitor ServerSystem RequirementsDownload the SoftwareInstallationCreate the OGG Monitor Repository Using RCUCreate the WebLogic Server Domain Using the Confi guration Wizard Confi gure the OGG Monitor ServerConfi gure the JMX Server PropertiesSMTP,SNMP,and CLI Alert PropertiesStart the OGG Monitor ServerStart the OGG Monitor ConsoleInstall the Oracle GoldenGate Monitor AgentCreate the OGG Monitor Agent InstancesConfi gure the OGG Monitor Agent InstancesConfi gure the OGG Monitor Agent for the OGG Monitor ServerConfi gure the OGG Monitor Agent When Using the OEM Plug-in for Oracle GoldenGateCreate a Wallet When Using the OGG MonitorCreate a Wallet When Using the OGG OEM Plug-InEnable MonitoringStart the OGG Monitor AgentOracle GoldenGate Enterprise Manager Plug-InInstalling the OGG Plug-in for EMDownloading the Plug-InDeploying the Plug-InCreating an Oracle WalletConfi guring the OGG Instance to Run with OEMStarting the OGG InstanceOracle GoldenGate DirectorOGG Director ServerOGG Director DatabaseOGG Director WebOGG Director ClientOGG Director Administrator Why Use the OGG Director?Installing the OGG Director ServerDownloading the SoftwareInstalling the ServerUsing the GUI InstallerUsing Command-Line InstallationStart and Stop the OGG Director ServerInstalling the OGG Director ClientDownloading SoftwareInstalling the ClientStarting the OGG Director ClientStarting the OGG Director AdministratorAdding,Changing,and Deleting User AccountsAdding the OGG Data SourceConfi guring the OGG Monitor AgentViewing and Confi guring the Monitor SettingsStarting the OGG Director WebManaging Oracle GoldenGate Using Custom ScriptsMonitoring the Stopped Manager and Stopped/Abended Extract/Replicat ProcessesWhy Use OGG Veridata?How Does It Work?Installing the OGG Veridata ServerCreate the OGG Veridata Repository Using RCUCreate an Oracle WebLogic Domain for OGG VeridataStart Veridata Managed ServerInstall the OGG Veridata AgentDeploy the OGG Veridata AgentStart and Stop the Veridata AgentCreating and Running OGG Veridata Compare JobsUsing the Veridata CLIExecuting Vericom CommandsVericom Exit StatusRunning a Job Using VericomUninstalling OGG VeridataTypes of FailureWhere to Look for Errors?OGG Error Log FileOGG Process Report FileOGG Process Discard FileTroubleshooting Using the LOGDUMP UtilityTroubleshooting Using SHOWSYNTAXPerforming a Sanity CheckTroubleshooting Examples: Issues with the Extract ProcessesExtract Abended Due to Privilege IssueExtract Abended/Stopped Due to Disk Space FullExtract Abended Due to Network Communication ErrorExtract Abended Due to Memory Allocation ErrorExtract Abended Due to ORA-03135 Troubleshooting Examples: Issues with Replicat ProcessesReplicat Abended/Stopped Due to Missing Checkpoint TableReplicat Abended/Stopped Due to Corrupt Checkpoint Table or Missing Data in Checkpoint TableReplicat Abended Due to Table Structure or Data Inconsistency ErrorReplicat Abended Due to Error Processing DDL StatementReplicat Abended Due to Table Not Present in Target SchemaReplicat Abended Due to Discard File FullTroubleshooting Examples: Data Sync IssuesTroubleshooting Examples: DDL Capture IssueTroubleshooting Examples: Trail Files CorruptionCorrupt Trail on the SourceCorrupt Trail on the TargetUsing LOGDUMP to Point the Replicat to a Good RBAUsing SKIPTRANSACTIONError Handling in Oracle GoldenGateGenerating Flat Files in Real TimeOverview of TasksDownloading OGG Application AdaptersInstalling the OGG Application AdapterViewing the Sample FilesCreating the OGG User and RolePreparing the Database for Flat-File ExtractionAdding a Checkpoint TableGenerating the Table Defi nitionsCreating the Flat-File Adapter Properties FileCreating the Primary ExtractCreating the User Exit ExtractStarting the ExtractsVerifying Flat FilesFlat-File Adapter PropertiesTroubleshooting Your Flat-File Confi gurationOGG for JMS MessagingJMS DeliveryImplementation Overview for JMS DeliveryConfi guring the Primary and Data Pump Extracts on the Source Database ServerConfi guring Data Integration on the Target ServerJMS CaptureImplementation Overview for JMS CaptureConfi guring the VAM ExtractConfi guring the VAM Properties FileCreating a Defi nition File for JMS MessageConfi guring the Data Pump ExtractConfi guring the Replicat on the Target ServerHA Using Oracle ClusterwareOracle Clusterware for OGGVirtual IPSetting Up the Oracle ACFS File SystemInstalling Oracle GoldenGate HAConfi guring OGG HAStep 1: Create a Minimum of a Two-Node System with Oracle GoldenGateStep 2: Create a VIP for the Oracle GoldenGate ApplicationStep 3: Create the Agent ScriptStep 4: Add a Clusterware Resource for the Oracle GoldenGate ApplicationStep 5: Start the Resource Using Oracle ClusterwareStep 6: Manage the ApplicationStep 7: Test the FailoverDownloading Oracle GoldenGate for Big DataInstalling Oracle GoldenGate for Big DataRunning the OGG Java Adapter with the Replicat ProcessRunning the OGG Java Adapter with the Extract ProcessOracle GoldenGate Adapter for Apache FlumeFlume SourceFlume ChannelFlume SinkBuild the Flume AdapterDownload and Install MavenPre-checksBuild the OGG Adapter for FlumeConfi gure the OGG Adapter for FlumeSet Up FlumeCreate the Replicat ProcessStart the OGG Adapter for FlumeFlume Adapter PropertiesOracle GoldenGate Big Data Adapter for HDFSBuild the HDFS AdapterBuild the OGG Adapter for HDFSConfi gure the OGG Adapter for HDFSSet Up HDFSStart the OGG Adapter for HDFSHDFS Adapter PropertiesOracle GoldenGate Adapter for HiveBuild the Hive AdapterBuild the OGG Adapter for HiveConfi gure the OGG Adapter for HiveSet Up HiveCreate a Replicat ProcessCreate Tables in HiveQuery Hive for DataStart the OGG Adapter for HiveHive Adapter PropertiesOracle GoldenGate Adapter for HBaseBuild the HBase AdapterBuild the OGG Adapter for HBaseConfi gure the OGG Adapter for HBaseSet Up HBaseStart the OGG Adapter for HBaseHBase Adapter PropertiesOGG for Sybase to Sybase ReplicationOGG for Sybase to Oracle ReplicationOGG for MySQL to MySQL ReplicationOGG for Oracle to MySQL ReplicationOGG for DB2 to Oracle ReplicationOGG for MS SQL Server to Oracle ReplicationGGCS ArchitectureComponents of GGCSObtaining GGCSCreate the Oracle Cloud AccountCreate an SSH Key PairCreate the Oracle Database Cloud â DBaaS InstanceCreate a GGCS InstanceSOCKS5 ProxyCreating the SOCKS5 Proxy on the Local ServerCreating the SOCKS5 Proxy on a DMZ ServerReplication Confi gurations Using GGCSOn-Premise to Cloud ReplicationCloud to Cloud ReplicationCloud to On-Premise ReplicationSupport for a Non-Oracle CloudArchitectureInstall and Confi gure OGG StudioInstall the Oracle GoldenGate InstanceInstall the OGG Monitor AgentInstall Oracle GoldenGate StudioInstall the OGG Studio RepositoryLaunch OGG StudioSupported DatabasesLimitations of the OGG Reverse UtilityOracle DatabaseSybase DatabaseSQL ServerIBM DB2When Do You Need to Use the Oracle GoldenGate Reverse Utility?OGG Reverse Utility Steps OverviewSteps to Set Up a Heartbeat ProcessCreate UsersCreate TablesAdd Supplemental LoggingCreate a Job to Update the HEARTBEAT TableCheck the Job StatusConfi gure the ExtractConfi gure the Data PumpConfi gure the ReplicatAdditional ScriptsAdding the Heartbeat Table in Oracle GoldenGate 122OGG CheckpointsCheckpoint Storage LocationCreating the OGG Checkpoint TableTroubleshooting the Checkpoint TableThe BasicsAdvancedOracle GoldenGate 12cPerformance and SecurityTroubleshootingOracle GoldenGate GUI ToolsMiscellaneousSteps to Get Certifi edExam TopicsHow to Schedule an Exam?