Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
Traditionally everything which is related to recovery in PostgreSQL goes to recovery.conf. This is not only true for recovery settings but also for turning an instance into a replica which follows a master. Some days ago this commit landed in the PostgreSQL git repository. What that effectively means is, that there will be no more recovery.conf starting with PostgreSQL 12.…
Did you ever use the famous DBCC PAGE command? Folks who are interested in digging further to the SQL Server storage already use it for a while. We also use it during our SQL Server performance workshop by the way. But the usage of such command may sometimes go beyond and it may be used for some troubleshooting scenarios. For…
I tried to apply a patch to my 18.3.0 GI/ASM two node cluster on RHEL 7.5. The first node worked fine, but the second node got always an error… Environment: Server Node1: dbserver01 Server Node2: dbserver02 Oracle Version: 18.3.0 with PSU OCT 2018 ==> 28660077 Patch to be installed: 28655784 (RU 18.4.0.0) First node (dbserver01) Everything fine: cd ${ORACLE_HOME}/OPatch sudo…
The amazing DOAG 2018 conference is over now. As every year we saw great technical as well as great non-technical sessions. What impressed me was the non-technical presentation “Zurück an die Arbeit – Wie aus Business-Theatern wieder echte Unternehmen werden” (back to work – how business theatres become real business company again) provided by Lars Vollmer. It was very funny,…
We all know that security becomes…sorry, is one of the hottest topic when setting up IT environment. One basis for that is to be compliant with regulations or standards such as GDPR or CIS. What is not so well known, is that ODA already integrates some tool to support you for that. During this first day @DOAG2018 I followed and…
In the case you have the following configuration and requirements Your Power BI, paginated mobile KPI reports are published on your on premise Power BI Report Server (Named i.e. SRV-PBIRS), their data sources is an Analysis Services located on another server (Named i.e. SRV-SSASTAB\INST01, INST01 being the named instance) and you want to track/monitor who is accessing the data on…
Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting.…
This article describes patching a virtualized Oracle Database Appliance (ODA) containing only an ODA_BASE virtual machine. Do this patching first on test machines because it can not be guaranteed that all causes of failures of single VM ODAs are covered in this article. I got the experience that precheck for ODA patches does not detect some failure conditions which may…
After the minimal setup of the DC/OS in my further articles, I wanted to extend my DC/OS and add a loadbalancer. There are two options for loadbalancing in DC/OS 1. Marathon-LB (a layer 7 load balancer, used for external requests, based on HAProxy) 2. Named VIPs (a layer 4 load balancer used for internal TCP traffic) In this article we…
Some days ago EnterpriseDB released the latest version of its backup and recovery tool for PostgreSQL and EDB Postgres Advanced Server, release notes here. The main new features, at least for me, are backups using multiple cores and parallel incremental restores. Besides that BART does not require pg_basebackup anymore for taking full backups of a PostgreSQL instance. The downside with…
When a patch fails on a virtualized Oracle Database Appliance (ODA), this ODA is often unusuable because Linux and OAKD are patched to new release but Grid Infrastructure is still on old version. OAKD cannot be restarted in default mode because in this mode the active Grid Infrastructure version is checked, which will fail due to old version. Also Grid…
PostgreSQL supports index only scans since version 9.2 which was released in September 2013. The purpose of an index only scan is to fetch all the required values entirely from the index without visiting the table (the heap) at all. Of course that can speed up a query because avoiding to touch the heap, means reading less data and reading…
