Recently I have troubleshooted a failing RMAN backups in 220.127.116.11 RAC environment. The backups failed with an error message “ORA-00245: control file backup operation failed”. The solution for the issue is simple. Here it is.
As a third person just asked me how to prepare for OCM exam in the last 2 days, I decided to make my answer publically available. I will leave you to discover the formal path yourself and give you a guideline in terms of how and how long to prepare to the exam.
This is not the first time I have run into this issue – in the past I (and who knows how many more Oracle DBAs) have had to deal with handling jobs from a different user, which usually ends up with a big error. The answer to my prayers was the undocumented dbms_ijob package, which lets me, as a DBA, deal with jobs from other users.
After a little bit more than two weeks of soaking without any issues (yay!), version 1.45_00 of DBD::Oracle has been promoted to general use as v1.46. And because some contributors have been very busy in the meantime, the next trial version, v1.47_00, is also already on its way to CPAN. This new version offers a few bug fixes (more details in the changelog excerpt below), as well as a rework of the platform-specific troubleshooting guides as POD documents. As usual, it’ll be left around for a minimum of two weeks before it gets promoted to v1.48. Happy upgrade!
This process can be used for most 11G upgrade projects. Very often a hardware got updated at the same time as a database version. In such case we migrate a database from an original location to a new server upgrading database version and sometimes changing operational system. If this is your scenario then you can use the upgrade process to minimize system’s downtime to 1 hour independently from size of the database you migrate.
This blog post is a short summary of one of our migration strategies used to migrate Oracle 10g databases to ODA balancing the requirements of minimal downtime and efforts/costs of the project.
Backup is one of the most important topics for any Oracle DBA. It is our primary responsibility to make sure that at any point in time we can recover database. Some time ago I created a survey,”Why do you use RMAN catalog DB for your Oracle DB backups?” In this blog post I am sharing the survey’s results.
SLOB on steroids v0.1 (you use it on your own risk). If you don’t know what is SLOB read here.
Interval partitioning – the ability to create partitions on the fly was introduced in 11g. When the feature came out, there were several nasty bugs. One such particular “limitation” has to do with parallel group by on the partition key. If you want to see just that part, skip towards the end, but I think reading the whole blog will offer some insights in how Oracle Parallel Query works.
First of all if you are using NFS to store Oracle database data files I strongly advice you to enable Oracle Direct NFS (DNFS) to access those files, the main reason is performance. DNFS removes a serialization point over the traditional “kernelized” NFS. However if you are not using NFS then most probably DNFS is out of interest for you and you should stop reading, but if you want to set it up lets go.