Desaster recovery in a nutshell for Oracle Database 10gR2

The article gives a brief overview how to restore and recover an Oracle database. Of course its a requirement to have a working rman backup of the database. We start at the point where the database is lost and we need to restore it from scratch using the backup files. In this scenario we use a controlfile and not a catalog database. Before you begin you need to make sure that the failed storage is available again and the directories and permissions are created and granted. 

Using direct I/O and the solaris dtrace tool

Using Solaris Dynamic Tracing (dtrace) can help to eliminate hotspots on files and give an insight to your system. Oracle ported dtrace to Oracle Linux which makes it just more interesting. This article gives a quick start using the dtrace facility and direct I/O. The detailed dtrace description can be found in its documentation.

Security aspects of an APEX-installation

The many advantages of using Oracle APEX may cause a department to consider using it for human resourc applications or for other sensitive company data. Then there is a question of security that arises. This article describes the security aspects of different types of installations in a production environments as well as important APEX security and configuration concepts.

Oracle 11gR2 Clusterware OCR and voting disks recovery

Problem:

After the accidentally deletion of the diskgroup DATA the Oracle cluster stack does not start on any node. The Oracle Cluster Registry (OCR) and voting disks are lost. The article shows how to recover them both.

[root@rac2 ~]# ocrcheck
PROT-602: Failed to retrieve data from the cluster registry
PROC-26: Error while accessing the physical storage ASM error [[clsuSlosFormatDiag called with non-error slos.]
] [0]
[root@rac2 ~]# crsctl query css votedisk
Located 0 voting disk(s).