Skip to main content

Oracle Golden Gate

Oracle golden gate is a data replicant solution that is seperate from the oracle database.

 It is a distinct product that needs to be install and configured separately and request its own licence.

 This solution allows from the replication of the subset of data in one database to another subset of data in different database.

 One of its most powerful future is to ability to replicate between none.

 Oracle database such as replicating some tables in an Oracle database to some tables in SQL server and vice versa.

 Another strong feature of this product is its PI directional replication capability.

 You just can connect and make changes to data bases on either side whether it is the source or destination Database and golden gate takes care of implementing the changes on each database.

 You might wonder about the difference between data card and Golden Gate while data guard also replicates data from the primary database to the standby database, Golden Gate offers more control over what data gets replicated, allowing for replication of just a subset of data.

 Additionally the bi directional replication feature sets Golden Gate apart from dataguard.



Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more