In Oracle : Oracle Replication

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA

-> Oracle Replication

 

 Oracle Replication

       Very often a part of the database (a schema or some tables) or the entire database must have a replica. The database data must be replicated for data guard or for reporting purpose. The replication can be done in real time or several times during a period of time. Other time the replication can be done for creating a test environment.

       The replication of the database is done also in a Data Guard. In this case we will have a complete Oracle database replicated. We can have a physical replication or just a data replication. When we have a physical replication we speak about a physical standby database. In such a case, the replicated database (databases) are physically identical (they have the same structure at the block level, they have the same files, etc.). When only the data is replicated, we can have a different physical structure (more indexes, less or more physical files, or the same number of files, but with different names, locations, etc). In this case we speak about a logical replication, so about a logical standby database.

       Sometimes we need to replicate a table. A table can be replicated using a materialized view, using the Oracle streams oe using a 3rd party vendor product. The most used are the materialized views (for the tables).

      When the replication is used for reporting, generally the replication is done on another database. In this case we can speak about the production database and the reporting database. The reporting database is not necessarily a data warehouse which contains cubes. This could be a "normal" database. If we need reports in real time, the replication is done in real time.

     

      Here are some links you may be interested of:

Oracle Physical Standby Database

Oracle Physical Standby Database (RMAN)

Oracle Logical Standby Database

Oracle Materialized views (=snapshot)

Replicate a table with Oracle Streams

 

 

In-Oracle.com  -> Oracle DBA

-> Oracle Replication

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.