Author Archives: Ronny Egner

Storing Oracle database connection strings in OpenLDAP – or – “Oracle Names for the masses” Typically Oracle stores it´s database connection strings in a file called TNSNAMES.ORA. Among storing every database connection string in this file there are other different … Continue reading →

Partition recommendations for Oracle on Linux Every system engineer or even every DBA comes along the following question from time to time: “How do i arrange my partitions for using oracle on linux?” In the following i am blogging my … Continue reading →

By default RMAN checks for physical corruptions in data files when performing backups. For a logical check you can add “check logical” to your rman backup command. With this clause rman also checks the block integrity logically. A few examples … Continue reading →

… or: the problem of backup association From time to time i come across the same problems in data guard configurations using rman-to-disk: Backups taken on the standby database are not taken into account when trying to perform an rman … Continue reading →

Overview on the AWR The automatic workload repository “AWR” was introduced with Oracle 10g. It collects performance data in intervals (default: 60 minutes) and keeps them by default for one week. The data is stored in the SYSAUX tablespace. The … Continue reading →

System Environment Suppose you have an oracle data guard environment with one primary database and one physical standby database running. You perform online backups with RMAN from the PRIMARY database. Your users complain about slowness during the night. You notice … Continue reading →