Managing Database Load

Introduction One of the most common issues with Oracle databases that result in major business issues happen when database resources are overwhelmed with work. When this happens, some or all of the following can happen: Response time can increase to the point where no SQL operations are completing from any connected sessions, The database and […]

Just the basics; managing Oracle disk space

Introduction Here’s a quick quiz; of all of the problems that can beset an Oracle database, which one happens the most often? Do you think that it’s concurrency or locking issues? Issues with CPU being overwhelmed, or disk I/O rate being overwhelmed? Oracle internal bugs? Disk space issues? Problems encountered with backup & recovery? Account […]

Don’t Fall Into This RMAN Trap

Have you found that daily full database backups are becoming impractical for your growing databases?  Incremental backups are no longer the exception in some shops.  But with the increased complexity comes a greater responsibility for thoroughly planning and testing your backup solution.  Testing a more complicated backup solution makes for a more complicated validation procedure.  […]

Quick Reference Guide for Managing Physical Standby Databases

Using a Physical Standby database (aka Data Guard) is one of the most effective ways to protect your database and improve its availability.  My colleague Jay Stanley wrote a great blog on this subject: http://dbspecialists.wpengine.com/blog/database-backups/need-uptime-use-and-oracle-physical-standby-database/. The Standby database can be activated in the event of a disaster or it can be done for maintenance reasons, […]

crsstat in Oracle 11g doesn’t show the instances

If you are familiar with Oracle Real Application Clusters (RAC) on 10g, you have likely seen output from crsstat that looks something like this.  This is from a 10.2.0.4 two node RAC cluster.  Notice that each instance is listed (RACDB1 and RACDB3) as well as the database itself (RACDB).   [oracle@node15 ~]$ crsstat HA Resource                                   […]