Oracle Database Corruption ORA-00600

The other day our monitoring system had thrown a couple of alerts for a client. It was reporting there were errors in the client’s alertlog. I logged in and checked the alertlog and sure enough there were multiple dreadred ORA-00600 errors being reported in the...

Failed Oracle Backup via Expdp

Recently I received a call concerning failing backup jobs being taken via Expdp. I logged in to our Virtual-DBA client’s site and immediately checked the alertlog for errors. The below errors were found in the alertlog. Exporting orcl on DBHOST01 Sun Dec 16...

Ensure your RMAN backups are functional

To me making sure your database is backed up is the most important task for a dba.  But not only is it backed up, but it’s backed up correctly. I just encountered a situation where a client started receiving numerous errors in their production system.  There...

Have enough DBAs?

How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment?  All your organization’s databases need to be kept operational and properly tuned, which probably requires around the clock...

ORACLE: Upgrade to 11gR2 – Migrate to ASM

11gR2 Upgrade: Recently, I had a customer who needed to upgrade their database to 11gR2 from 10.2.0.3.  The upgrade needed to move the database from a cooked file system to Oracle’s ASM. Additionally, the customer wanted to have Oracle Enterprise Manager...
Oracle Data Pump: Interactive Mode – Attach/Detach

Oracle Data Pump: Interactive Mode – Attach/Detach

Recently, I had a customer who was importing a long running Data Pump import job.  The client needed to go home and still have a way to monitor the import job. Starting with Oracle 10g Data Pump there is a useful feature in situations in which you start a job at...