by XTIVIA | Jan 22, 2013 | Blog, Data Management, Databases
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...
by XTIVIA | Dec 12, 2012 | Blog, Data Management, Databases
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...
by Doug Groves | Nov 28, 2012 | Blog, Databases
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...
by Tony Salerno | Jul 25, 2012 | Blog, Databases, Perspectives
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...
by XTIVIA | Sep 21, 2011 | Blog, Databases
Assuming you don’t know anything literally about the Oracle Real Application Clusters (RAC) environment, You should start with: 1. Database version, O/S version, how many nodes, tns names, listener information? 2. Database Size, Storage architecture, raid/ASM...
by XTIVIA | Jun 4, 2011 | Blog, Databases
Is your company considering using CommVault’s Simpana Backup software to backup your database’s and other applications? I am a certified CommVault Software Engineer and also an Oracle Certified (OCP) 10g Database Administrator. Having previously worked for...
by XTIVIA | Jun 1, 2011 | Blog, Databases
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...
by XTIVIA | May 9, 2011 | Blog, Databases
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...