Category Archives: Databases

Databases..of course there has to be databases…what would Oracle be without it….( Less arrogant? Who knows! ;-) )

Alerting on Illegal Login..Or..”Catch Me If You Can”..

We had the requirement to generate an alert whenever a user was logging into the database while bypassing the application server. Although a lot of discussion is out there of using triggers or not, I opted for a trigger due … Continue reading

Posted in Databases | Tagged , , | Leave a comment

Oracle OEM 13c Metric Collection Error..Or..”Show Me The Graphs!”

When implementing the OEM 13C version, we have a server where we house about 16 databases. Adding the first bunch of the databases went like a breeze, but when all was said and done, we had 3 databases which didn’t … Continue reading

Posted in Databases, Technical Stuff | Tagged , , | 12 Comments

Configure NetBackup For Oracle RAC..Or..”Back Me Up!”

When configuring Netbackup to backup a RAC database, we ran into the following error: 1/29/2016 3:28:02 PM – Info bphdb(pid=2717) INF – Database status is: SHUTDOWN 1/29/2016 3:28:02 PM – Info bphdb(pid=2717) INF – Database open mode is: NOT MOUNTED … Continue reading

Posted in Databases | Tagged , , | Leave a comment

Duplicate Controlfile To FRA (ASM)..Or..’Make It A Double!’

In a previous post we restored a database which was accidentally (a-hum) dropped from a Netbackup. In this procedure we focused on the restore, but this left us with a database running on only one control file. This is so … Continue reading

Posted in Databases, Technical Stuff | Tagged , | Leave a comment

Restore Oracle database from Netbackup..Or…”Gimme Back My Database!”

When switching over from regular FRA backups to Netbackup, things changed a bit in the way restores are done. At least at our site. The good news is, although the backup and scheduling is not the task of the DBA … Continue reading

Posted in Databases, Technical Stuff | Tagged , , | Leave a comment

Retrieve DBID from an Oracle Netbackup..Or..”What’s The Number Again?”

Of course we make backups. Never ever things go wrong…But when they do..It goes south real fast real soon…One of the things easily overlooked is to note down the DBID of the database. Not needed on a daily basis, but … Continue reading

Posted in Databases, Technical Stuff | Tagged , , | Leave a comment

Converting Single Instance to RAC..OR..”Just add water..”

We had the need to clone a RAC for upgrading purposes, and although the steps are quite straight forward, there are always some caveats. The steps are: – Clone the RAC (or basically one node) to a single instance. – … Continue reading

Posted in Databases, RAC, Technical Stuff | Tagged | Leave a comment