Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

Oracle 19c : Point-In-Time Recovery in a PDB

By | Database Administration & Monitoring, Oracle | No Comments

Point-In-Time Recovery is also possible in a multitenant environment. As in Non-CDB, a recovery catalog can be used or not. In this blog we will see how to recover a dropped tablespace in a PDB. We will also see the importance of using a recovery catalog or not. A PITR of a PDB does not affect remaining PBDs. That means that while doing a PITR in PDB, people can use the other PDBs. In this…

Read More
Mouhamadou Diaw

OpenShift 4.1 Partner Introduction Day

By | DevOps, Kubernetes | No Comments

Today was the OpenShift Partner Introduction Day by RedHat. This event happened at Lausanne There were people with different backgrounds. After presenting the RedHat compagny, the speaker explained what is Openshifts and why people must adopt it. What we will retain is that OpenShift is trusted enterprise Kubernetes With OpenShift we can for example -Automated, full-stack installation from the container host to application services -Seamless Kubernetes deployment to any cloud or on-premises environment -Autoscaling of…

Read More
Mouhamadou Diaw

RMAN in a Multitenant Environment

By | Database Administration & Monitoring, Oracle | No Comments

The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an oracle 19c database with 2 pluggable databases. Below the configuration we are using. SQL> show pdbs CON_ID CON_NAME…

Read More
Mouhamadou Diaw

dbvisit 9: Automatic Failover

By | Database Administration & Monitoring | 2 Comments

dbvisit 9 is released since a few months. And one new feature I tested is the Automatic Failover. In this blog I suppose that dbvisit 9 is already installed and that the standby database is already created. Indeed I will not describe nor dbvisit installation neither the standby creation as it is the same as the previous versions. For more info about dbvisit installation and/or dbvisit standby creation please see these steps in my previous…

Read More
Mouhamadou Diaw

Evenement Oracle : Dans la tête d’un Hacker & Comment protéger vos données sensibles

By | Database Administration & Monitoring | No Comments

Pour une fois un blog en français parce que concernant un événement Oracle en Français. Aujourd’hui chez Oracle Suisse à Genève, il y’avait une présentation concernant la sécurité Oracle. Il s’agissait de se mettre à la place d’un Hacker pour mieux appréhender leurs démarches et ensuite comment protéger les données dans une base de données Oracle. Comprendre les intentions et moyens utilisés par les Hackers pour parvenir à leurs fins nous aide à mieux les…

Read More
Mouhamadou Diaw

Oracle 19C : Exporting and Importing Broker Configuration

By | Database Administration & Monitoring, Oracle | No Comments

Up to Oracle 19c, there was no automatic way to backup the configuration of the broker. One solution was to manually copy all executed instructions in a file. With Oracle 19c, there is now the possibility to export and to import the configuration of the broker. Indeed the new EXPORT CONFIGURATION command will enable to save the metadata contained in the broker configuration file to a text file. This can be very useful if I…

Read More
Mouhamadou Diaw

Oracle 19C : Dynamic Change of Fast-Start Failover Target

By | Database Administration & Monitoring, Oracle | No Comments

Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list without disabling the fast-start failover. I have tested this new feature and is describing this in this blog I am using 3 servers with Oracle Linux The Data Guard is already built and the broker is already configured…

Read More
Mouhamadou Diaw

Oracle 18c Grid Infrastructure on Windows Server

By | Database Administration & Monitoring, Oracle | No Comments

Oracle Grid Infrastucture can be installed on Windows platform. The steps are the same that on other platforms. In this blog we are going to install Oracle GI 18c on Windows 2016.I have two disks on my server Disk 0 : for the system Disk 1 : for the ASM I am using a VirtualBox virtual machine. We suppose that the grid infrastructure sofware is already downloaded and decompressed in the grid home. Like on…

Read More
Mouhamadou Diaw

PostgreSQL 12: New option –exclude-database for pg_dumpall

By | Database Administration & Monitoring, Postgres | No Comments

Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore the databases. It does this by calling pg_dump for each database in the cluster. PostgreSQL 12 is under development but we can test new features which will be implemented. Now with PostgreSQL 12 there is a new option…

Read More
Mouhamadou Diaw

PostgreSQL : barman rsync method vs streaming method

By | Database Administration & Monitoring, Postgres | 4 Comments

Barman is a tool to perform backup and recovery for PostgreSQL databases. It can do backup using two methods: -rsync/ssh -streaming In this blog I am going to explain how to use these two methods to backup a PostgreSQL database. Generally it is a good practice to dedicate a server for barman instead of installing it on the database server. My environment is described below postgreSQL server: dbi-pg-essentials 192.168.22.101 Centos 7 barman server: pgservertools 192.168.22.104…

Read More