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…
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…
Physical Standby Commands _________________________ To start redo apply in foreground: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To stop redo apply process on the Standby database (to stop MRP): SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; To start real-time redo apply: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;…
There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an elastic pool so you can maximize what you’re paying for and share the resources. Anyway,…
First of all, What is a Load Balancer A load balancer can be deployed as software or hardware to a device that distributes connections from clients between a set of servers. A load balancer acts as a ‘reverse-proxy’ to represent the application servers to the client through a virtual IP address (VIP). This technology is…
A quick Guide on How to Install the Oracle Database 12c Release 2 in Redhat Enterprise Linux 7.5 Server. To Download the Oracle Database Installer, Visit the below URL: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Prerequiste for Installation: Download the Oracle Database 12c installer package. The Swap Space size should be 16GB . Enable X11 Forwarding to “yes” in sshd…
To create PostgreSQL replication first we must install PostgreSQL on Primary and Standby server. On Primary and Standby: [root@localhost ]# yum -y install epel-release [root@localhost ]# yum -y install bash-completion [root@localhost ]# yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm [root@localhost ]# yum install postgresql11-server [root@localhost ]# yum install postgresql11-contrib On Primary: [root@localhost ]# /usr/pgsql-11/bin/postgresql-11-setup initdb Initializing database ……
by Jim Okla January 27, 2015 Posted in: How To I recently came across a very unusual situation. During an upgraded review, I noticed the dba_registry_sqlpatch was empty when it shouldn’t be: SQL> select patch_id, patch_uid, version, action, action_time, status, description from dba_registry_sqlpatch; no rows selected SQL> The expected output should be (from another CDB…
Condition: All copies of the control file have been deleted The data is in the order of files and online redo logs Our control file has backups Database archive works in log mode First we look at where our control files are located SQL> select name from v$controlfile; NAME ——————————————————————————– /u01/app/oracle/oradata/DB11G/control01.ctl /u01/app/oracle/oradata/DB11G/control02.ctl We then…
Condition: All control files have been deleted After backup of the control file, the newly created data file was deleted The control file has a binary backup . To test this situation, we first get the binary backup of the control file and then delete all the control files: SQL> alter database backup controlfile to…