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

PgBackRest : Dedicated Backup Host

By | Database Administration & Monitoring | No Comments

In previous blogs (blog1 and blog2) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration is fine if we have a single database server. But in the case that we have many database servers, it is more suitable to have a dedicated server for backups. This will also separate the backups and WAL archive from databases server In this article we…

 
Read More
Mouhamadou Diaw

Hash Partitioning in PostgreSQL 11

By | Database Administration & Monitoring | No Comments

PostgreSQL 10 comes with partition support. But Hash Partitioning was not supported. PostgreSQL 11 will support Hash Partition. In the documentation we can read The table is partitioned by specifying a modulus and a remainder for each partition. Each partition will hold the rows for which the hash value of the partition key divided by the specified modulus will produce the specified remainder. For this demonstration let’s create a table with a hash partition drop…

 
Read More
Mouhamadou Diaw

Automatic Block Media Recovery in a DataGuard

By | Database Administration & Monitoring | No Comments

With Oracle 12.2, in a Data Guard environment corrupted data blocks can be automatically replaced with uncorrupted copies of those blocks. There are just some requirements: • The physical standby database must be operating in real-time query mode, which requires an Oracle Active Data Guard license. • The physical standby database must be running real-time apply. Automatic block media recovery works in two directions depending on whether the corrupted blocks are encountered on the primary…

 
Read More
Mouhamadou Diaw

EDB Failover Manager 3.0 and PostgreSQL 10.1

By | Database Administration & Monitoring | 3 Comments

Edb Failover Manager edb-efm30 is now released and supports PostgreSQL 10.1. Efm is an EDB tool which can be used to perform a switchover and a failover in a PostgreSQL standby environment. In this blog we are going to see how we can install and configure efm in a standby environment. We suppose that the standby is already confugured and is running. We also have not configured any VIP. I just use 3 virtual machines…

 
Read More
Mouhamadou Diaw

Backup and Restore PostgreSQL with PgBackRest II

By | Database Administration & Monitoring | No Comments

In a precedent blog I shown a basic utilization of PgBackRest which is a tool to backup and restore PostgreSQL databases. In this blog I am going to talk some useful features of this tool. In practical examples we will see some tasks we can do with this tool. Of course the official documentation remains the best source of knowledges. Encryption Nowadays encryption of backups is very critical and is mandatory for many companies. PgBackRest…

 
Read More
Mouhamadou Diaw

Backup and Restore PostgreSQL with PgBackRest I

By | Database Administration & Monitoring | No Comments

Many tools can be used to backup PostgreSQL databases. In this blog I will talk about PgBackRest which is a simple tool that can be used to backup and restore a PostgreSQL database. Full, differential, and incremental backups are supported. In this first blog I will present a basic configuration of pgbackprest. Our configuration is composed of only one cluster and pgbackrest is installed on the server hosting the database. The goal is to explain…

 
Read More
Mouhamadou Diaw

Automatic Data Optimization Part II : StorageTiering

By | Database Administration & Monitoring | No Comments

In first a previous blog, we saw how Automatic Data Optimization can be used to compress data under predefined conditions. In this blog we will see that another possible action with ADO is to move data to another storage. Indeed we will demonstrate how it is possible to move a table to another tablespace based on predefined conditions. We are using oracle a 12.1.0.2 non-CDB database. Let’s considerer following table ARTICLE in the tablespace USERS…

 
Read More
Mouhamadou Diaw

Automatic Data Optimization Part I : Compression Tiering

By | Database Administration & Monitoring | No Comments

Nowadays data are increasing more and more. And some challenges we can face can be how to reduce storage costs and how to improve performance. With Oracle 12c, the feature Automatic Data Optimization (ADO) can help us. In this first blog we will see how we can use ADO to compress data under predefined conditions. ADO is part of Information Lifecycle Management (ILM). Note that ADO requires Advanced Compression Option. In this article we are…

 
Read More
Mouhamadou Diaw

Online datafile move in a 12c dataguard environment

By | Database Administration & Monitoring | No Comments

Oracle 12c introduces moving online datafile. One question we might ask is what about moving datafile online in a dataguard environment. In this blog we will do some tests Below our configuration, we are using oracle 12.2 DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 8 seconds ago) DGMGRL> The StandbyFileManagement property is set to auto…

 
Read More
Mouhamadou Diaw

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By | Database Administration & Monitoring | No Comments

The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle 12.2 is used. DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 35 seconds ago) DGMGRL> The primary database has the…

 
Read More