Database Articles
0

RMAN-06059: expected archived log not found

 
Backup will fail if an archivelog is already missing (which has never been backed up).
Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

How to find out all the nodes in an Oracle Cluster

 
Use the olsnodes command to find out all the nodes in an Oracle Cluster.
Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Check Invalid or Unusable Indexes

 
Here’s a script i use to check for invalid or unusable indexes.
Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

ORA-01450 Error Encoutered on Index Rebuild Online

 
Encountered a weird error today when I was rebuilding an unsable index.
Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

ORA-04031: unable to allocate xxxxx bytes of shared memory

 
The error means your database has run out of memory. The parameters following this error will tell you which part of the SGA has ran out of memory. Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Restore a Cluster database from Backup using RMAN

 
Database restore from backup is one of the most important DBA skills but also one of the most rarely practiced. Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Tablespace and datafile healthcheck

 
It is an unavoidable scenario to encounter server panic reboots/crashes and other miscellaneous server problems in one’s career as a DBA. These mishaps causes the database to crash and sometimes even corrupt database datafiles (especially if the underlying issues are storage related). Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Grid Control Agent log location

 
In any large organization where hundreds of Oracle databases are running, it is the norm to have a central tool to manage all of the databases. One of these tools is named Oracle Grid control. This short post is just to show the location of the Grid Control AGENT logfile (similar to alert.log for oracle databases). Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Monitoring Historical Generation of Archivelogs

 
Production database environments usually have scheduled cyclic backups for archivelogs to avoid Full archivelog destination issues. Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.

0

Undo Tablespace Monitoring

 
UNDO tablespace is special kind of tablespace in Oracle. It can grow and shrink on its own, much like the TEMPORARY tablespace. But unlike a TEMPORARY tablespace, the UNDO tablespace’s datafiles need to be online for the database to open and a corrupted/missing UNDO datafile will crash the database instance.

Read the rest of this entry »

If you need more help with database issues, feel free to send me an email (jimmycdo@yahoo.com) and I'll gladly help.