OracleGoldenGate官方学习文档VIP免费

Oracle GoldenGate for Oracle to Oracle                                          Page 1 Oracle GoldenGate for Oracle to Oracle Objective Upon completion of this lesson, you will be able to keep two Oracle databases synchronized. During this lesson, you will:  Prepare the database and the Oracle GoldenGate environment.  Configure and execute the initial data load process  Configure and start the change capture of database operations.  Configure and start the change delivery process. Oracle to Oracle configuration The following diagram illustrates Oracle GoldenGate installed on two systems connected by TCP/IP – one containing the source data and the other the replicated data. Overview of tasks Prepare the Environment In order to execute this lesson, the GoldenGate application must be installed on both the source and target systems. The installation includes a sample database and scripts to generate initial data as well as subsequent update operations. The source and target tables are created serverOracle server OracleTarget SourceNetworkExtractReplicatCollectorTrailsManagerManagerLogOracle GoldenGate for Oracle to Oracle                                          Page 2 and loaded with initial data. The GoldenGate Manager processes are also started so that other processes may be configured and started. Configure Initial Data Load To initially load data, there are techniques such as Backup/Restore or Export/Import, both of which have pros and cons. Or you may use the...