Monthly Archives: July 2007

Rman, restore database to another host with a different disk layout. When restoring a database backup to another system, you can specify the new locations of the datafiles to be restored to using the AUXFILE option in Rman, defining the … Continue reading →

Introduction This paper will walk you through the steps of installing Oracle Database 10g release 1 (Oracle version 10.1.0) in a Sun Solaris SPARC environment. About 90% of the material presented here applies to other platforms as well. Everything you … Continue reading →

Configure and use the sys.utl_mail package to send emails.

Tracing Sessions. You can often need to trace a session to see what it is doing. This document gives a guide on how to go about this.

This document contains the FAQ for OCFS.

The Rman backups for databases. These should follow a common format, which backs up the archivelogs, database and controlfiles. Logically, this should perform a backup, and then delete the previous backups which are not required. Where space is a premium, … Continue reading →

Optimal Flexible Architecture.  The Optimal Flexible Architecture (OFA) was introduced to make the management of oracle database's simpler. There are a number of rules which the database should adhere to, allowing it to be considered OFA compliant. Oracle 11g new feature: Enhanced … Continue reading →