What is database replication in Oracle?

What is database replication in Oracle?

Oracle replication is a fully integrated feature of the Oracle server; it is not a separate server. Replication uses distributed database technology to share data between multiple sites, but a replicated database and a distributed database are not the same.

What is change data capture in Oracle?

Change Data Capture efficiently identifies and captures data that has been added to, updated, or removed from, Oracle relational tables, and makes the change data available for use by applications. Change Data Capture is provided as an Oracle database server component with Oracle9i.

How does database replication work?

Replication is the process of copying data from a central database to one or more databases. The central database is called the publication database because it provides the data for users at other sites. The data in the publication database is copied (replicated) to subscription databases at other locations.

What is stream replication?

Overview of Streams Replication. Replication is the process of sharing database objects and data at multiple databases. To maintain replicated database objects and data at multiple databases, a change to one of these database objects at a database is shared with the other databases.

What is Data Guard replication?

Data Guard supports active-passive replication. One of the database is the primary database and the other one is in an inactive Data Guard mode. GoldenGate supports an active-active replication mode and allows both systems to work simultaneously while maintaining the data integrity.

What is a CDC tool?

Change Data Capture is a software process that identifies and tracks changes to data in a database. CDC provides real-time or near-real-time movement of data by moving and processing data continuously as new database events occur.

What are the types of database replication?

Types of data replication

• Full table replication.
• Transactional replication.
• Snapshot replication.
• Merge replication.
• Key-based incremental replication.

What is RFS in Oracle Data Guard?

Remote file server (RFS) The remote file server (RFS) process receives redo data from the primary database either in the form of archived redo logs or standby redo logs.

What is Pg_rewind?

pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. A typical scenario is to bring an old primary server back online after failover as a standby that follows the new primary.

What is pipeline DB?

PipelineDB is a PostgreSQL extension for high-performance time-series aggregation, designed to power realtime reporting and analytics applications. PipelineDB allows you to define continuous SQL queries that perpetually aggregate time-series data and store only the aggregate output in regular, queryable tables.