Category Archives: Oracle in general

Oracle Dataguard – automatic archive log file management on primary site

Posted on September 23, 2009 by Ronny Egner

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 →

Posted in Oracle in general | Leave a comment

Changing ADR Destination for 11g Listener

Posted on September 22, 2009 by Ronny Egner

With 11g Release 1 Oracle introduced the Automatic Diagnostic Repository  – “ADR”. The ADR is designed as central repository for storing all oracle-related log files such as alert.log, listener.log and so on. The log files are stored in XML format … Continue reading →

Posted in Oracle in general | Leave a comment

Building and using the kfed utility

Posted on September 21, 2009 by Ronny Egner

When using ASM sometimes it it extremely helpful to get more information on the asm disk header. The “kfed” utility from oracle enables to dump the asm disk header and many more. With this tool corruptions to the asm can … Continue reading →

Posted in Oracle ASM, Oracle in general | Leave a comment

Using ASM with files (either locally or via NFS)

Posted on September 21, 2009 by Ronny Egner

From time to time i need to configure additional and temporary storage for data migration or just testing purposes. Raw Devices are not recommended to use from 11g onwards. So why not use the loopback device for that? With this scenario … Continue reading →

Posted in Oracle ASM, Oracle in general | 3 Comments