Monthly Archives: April 2018

Migrating from Oracle to PostgreSQL (with Ora2Pg)

Today I want to write about one of the most used tools for migrating from Oracle to PostgreSQL. Ora2Pg is Free Software written and maintained by Gilles Darold. In this example Oracle database and the PostgreSQL database are running on the same server. I will show both variants of migration: Variant 1- Oracle and PostgreSQL running…

Oracle 12c-Step by Step Manual Data Guard Switchover

Switchover Operation Procedure:  After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs  called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss…