Monthly Archives: April 2008

Securing sensitive data from DBA Access

If we have the privileges to become SYS or SYSTEM, then we can view the data from any schema. Database vault can help us to restrict the DBA access to sensitive information. Following example shows the default behaviour (i.e. without … Continue reading

Posted in Oracle Database Vault, Oracle Security | Tagged | Leave a comment

New RMAN Compression Algorithm in 11g

We are already familiar with RMAN compression feature in 10g. As we all know, compression is CPU intensive activity. While backup is running, we can see high CPU utilization, sometimes reaching to 100%. In 24×7 environments, we do not have … Continue reading

Posted in Oracle Database Backup, Oracle Recovery Manager | Tagged | 1 Comment

Oracle Wallet & Transparent Data Encryption

These days in any organization, data protection is one of the top priorities. In fact, it’s a requirement for compliance with most laws, regulations like PCI. We can protect the database from outsiders by following means 1. Build secure public … Continue reading

Posted in Oracle Security | Tagged | Leave a comment

How to Configure Database Vault?

There are two things we’ll need for database vault configuration. 1. Installing the software component 2. Configuring the database to use vault To install the software, we can start the OUI using ./runInstaller Select the option for advanced installation Use … Continue reading

Posted in Oracle Database Vault, Oracle Security | Tagged | 7 Comments

Cold database backup in RAC environment

We can use following routine to perform a cold backup in RAC environment. #!/bin/sh # $Header: cold_database_backup.sh,v 1.0 2008/04/24 00:00:00 $ # # ————————————————————————— # Determine the user which is executing this script. # ————————————————————————— CUSER=`id cut -d”(” -f2 cut … Continue reading

Posted in Oracle Database Backup, Oracle Recovery Manager | Tagged | Leave a comment