Infrastructure at your Service

All posts by Mouhamadou Diaw

Mouhamadou Diaw
Consultant

Mouhamadou Diaw has more than ten years of experience in IT domains. He is specialized in Oracle technologies (engineered system, architecture, backup and recovery, high availability, security, audit etc.). Mouhamadou Diaw is Oracle professional Certified (8i, 10g, 11g, 12c), Oracle RAC 11gR2 Certified Expert , Oracle Database 11g Security Certified and CISA (Isaca). He received a Doctorate in Heat and Humidity Transfer of INSA Toulouse, France. His branch-related experience covers Insurance, Retail, International Organizations, Transport & Logistics, etc.
Mouhamadou Diaw

Temporal tables with PostgreSQL

By | Database Administration & Monitoring | No Comments

In this blog we are going to talk about a nice extension in PostgreSQL: temporal_tables. This extension provides support for temporal tables. What is a temporal table? Just a table that tracks the period of validity of a row. When implemented, this feature allows you to specify that old rows are archived into another table (that is called the history table). This can be useful for many purposes -Audit -Comparison -Checking table state in the…

 
Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Observers

By | Database Administration & Monitoring | One Comment

With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers that can continue to monitor the status of the configuration. In this blog we are going to talk about this new feature. Our configuration have 3 servers: primaserver.localdomain with db_unique_name ORCL_SITE standserver1.localdomain with db_unique_name ORCL_SITE1 standserver2.localdomain with db_unique_name ORCL_SITE2…

 
Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Automatic Failover Targets

By | Database Administration & Monitoring | No Comments

In a previous blog, we talked about Fast-Start Failover with the MaxProtection mode. With Oracle 12.2 Oracle Data Guard now supports multiple failover targets in a fast-start failover configuration. Previous functionality allowed for only a single fast-start failover target. If the failover target was unable to meet the requirements for fast-start failover at the time of primary failure, then an automatic failure would not occur. Designating multiple failover targets significantly improves the likelihood that there…

 
Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

By | Database Administration & Monitoring | No Comments

With Oracle 12.1 the one requirement to configure Fast-start Failover is to ensure the broker configuration is operating in either Maximum Availability mode or Maximum Performance mode. With 12.2 Fast-Start Failover can be now configured with the Maximum Protection Below our broker configuration DGMGRL> show configuration; Configuration – ORCL_DR Protection Mode: MaxPerformance Members: ORCL_SITE – Primary database ORCL_SITE1 – Physical standby database ORCL_SITE2 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated…

 
Read More
Mouhamadou Diaw

EnterpriseDB Backup and Recovery Tool (BART)

By | Database Administration & Monitoring | No Comments

Many tools are proposed for backup and recovery operation of a PostgreSQL database. EnterpriseDB has developed a product named BART (Backup and Recovery Tool). Use of this product needs a subscription but you can download a trial version for test purpose. In this blog we are using BART with PostgreSQL 9.6.1. BART allows backing up over the net and can centralize backups of many PostgreSQL servers. We are using the following configuration: Bart Host: pgserver.localdomain…

 
Read More
Mouhamadou Diaw

Installing PostgreSQL 9.6.1 with EnterpriseDB Installer

By | Database Administration & Monitoring | No Comments

As you may know PostgreSQL 9.6 was released a few months ago. And EnterpriseDB (EDB) offers a package installer for installing the community version. This EDB package can be downloaded here. In this blog we are going to install PostgreSQL using edb installer. The installation is done using a graphical tool. A user with root privileges must be used otherwise we will get an error. Indeed the default installation creates the systemd service which need…

 
Read More
Mouhamadou Diaw

Switchover and Failover with Dbvisit 8

By | Database Administration & Monitoring | No Comments

In this blog we will talk about how to do a switchover and how to do a failover. We suppose that dbvisit is already installed and that a standby database is already configured. Our instance is named DBPRIMA. Switchover SWITCHOVER is the fact to change database role. The primary becomes the standby and the standby becomes the primary. This can be useful for many reasons. Before performing a switchover, we have first to send archived…

 
Read More
Mouhamadou Diaw

Creating standby database with Dbvisit 8

By | Database Administration & Monitoring | No Comments

The new version of Dbvisit standby is now released. In this blog we are going to see how to install dbvisit 8 and how to create a standby database. For the installation after downloading the software, just uncompress it and then run the install-dbvisit command under the installer directory. The installation process is divided in 2 parts. 1- Core Components (Dbvisit Standby Cli, Dbvnet, Dbvagent) –On both servers 2- Dbvserver console installation. Just note that…

 
Read More
Mouhamadou Diaw

Amazon Web Services: Upgrade to Dbvisit Standby 8

By | Cloud | No Comments

In a previous blog we installed Dbvisit Standby 7 on two AWS linux instances. In this article we are just upgrading to Dbvisit Standby 8. The first thing is to stop on both nodes dbvnet and dbvserver on both servers [oracle@primaserver dbvnet]$ ps -ef|grep dbv|grep -v grep oracle 2062 1 0 04:53 ? 00:00:02 /u01/app/dbvisit/dbvserver/dbvserverd oracle 2064 2062 0 04:53 ? 00:00:00 /u01/app/dbvisit/dbvserver/dbvserverd oracle 2131 1 0 04:54 ? 00:00:00 /u01/app/dbvisit/dbvnet/dbvnetd oracle 2132 2131 0…

 
Read More
Mouhamadou Diaw

Installing Dbvisit Standby 7 between two AWS Linux Instances

By | Cloud | No Comments

Dbvisit is compatible with Amazon Cloud. In this article we are going to talk about installation of Oracle SE2 and Dbvisit Standby 7 between 2 AWS linux instances. We suppose that ssh equivalence is configured for user oracle used for dbvisit installation. First we have to install oracle software on both servers: primaserver and standserver. To Install oracle-rdbms-server-12cR1-preinstall.x86_64 package yum can be used to configure the repository [root@primaserver yum.repos.d]# wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle –2016-11-14 03:52:34–…

 
Read More