Database management

Why ODA reimaging doesn’t work on the first try?

Introduction Reimaging an ODA is a good practice for a lot of reasons. To make your ODA cleaner if it’s running for many years and if you patch regularly. To simplify patching because if you’re late you could have to(…)

What Benefit You Get From The Cloud For Your Business?

Microsoft, Amazon, Google and Oracle offer infrastructure services whose names change, but the concepts remain the same. It may be that you are interested in the cloud too, but it's still not clear because you find(…)

How to migrate from on-premise to an Azure SQL Database

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t(…)

Direct NFS, ODM 4.0 in 12.2: archiver stuck situation after a shutdown abort and restart

A customer had an interesting case recently. Since Oracle 12.2. he got archiver stuck situations after a shutdown abort and restart. I reproduced the issue and it is caused by direct NFS since running ODM 4.0 (i.e. since 12.2.). The(…)

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)

SQL Server Temporal Table – How to store a history table in another file?

Few days ago, a customer asks me if it is possible to move the history table to slower but cheaper storage. The question behind this is whether it is possible to create a history table on a separate filegroup(…)

How to patch your ODA lite to 18.3.0.0.0

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if(…)

Create a primary database using the backup of a standby database on 12cR2

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in(…)

New search function for Oracle database features

Oracle released a new way to search for database features, and it is ...

Recover a corrupted datafile in your DataGuard environment 11G/12C.

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to(…)