Blog

Who is SYSTEM?

30. March 2021 Johannes Ahrends

In many companies the DBAs – and not only them – are working with the user “SYSTEM“. Is that wrong? (…)

26. February 2021 Johannes Ahrends

If you create a database using dbca (Database Configuration Assistant) step 3 allows you to select one of two templates (…)

28. January 2021 Johannes Ahrends

Since Oracle 18 (with some restrictions) it’s possible to set the Oracle software installation directory <ORACLE_HOME> into read only. And (…)

15. May 2020 Johannes Ahrends 2

On May 7th Oracle released “Standard Edition High Availability” (SEHA). There has been a high availability gap so far because (…)

23. April 2020 Johannes Ahrends

April 15th was patch day again. New security patches, patch sets, release update and whatever they are named became available. (…)

30. March 2020 Johannes Ahrends

In one of my projects we had a disaster most recently: An application was connected to two databases simultaneously and (…)

25. September 2019 Johannes Ahrends

At the Openworld conference 2019 Oracle announced that Oracle 19c will allow up to three pluggable database per database on (…)

17. June 2019 Johannes Ahrends

In this blog I will show you how to use an RMAN backup to create a database clone. In my (…)

14. June 2019 Johannes Ahrends

In this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. (…)

5. June 2019 Johannes Ahrends

About 8 years ago I wrote a blog named: It’s so Easy to use RMAN for Backups. So it’s time (…)