All articles

Oracle 18c DataGuard with Nologging Mode

By Mouhamadou Diaw With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment(…)

RMAN catalog upgrade, why, when and how

One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02(…)

The size of Oracle Home: from 9GB to 600MB – What about SQL Server?

Holidays is over and let’s start working with a funny write-up. I was reading interesting stuff done by my colleagues Franck Pachot and Daniel Westermann about reducing the size of Oracle / PostgreSQL binaries(…)

Restoring a database without having any controlfile backup

It should never happen but sometimes it happens. You just lost your datafiles as well as your fast recovery area (probably because most of the time these areas are on the same disks despite the recommendations). Normal restore operations with(…)

When we do a pg_dump and right afterwards truncate a table which is in the dump, what happens?

Being at customers is always the best way to learn. Today while discussing that pg_dump will always produce a consistent dump because it uses the "repeatable read" isolation level this question came up: What happens when we(…)

A tribute to Natural Join

By Franck Pachot . I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often. Why(…)

Running PLSQL as SYSDBA through DEFINER-rights?

Recently I got an interesting request: The customer wanted to allow the application installation routine to create a guaranteed restore point without giving it all required privileges to do so. So the idea was to encapsulate creating and dropping a(…)

The size of Oracle Home: from 9GB to 600MB – What about PostgreSQL?

A recent blog post from Franck and a tweet around that topic is the inspiration for this blog post, thanks Jan for requesting :). In short it is about how small(…)

The size of Oracle Home: from 9GB to 600MB

By Franck Pachot . This is research only and totally unsupported. When building docker images to run Oracle Database in a container, we try to get the smallest image possible. One way is to remove some subdirectories that we know(…)

Easily manage dual backup destination with RMAN

Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these(…)