Posts Categorized: Technical Blog
How many times have we heard the assurance of storage administrators (fueled by the SAN vendor’s claims) that their top-of-the-shelf SAN arrays simply cannot fail. Unfortunately, reality proves this wrong and we see it regularly with our customers. At the moment of this writing, one of our DBA teams has just completed failover to the standby database as a result of a database crash caused by a SAN issue. Is there a silver bullet? Well, not as solution but as a concept, yes — simply admit that SANs do fail — this what should drive infrastructure design for business continuity. Actually, I should extrapolate it to another design principle — everything fails, but that’s another story.
What should you expect coming to the Hotsos Symposium 2010? It’s 3 days packed with sessions on all aspects of Oracle performance optimization whether it’s design, troubleshooting, development, methodologies and processes. Legendary Tom Kyte — who else can you expect for the keynote?! If you take an optional training day with Tanel Poder then you are likely to learn at least as much about troubleshooting Oracle database performance as you do during the conference and probably even more. Every presentation by Tanel has been an eye opener for me. If you’ve seen his material, you’d know what I’m talking about. Now, imagine that it’s not a one-hour session but the whole day! It will fry your brains so this day is for the strongest! :)
The “Beer” version of DBD::Oracle (1.24) has been released. You can find it at CPAN DBD::Oracle. DBD::Oracle is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of Pythian as Open Source/Free Software. This is largely a maintenance release that fixes a number of bugs. New stuff includes some more improvements to embedded types from Charles Jardine. Find out more here.
There are a lot of discussions going on in the Internet regarding whether we can trust third parties to look after our data. I am not going to add fuel to the fire. I am going to show you how simple it is to backup an Oracle database to the Storage Cloud using the Oracle Secure Backup (OSB) Cloud Module.
On Thursday, January 21, Pythian hosted the Ottawa Valley System Administration Guild (OVSAGE) Ottawa Valley System Administration Guild (OVSAGE). The highlight of the meeting was an interesting presentation on security by the founder of OVSAGE, Scott Murphy. The focus was on the fact that security is a mindset, not a product. Scott’s presentation can be viewed here.
Good morning and welcome to a new Blogrotate. We missed last week’s edition because last week was insanely busy. We take customer service very seriously here at Pythian, so when there is a conflict between client issue and a blog, the client always wins out. ‘Nuff said.
Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .
Unrecoverable data files are those that involve nologging operations since the last successful backup took place. There are several ways to identify them. I’ll take you through them.
This is the third post in Oracle GoldenGate Extract Internals series (links to part I and part II). In this post, we’re going to take a closer look at various queries that the Extract process uses against the database. As before, we will start by examining the strace output.
Want to contribute to your favorite CPAN module, or maybe create your own, but don’t have the foggiest idea how to do it? Here’s a few notes, tips, tricks and links that might help you get started.