Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
oracle_12_goldengate_basic [2019/11/09 11:45] – [Schema Migration] andonovj | oracle_12_goldengate_basic [2020/11/06 17:02] (current) – andonovj | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======Golden | + | ======Golden |
+ | Golden Gate is a separate software of Oracle which enables the configuration of replication between oracle database, but also between Oracle and other databases in heterogenous environment. | ||
+ | In a nutshell, the configuration follows the following steps: | ||
- | The configuration of GoldenGate replication depends on the architecture which is required: | + | {{:goldengateoverview.jpg? |
- | | + | |
- | | + | |
- | | + | |
- | * Round | + | |
- | Therefore the configuration is different. Let's start with Unidirectional replication as follows: | ||
- | * Source: sourceSVR | + | ====Configuration==== |
- | * Destination: | + | - [[oracle_12_goldengate_conf_prepare_source| Configure |
- | + | - [[oracle_12_goldengate_initial_load|Initial Load]] | |
- | P.S. When it comes to conventions, | + | - [[oracle_12_goldengate_conf_prepare_destination| Configure |
- | + | - [[oracle_12_clean_environment|Clean the environment]] | |
- | Based on that let's see our settings: | + | |
- | + | ||
- | ====Full migration==== | + | |
- | - [[oracle_12_goldengate_conf_prepare_source| Configure | + | |
- | - [[oracle_12_goldengate_conf_initial_load| Create a base]] | + | |
- | - [[oracle_12_goldengate_conf_initial_load_p2| Restore | + | |
- | - [[oracle_12_goldengate_conf_prepare_destination| Configure | + | |
+ | ====Zero-Downtime Setup==== | ||
+ | - [[oracle_12_goldengate_zero_downtime_config|Configuration]] | ||
====Schema Migration==== | ====Schema Migration==== |