Migration of Oracle database to Postgres with minimum downtime using Oracle GoldenGate

Continuing the series of articles on methods of migrating Oracle databases to PostgreSQL with minimal downtime. 

Today, we will talk about using Oracle GoldenGate for this purpose.

<read more...>

Creating a replication schemas Postgres -> [Postgres & Oracle] using Oracle GoldenGate

Continuing the series of articles on setting up high-availability environments for PostgreSQL databases.

This time, I'm exploring the architecture with:

       - Bidirectional replication (master-master) between PostgreSQL databases.

       - Unidirectional replication (master-slave) between PostgreSQL and Oracle databases.

<read more...>

How to migrate data from Oracle to PostgreSQL using Ora2pg

My experience migrating databases from Oracle to Postgres.

<read more...>

Global Temporary Table support from Standby

One of the primary use cases for physical standby is running read only workloads. 

But read only workloads are not 100% read only and may require the final results to be written. 

In this case, we can use the new features, the ability to read/write global temporary tables for physical standby (ADG configuration) version 12c.

<read more...>

Connecting PostgreSQL to an Oracle database (oracle_fdw)

PostgreSQL provides foreign data wrappers (FDW) as a mechanism for accessing various external data sources. 
This article explains how to access Oracle databases using oracle_fdw, a foreign data wrapper for Oracle databases.

Backup PostgreSQL with Barman

The traditional Barman backup via rsync/SSH is supporting options:

- incremental backup, 
- parallel backup,

- WAL compression, network compression during backup,

- deduplication,

- using tablespaces

Two ways to recover data in an Oracle database table containing corruption blocks

Solutions
1. RECOVER DATAFILE ... BLOCK ...
2. DBMS_REPAIR package