When the economy is still faltering and unpredictable, what more could you wish for than to have a Gate made of Gold. Though Oracle GoldenGate may not be the physical Gold but the ease with which it solves the peer to peer replication problems, it’s flexibility, robustness, speed and scalability – it’s certainly worth its weight in Gold. It is an integral part of Oracle’s Maximum Availability Architecture which together with several other products allows your data center to function with zero downtime and high availability.
The Goldengate HANDLECOLLISIONS parameter is configured on the Replicat side to continue processing of the data when there are data integrity issues on the destination side and is okay to do so. It is utilized when there is a possibility of an overlap of the trail data being applied by the replicat process (replicat) where the data already exists in the destination tables.
For replication to be robust, well tuned and secure, some out of the box settings need to modified. Here is a list of these items, focusing on the Goldengate Best Practices and Security, in areas such as the Database, Parameters, processes, etc. Read more here.
Goldengate supports the replication of DDL commands, operating at a schema level, from one database to another. By default the DDL replication is disabled on the source database (extract side) but is enabled on the target Database (replicat side). The commands below are used to activate the DDL replication.
The Oracle Goldengate Replicat process also known as the apply process, is a mandatory process in the Goldengate setup. This data delivery process is the last component to be setup on the the target database. It reads the data from a file known an EXTTRAIL file which contains data changes made on the source. In addition to applying the data on the target, the Goldengate replicat also posts its exact location of the trail file while processing records. This is used for recovery from crashes, allowing it to start from the exact point where it left off, without any data loss.