Posts by Yury Velikanov
Recently I have troubleshooted a failing RMAN backups in 22.214.171.124 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.
Friday 13 of June 2012 I was oncall Oracle DBA. I got to work on a high priority client’s request. A financial team of one of my team’s clients was executing final steps of a year closing process in their ERP production environment and had a problem.The step that I received a complain about took 2 hours and still didn’t complete. I was told that last year the same step completed in 20 minutes. Looking back I think it may be beneficial for someone of you to read how the issue has been troubleshooted and resolved. It may give you a chance to learn something or share some better diagnosing techniques with me and others. Please do not hesitate to use comments section of this blog post.
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 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.
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.
This is just a very short blog entry to inform folks that there is an open discussion group over at LinkedIn for SLOB topics of interest. The group can be accessed through the following link
This posts finalizes a few weeks work on comparing SLOB and ORION IO testing tools.