Infrastructure at your Service

Category

Database Administration & Monitoring

David Barbarin

When Read-Scale availability groups and Windows Failover Cluster are not good friends

By | Database Administration & Monitoring, SQL Server | No Comments

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them.   Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to install an underlying cluster. Obviously, you will not benefit from resource orchestration and automatic failover, but this is obviously the…

Read More
Jérôme Dubar

ODA X8-2: the new generation

By | Database Administration & Monitoring, Hardware & Storage, Oracle | No Comments

Introduction ODA X7-2 marked the maturity of the Oracle Database Appliance evolution, with 3 models suitable for nearly all customers using Oracle databases. The X7-2M was my favorite, with a lots of cores available (and restrainable), enough memory for dozens of databases, and strong storage performance and capacity (with a maximum of 50TB RAW NVMe). And taking up only 1U of space in your rack. Today, 2 years later, Oracle just introduced the new generation…

Read More
David Barbarin

How to get a big picture of K8s pods and PVs by script

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes | No Comments

A couple of weeks ago, during an internal dbi services workshop about Docker and K8s, I got an interesting question: is it possible to get a big picture of pods connected to one specific persistent volume (PV) by using kubectl command? It was an interesting question because if we go through the usual kubectl command, it doesn’t provide natively the desired output. In fact, one one hand we get information about PVs and their related…

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
Marc Wagner

Moving oracle database to new home on ODA

By | Database Administration & Monitoring | No Comments

Moving database to new ORACLE_HOME is a common dba task. Performing this task on an ODA will need an additional step knowing ODA Lite is using an internal Derby database for the metadata. ODA HA will not be a problem here, knowing we do not have any Derby database. Through this blog I would like to give you some guidance and work around to move database to a new home (of same major release). In…

Read More
David Barbarin

Introducing Accelerated Database Recovery with SQL Server 2019

By | Database Administration & Monitoring, SQL Server | 2 Comments

SQL Server 2019 RC1 was released out a few weeks ago and it is time to start blogging about my favorite core engine features that will be shipped with the next version of SQL Server. Things should not be completely different with the RTM, so let’s introduce the accelerated database recovery (aka ADR) which is mainly designed to solve an annoying issue that probably most of SQL Server DBAs already faced at least one time:…

Read More
David Barbarin

Debugging SQL Server containers considerations

By | Database Administration & Monitoring, Docker, SQL Server | No Comments

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to strace tool. But let’s add containers in the game now. I didn’t want to touch any based image for applications including SQL Server with debugging tools added. So, my concern was to figure out how to…

Read More
Jérôme Dubar

Useful Linux commands for an Oracle DBA

By | Database Administration & Monitoring, Operation systems, Oracle | 2 Comments

Introduction Oracle & Linux is a great duet. Very powerfull, very scriptable. Here are several commands that make my life easier. These tools seems to be widespread on most of the Linux distributions. watch with diff It’s my favorite tool since a long time. watch can repeat a command indefinitely until you stop it with Ctrl+C. And it’s even more useful with the – -diff parameter. All the differences since last run are highlighted. For…

Read More