Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

Dbvisit 9: Adding datafiles and or tempfiles

By | Database Administration & Monitoring, Oracle | No Comments

One question I was asking is if the standby_file_management parameter is relevant in a Dbvisit environment with Oracle Standard Edition. I did some tests and I show here what I did. We suppose that the Dbvisit is already set and that the replication is fine [[email protected] trace]$ /u01/app/dbvisit/standby/dbvctl -d dbstd -i ============================================================= Dbvisit Standby Database Technology (9.0.08_0_g99a272b) (pid 19567) dbvctl started on dbvisit1: Fri Jan 17 16:48:16 2020 ============================================================= Dbvisit Standby log gap report for…

Read More
Mouhamadou Diaw

Dbvisit Standby 9 : Do you know the new snapshot feature?

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose that the dbvisit environment is already set and the replication is going fine. See previous blog for setting up dbvisit standby First there…

Read More
Mouhamadou Diaw

PostgreSQL 12 : Setting Up Streaming Replication

By | Database Administration & Monitoring, Postgres | No Comments

PostgreSQL 12 was released a few month ago. When actually setting up a replication, there is no longer recovery.conf file in the PGDATA. Indeed all parameters of the recovery.conf should be now in the postgresql.conf file. And in the cluster data directory of the standby server, therre should be a file named standby.signal to trigger the standby mode. In this blog I am just building a streaming replication between 2 servers to show these changes….

Read More
Mouhamadou Diaw

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

By | Database Administration & Monitoring, Oracle | 2 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 | One Comment

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