GoldenGate Downstream capture offloads all GoldenGate capture processing to another system and the source system is continuously ship redo to a downstream site using Data Guard remote deployment (redo) log transport service. Note that the license for Oracle GoldenGate includes a full use license for Oracle Active Data Guard, and XStream in the Oracle Database. If the user has any planned or unplanned failover then the processes will start on Standby during the role transmission and ensure no data loss. Oracle GoldenGate Integrated capture is now integrated with Data Guard Fast-Start Failover and Oracle Clusterware. Oracle GoldenGate 12c offers automated and transparent failover of components with the failover or switch over of DataGuard. High Availability (HA) enhancements The main enhancements in HA are: Please check the below link for supported Oracle data types Doesn’t have limit number of 32k columns, but each trail record has a length limit of 4MB for inline records.Not supported as resolution columns in conflict resolution and detection (CDR) config.Does not support 32k VARCHAR2 columns as part of key or unique index, nor column in a KEYCOLS.But there are few limitations for 32K VARCHAR2 data type: This new data type column is supported when extract is integrated capture mode and all modes of replicate are supported. Oracle GoldenGate12c supports capture and Replicat of the new 32K VARCHAR2 data type, which is introduced in Oracle Database 12c. You can use THREAD or THREADRANGE option in MAP statement to specify threads and maximum number of threads in a Replicat group. The main parameters controls this process are THREAD or THREADRANGE. Also note that coordinate Replicat is not aware of foreign key constraints. This method can be used for both Oracle and Non-Oracle databases and it eliminates the need to manage multiple parameter files.Ĭoordinated Replicat does not include dynamic allocation of threads and you need to indicate which tables belong to which threads. The coordinator thread plays a key role in during the replication process, it manages the transactions across multiple threads to take care of dependencies across the threads such as DDL and Primary key updates, SQLEXEC Processing and Event Management Infrastcture (EMI) processing. Each thread associated with coordinated Replicat can handle the assigned workload such as filtering, mapping, conversion,SQL construction and error handling. The main advantage of using coordinated against classic mode, is that Replicat is multi-threaded and this helps to read trail files independently and apply transactions in parallel. In order to GRANT or REVOKE the privilege, the user must be an administrative user. REVOKE_ADMIN_PRIVILEGE – Revokes the Admin privilege GRANT_ADMIN_PRIVILEGE – Grant the Admin privilege This package provides subprograms for granting and revoking privileges. Oracle GoldenGate simplifies security using DBMS_GOLDENGATE_AUTH package. You can create multiple entries with different alias by using ADD USER with ALIAS option. If you don’t use the alias then then it defaults to the USERNAME. When you install Oracle GoldenGate for the first time, the default credential store will be created. User can create the alias as shown below: GCSCI> alter CREDENTIALSTORE add user GGADM password xxxx alias GGADMALIAS Prior to 12c, username and password information was stored in lightly encrypted or plan text format. User can create an alias which is associated with actual usernames and passwords. Oracle GoldenGate 12c now integrates with the Oracle Credential store and Oracle Wallet to store and retrieve encrypted usernames and passwords.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |