Sumário Itens Encontrados: 591AcknowledgmentsChapter 1: IntroductionDistributed Processing and ReplicationOracle Basic ReplicationOracle Advanced ReplicationOracle Streams ReplicationEvolution and Oracle GoldenGateChapter 2: InstallationDownloading the SoftwareDownloading from Oracle E-DeliveryDownloading from OTNUnderstanding Your EnvironmentReviewing the Install InstructionsInstalling GoldengateGeneral System RequirementsMemory RequirementsDisk Space RequirementsNetwork RequirementsOperating System RequirementsRequirements for Microsoft Windows Clustered EnvironmentsInstalling Goldengate on WindowsInstalling GoldenGate 11g on Linux and UNIXEnvironment Settings for Oracle and Goldengate on Linux and UNIXGoldenGate and Oracle RAC ConsiderationsInstalling Goldengate for Microsoft SQL Server on WindowsInstalling Goldengate for Teradata on Windows and UNIXInstalling Goldengate for Sybase on Windows and UNIXInstalling GoldenGate for IBM DB2 UDB on Windows and UNIXInstalling Oracle GoldenGate Director 11gSystem RequirementsInstalling Oracle GoldenGate Director ServerGrant Database Privileges and Credentials to Oracle GoldenGate Director Server SchemaInstall Oracle GoldenGate DirectorInstalling Oracle GoldenGate VeridataGoldenGate Veridata Agent System RequirementsGoldenGate Veridata Agent Disk RequirementsGoldenGate Veridata Agent Memory RequirementsGoldenGate Veridata Agent Database PrivilegesGoldenGate Veridata Server System RequirementsInstall Oracle Goldengate VeridataChapter 3: ArchitectureTypical GoldenGate FlowGoldenGate ComponentsSource DatabaseCapture (Local Extract) ProcessSource TrailData PumpNetworkCollectorRemote TrailDelivery (Replicat).Target DatabaseManagerTopologies and Use CasesOne-Way ReplicationBidirectional ReplicationBroadcast ReplicationIntegration ReplicationTools and UtilitiesGGSCIDEFGENLogdump.ReverseVeridataDirectorChapter 4: Basic ReplicationOverviewPrerequisites for Setting Up ReplicationRequirementsOne-Way Replication TopologyBasic Replication StepsStarting the ExtractVerifying Database-Level Supplemental LoggingEnabling Database-Level Supplemental LoggingEnabling Table-Level Supplemental LoggingDisabling Triggers and Cascade-Delete ConstraintsVerifying the Manager StatusConfiguring the Local ExtractAdding the ExtractStarting and Stopping the ExtractVerifying the ExtractStarting the Data PumpConfiguring the Data PumpAdding the Data PumpStarting and Stopping the Data PumpVerifying the Data PumpLoading with GoldenGatePrerequisites for the GoldenGate Initial LoadConfiguring the Initial-Load ExtractAdding the Initial-Load ExtractConfiguring the Initial-Load ReplicatAdding the Initial-Load ReplicatStarting the GoldenGate Initial LoadVerifying the Initial LoadLoading with DBMS UtilitiesPrerequisites for Loading with DBMS UtilitiesSteps for Loading with DBMS UtilitiesStarting the ReplicatConfiguring the ReplicatAdding the ReplicatStarting and Stopping the ReplicatVerifying the ReplicatChapter 5: Advanced FeaturesEnhancing the Replication ConfigurationEnhancing Extract and Replicat ReportingReporting Discarded RecordsPurging Old Trail FilesAdding Automatic Process Startup and RestartAdding a Checkpoint TableMaking the Replication More SecureEncrypting PasswordsEncrypting the Trail FilesAdding Data Filtering and MappingFiltering TablesFiltering Columns.Filtering RowsMapping ColumnsTransforming ColumnsOracle-Specific DBMS Configuration OptionsConfiguring for Oracle RACConfiguring for Oracle ASMAdding Oracle DDL ReplicationAdding Bidirectional ReplicationExcluding Transactions for Bidirectional ReplicationHandling Conflict Resolution for Bidirectional ReplicationChapter 6: Heterogeneous ReplicationMicrosoft SQL Server to Oracle ReplicationPreparing the Oracle GoldenGate EnvironmentsInitial Data Load Completion for Oracle GoldenGate EnvironmentsSource Oracle Database ConfigurationTarget Microsoft SQL Server Database ConfigurationCreating Sample Microsoft SQL Server DatabaseConfigure Change Data Capture on SourceVerifying Operational ReadinessChapter 7: TuningTuning MethodologyDefining the Performance Requirements.Creating a Performance BaselineEvaluating the Current PerformanceDetermining the ProblemDesigning and Implementing a SolutionUsing Parallel Extracts and ReplicatsImplementing Parallel Extracts and Replicats with Table FilteringImplementing Parallel Extracts and Replicats Using Key RangesUsing BATCHSQLUsing GROUPTRANSOPSTuning Disk StorageTuning the NetworkTuning the RMTHOST ParameterTuning the DatabaseChapter 8: Monitoring Oracle GoldenGateDesigning a Monitoring StrategyWhy Monitoring the Extract Is ImportantGetting the Maximum ThresholdWhich Processes to Monitor in the GoldenGate EnvironmentMonitoring All Running ProcessesMonitoring the Detail ExtractChecking the Current Oracle Online Redo LogChecking the Archived LogMonitoring the GoldenGate Rate and Redo Log Consumption RateMonitoring Lags for Each GroupViewing Event and Error LogsAutomating MonitoringChecking GoldenGate Process ScriptsMonitoring Lag ScriptsChecking Memory and CPU ScriptsChecking Disk SpaceChapter 9: Oracle GoldenGate VeridataVeridata ComponentsGoldenGate Veridata ServerGoldenGate Veridata WebGoldenGate Veridata RepositoryGoldenGate Veridata Agent,Java,and C-CodeGoldenGate Veridata CLI (Vericom)How Veridata Comparison WorksHow Veridata Can Help YouSetting Up the Veridata ComparesCreating Database ConnectionsSetting Up Tables and Data Scripts.Creating a GroupCreating Compare PairsCreating a JobCreating a ProfileRunning the Veridata JobImproving Performance and Reducing OverheadExcluding ColumnsTuning Profiles SettingsDisabling the Confirm Out of Sync StepIncreasing the Number of ThreadsCompares MethodsRight Trim on Character FieldsComparing Incremental Data for Large TablesComparing GoldenGate Real-Time Replication DataComparing Different Column Types and Compare FormatsUsing Performance StatisticsUsing Vericom Command LineSetting Up Role-Based SecurityChapter 10: GoldenGate DirectorDirector ComponentsGoldenGate GGSCI InstancesDirector AdministratorDirector Server and DatabaseDirector WebDirector ClientSetting Up the Data SourceModifying the Manager Parameter fileModifying the Parameter File Using the Built-in EditorModifying the Parameter File Using the GUISetting Up the Initial LoadAdding an Initial Load TaskCreating a One-Way ReplicationAdding a Data Pump ProcessAdditional Director Features and TricksAlter Extract or Replicat RUN OptionsChanging the Trail-File SizeExtracting TranlogoptionsGenerating Definition FilesFinding Parameters or Attributes in DirectorAdvanced MappingAlertsChapter 11: Troubleshooting Oracle GoldenGateCommon Problems and SolutionsOracle GoldenGate Process FailuresOracle GoldenGate Extract Process FailuresOracle GoldenGate Process Failures Without Report DiagnosticsOracle GoldenGate Trail File ProblemsTrail Files that Donât EmptyTrail Files that Donât Roll Over Trail File Purging IssuesTrail Files that Purge Too SoonOracle GoldenGate Error Log AnalysisUnderstanding the Oracle GoldenGate Discard FileDiscard File Not CreatedDiscard File Is Too BigCanât Open the Discard FileUsing Trace Commands with Oracle GoldenGateOracle GoldenGate Process Tracing with TLTRACEUsing TRACE Parameters with Oracle GoldenGateTroubleshooting Case Study with Oracle GoldenGateOracle GoldenGate Configuration IssuesIncorrect Software Versions with Oracle GoldenGateDatabase Availability IssuesMissing Oracle GoldenGate Process GroupsMissing Oracle GoldenGate Trail FilesOracle GoldenGate Parameter File Configuration IssuesOperating System Configuration Issues with Oracle GoldenGateNetwork Configuration Issues with Oracle GoldenGateNetwork Data-Transfer IssuesOracle Database Issues with GoldenGateExtract Canât Access Oracle Database Archive and Redo LogsExtract Failure Conditions Due to Oracle Source Database IssuesData-Pump ErrorsReplicat Errors on the Oracle Database Target SystemReplicat Hangs on the Target SystemReplicat Experiences an Abend Failure on the Target SystemReplicat Fails on Large TransactionsIncompatible Record Errors with a Replicat Data-Synchronization IssuesTables Missing Key ConstraintsCharacter Set Configuration IssuesMissing-Column ErrorsFetch FailuresChapter 12: Disaster Recovery ReplicationPrerequisitesDisaster Recovery Replication TopologySetupConfiguring the Local Extract for Disaster RecoveryConfiguring the Data Pump for Disaster RecoveryConfiguring the Replicat for Disaster RecoveryConfiguring the Standby ExtractConfiguring the Standby Data PumpConfiguring the Standby ReplicatPerforming a Planned SwitchoverPerforming an Unplanned FailoverChapter 13: Zero-Downtime Migration ReplicationZero-Downtime Migration TopologyConfiguring the Local Extract for Zero-Downtime MigrationConfiguring the Data Pump for Zero-Downtime Migration Configuring the Replicat for Zero-Downtime MigrationConfiguring the Fallback Local Extract for Zero-Downtime MigrationConfiguring the Fallback Data-Pump for Zero-Downtime MigrationConfiguring the Fallback Replicat for Zero-Downtime MigrationPerforming the Migration CutoverPerforming the Migration FallbackChapter 14: Tips and TricksRequirements and PlanningKnowing the Business Objectives.Understanding the RequirementsDetermining the TopologyInstallation and SetupCreating Dedicated UsersCreating a Dedicated Installation DirectoryUsing a Checkpoint TableVerifying the Character SetsDeveloping Naming StandardsUsing a Data PumpManagement and MonitoringUsing GGSCI Command ShortcutsUsing OBEY FilesGenerating Interim StatisticsUsing a Discard FileReporting Regularly on Process HealthPurging Old Trail Files RegularlyAutomatically Starting ProcessesPerformanceRunning Performance TestsLimiting the Number of ExtractsUsing Passthru Mode for Data PumpsUsing Parallel ReplicatsUsing the Fastest Available StorageAppendix: Additional Technical Resources for theOracle GoldenGate AdministratorReferences for Further ReadingQuick Guide to Oracle GoldenGate CommandsADDHELPINFOSENDSTATUSLogdump Commands and Syntax for TroubleshootingAccessing the Logdump UtilityGetting Help with Logdump SyntaxHISTORY.Opening GoldenGate Trail Files with LogdumpChapter 1: What Is Exadata?.An Overview of ExadataHistory of ExadataAlternative Views of What Exadata IsData Warehouse ApplianceOLTP MachineConsolidation PlatformConfiguration OptionsExadata Database Machine X2-2.Exadata Database Machine X2-8.Hardware ComponentsOperating SystemsDatabase ServersStorage Servers.InfiniBandFlash CacheDisks.Bits and PiecesSoftware ComponentsDatabase Server SoftwareStorage Server SoftwareSoftware Architecture.Chapter 2: Offloading / Smart ScanWhy Offloading Is ImportantWhat Offloading IncludesColumn ProjectionPredicate FilteringStorage Indexes.Simple Joins (Bloom Filters)Function OffloadingCompression/Decompression.Encryption/DecryptionVirtual ColumnsData Mining Model ScoringNon-Smart Scan Offloading.Smart Scan PrerequisitesFull ScansDirect Path ReadsExadata StorageSmart Scan DisablersSimply UnavailableReverting to Block ShippingSkipping Some OffloadingHow to Verify That Smart Scan is Happening10046 Trace.Performance Statistics (v$sessstat)Offload Eligible BytesSQL MonitoringParametersChapter 3: Hybrid Columnar CompressionOracle Storage ReviewOracle Compression MechanismsBASIC.OLTPHCC.HCC Mechanics.HCC Performance.Load PerformanceQuery Performance.DML Performance.Expected Compression RatiosCompression Advisor.Real World Examples.Restrictions/Challenges.Moving Data to a non-Exadata Platform.Disabling Serial Direct Path ReadsLocking IssuesSingle Row AccessCommon Usage ScenariosChapter 4: Storage IndexesStructure.Monitoring Storage IndexesDatabase Statistics.Tracing.Monitoring Wrap UpControlling Storage Indexes._kcfis_storageidx_disabled_kcfis_storageidx_diag_mode._cell_storidx_modeStorage Software ParametersBehaviorSpecial Optimization for NullsPhysical Distribution of ValuesPotential IssuesIncorrect ResultsMoving Target.Partition SizeIncompatible Coding TechniquesChapter 5: Exadata Smart Flash CacheHardwareCache vs. Flash DiskUsing Flash Memory as CacheHow ESFC is CreatedControlling ESFC UsageMonitoringAt the Storage LayerAt the Database LayerChapter 6: Exadata Parallel OperationsParallelization at the Storage TierAuto DOPOperation and Configuration.I/O Calibration.Auto DOP Wrap UpParallel Statement QueuingThe Old Way.The New Way.Controlling Parallel QueuingParallel Statement Queuing Wrap UpIn-Memory Parallel ExecutionChapter 7: Resource ManagementDatabase Resource Manager.Consumer GroupsPlan Directives.Resource Plan.Resource Manager ViewsThe Wait Event: resmgr: cpu quantumDBRM ExampleTesting a Resource Plan.Instance CagingConfiguring and Testing Instance Caging.Over-ProvisioningI/O Resource ManagerHow IORM WorksMethods for Managing I/O on ExadataBringing It All TogetherIORM Monitoring and MetricsChapter 8: Configuring ExadataExadata Network ComponentsThe Management NetworkThe Client Access Network.The Private NetworkAbout the Configuration ProcessConfiguring Exadata.Step 1: The Configuration Worksheet.Step 2: The DBM ConfiguratorStep 3: Upload Parameter and Deployment FilesStep 4: CheckIP (checkip.sh)Step 5: FirstbootStep 6: Staging the Installation MediaStep 7: Running OneCommandUpgrading Exadata.Creating a New RAC ClusterUpgrading the Existing ClusterChapter 9: Recovering Exadata.Exadata Diagnostic ToolsSun Diagnostics: sundiag.shHealthCheckCellCLI.Backing Up ExadataBacking Up the Database ServersBacking Up the Storage CellBacking Up the Database.Disk-Based Backups.Tape-Based Backups.Backup from Standby DatabaseExadata Optimizations for RMAN.Recovering ExadataRestoring the Database Server.Recovering the Storage CellChapter 10: Exadata Wait Events.Events Specific to ExadataThe âcellâ Events.Plan Steps That Trigger EventsExadata Wait Events in the User I/O Class.cell smart table scancell smart index scancell single block physical readcell multiblock physical read.cell list of blocks physical readcell smart file creationcell statistics gatherExadata Wait Events in the System I/O Classcell smart incremental backup.cell smart restore from backupExadata Wait Events in the Other and Idle Classescell smart flash unkeepOld Eventsdirect path readenq: KOâfast object checkpointreliable messageResource Manager Events.resmgr:cpu quantumresmgr:pq queuedChapter 11: Understanding Exadata Performance Metrics.Measuring Exadataâs Performance Metrics.Revisiting the Prerequisites for Exadata Smart ScansExadata Smart Scan PerformanceUnderstanding Exadata Smart Scan Metrics and Performance CountersExadata Dynamic Performance CountersWhen and How to Use Performance CountersThe Meaning and Explanation of Exadata Performance Counters.Exadata Performance Counter ReferenceUnderstanding SQL Statement PerformanceChapter 12: Monitoring Exadata PerformanceA Systematic Approach.Monitoring SQL Statement Response TimeMonitoring SQL Statements with Real-Time SQL Monitoring Reports.Monitoring SQL Statements using V$SQL and V$SQLSTATSMonitoring the Storage Cell LayerAccessing Cell Metrics in the Cell Layer Using CellCLIAccessing Cell Metrics Using the Grid Control Exadata Storage Server Plug-InWhich Cell Metrics to Use?Monitoring Exadata Storage Cell OS-level MetricsChapter 13: Migrating to ExadataMigration StrategiesLogical MigrationExtract and LoadCopying Data over a Database Link.Replication-Based MigrationLogical Migration Wrap UpPhysical MigrationBackup and RestoreFull Backup and Restore.Incremental BackupTransportable Tablespaces (and XTTS)Physical StandbyASM RebalancePost-Migration TasksWrap Up Physical Migration SectionChapter 14: Storage LayoutExadata Disk ArchitectureFailure GroupsGrid DisksStorage AllocationCreating Grid DisksCreating Grid Disks.Grid Disk SizingCreating FlashDisk-Based Grid DisksStorage StrategiesIsolating Storage Cell AccessCell Security.Cell Security Terminology.Cell Security Best PracticesConfiguring ASM-Scoped SecurityConfiguring Database-Scoped SecurityRemoving Cell SecurityChapter 15: Compute Node LayoutProvisioning ConsiderationsNon-RAC Configuration.RAC ClustersTypical Exadata ConfigurationExadata ClustersChapter 16: Unlearning Some Things We Thought We Knew.A Tale of Two SystemsOLTP-Oriented Workloads.Exadata Smart Flash Cache (ESFC)ScalabilityWrite-Intensive OLTP WorkloadsDW-Oriented WorkloadsEnabling Smart ScansThings that Can Cripple Smart Scans.Other Things to Keep in MindMixed WorkloadsTo Index or Not to Index?.The Optimizer Doesnât KnowUsing Resource ManagerAppendix A: CellCLI and dcliCellCLI Command SyntaxGetting Familiar with CellCLISending Commands from the Operating SystemConfiguring and Managing the Storage Cell.dcli Command Syntax.Appendix B: Online Exadata ResourcesExadata MOS Support Notes.Helpful Exadata MOS Support NotesExadata Bulletins and BlogsAppendix C: Diagnostic Scripts