Author Archives: Ronny Egner

Oracle 11g Release 2 – RMAN compression comparison

Posted on November 4, 2009 by Ronny Egner

Starting with Oracle 11g Oracle added several compression algorithms to compress data. They can be used for compressing tables, LOBs , compressed data pump exports or even RMAN backups. Unfortunately for some compression algorithms you need to purchase the “Advanced … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 15 Comments

ACFS Snapshots

Posted on November 3, 2009 by Ronny Egner

This is a short article about ACFS and the acfs snapshots feature – a new 11g Release 2 feature: How to create, work with and drop a snapshot. ACFS is the ASM Cluster File System and ships with Oracle 11g … Continue reading →

Posted in Oracle in general | 2 Comments

Oracle database and operating support matrix

Posted on November 2, 2009 by Ronny Egner

The following matrix shows a matrix of operating systems, database version and certification status. All information is taken from the database documentation and information freely available on the internet (e.g. oracle forums, blogs). The information is structured first into operating … Continue reading →

Posted in Oracle in general | 8 Comments

Using data pump to export and import data using the network mode feature

Posted on November 2, 2009 by Ronny Egner

Data Pump is a great improvement of the old fashioned export and import utility. Data Pump is available since 10g Release 2 and offers some nice new features, for instance a API to be used to start exports and imports … Continue reading →

Posted in Oracle in general | 2 Comments

How to copy schema stats from one schema to another schema

Posted on October 30, 2009 by Ronny Egner

The following post is a short description how to copy schema statistics from one schema to another. Basically there are two methods for doing this: using DBMS_STATS or using Data Pump This is especially useful when doing large data transfers … Continue reading →

Posted in Oracle in general | 8 Comments

Calculate required kernel parameters for running Oracle 11g Release 2 on Linux

Posted on October 28, 2009 by Ronny Egner

The following is a short guide on how to calculate the required kernel parameters for running Oracle 11g Release 2 database on Linux. In addition to that i add some parameters recommended by myself. Note that for running Oracle Grid … Continue reading →

Posted in Oracle 11g Release 2, Oracle in general | 4 Comments

ASM resilvering – or – how to recover your crashed cluster

Posted on October 27, 2009 by Ronny Egner

In this and the following posts i will perform some crash and recover scenarios and show how to recover the cluster successfully. At the moment the following tests are planned and will be published during the next days: suddenly turning … Continue reading →

Posted in Oracle 11g Release 2, Oracle ASM, Oracle in general | 2 Comments

ASM resilvering – or – how to recover your crashed cluster – Test no 5

Posted on October 27, 2009 by Ronny Egner

In this post we will reproduce a more common scenario: We will forcefully remove the asm disk device from the operating system. This simulates common errors like a crashed storage system or some kind of interrupted connectivity (cable plugged, power … Continue reading →

Posted in Oracle in general | 3 Comments

New Server

Posted on October 26, 2009 by Ronny Egner

As you might have noticed the Blog moved to a new server. This is a dedicated server so that i am able to install plugins, modify the layout and do much more (like hosting files different than images and documents). … Continue reading →

Posted in Uncategorized | Leave a comment

Backing up your system configuration

Posted on October 21, 2009 by Ronny Egner

When backing up servers with any kind of backup software you will most certainly backup your data. But how about the system configuration? When restoring a system from scratch do you know how big the disks were, what partition sizes, … Continue reading →

Posted in Oracle in general | Leave a comment