Total Recall by DUDE: Extracting Oracle Data After RAID Corruption

Last Friday, a customer paged me to say that they could not open an Oracle 8.0.5 database after the RAID array crashed. It turned out that this database was in NOARCHIVELOG mode and there was not even a cold backup. Furthermore, they didn’t even have a database export. it was definitely the time to recall Kurt Van Meerbeeck and his all-time-hit tool — the DUDE. DUDE stands for Database Unloading by Data Extraction. The client was very impressed by how we were able to recover from a deadly situation like that, and it was only possible thanks to the DUDE and his creator: thanks a lot Kurt.

How Will 11g Change Oracle Datacenters?

Let’s focus on what 11g is all about. The main message I got is that Oracle 11g is the consumer release. According to Mr. Phillips, what this means is that Oracle has listened to its clients and has worked in the areas that the consumers needed the most. The fact that Ari Kaplan, the president of the IOUG, was on stage during the launch speaks for itself. As for what’s new in 11g, three major features come to mind…

SELECT COUNT(*) FROM Tab -> No Rows Selected

n the following SQL*Plus output something is goofed up. You should not have a no rows selected with this SQL. When you see something like that for the first time, you can generally draw from four conclusions: Someone edited the output, SQL*Plus bug, Oracle bug, combination of the above. Since it was me who saw this, number one was an easy but irrelevant answer. What about an SQL*Plus bug? OK, run this using some other ad hoc tool. Same result. Time to take a more precise look at the problem. What is trans?

Postscript to “An Open Letter to Larry Ellison”

Last week, in collaboration with several of my colleagues here at Pythian, I published an open letter to Larry Ellison. The response to this letter has been — well — surprising, both in volume and in character. It is clear that many in the Oracle community seem to share the sentiments that we have expressed. In fact, we know that we are not alone in this endeavour.

Oracle Releases Method to Disable AWR Collection

As you might imagine, the traffic to the open letter from the domain has been spiking in the last few days. Two days ago, in fact, Christo received an email from Oracle putting into question the fact that AWR data collection could not be disabled without a license to the diagnostic pack, and promptly forwarded that note to me. So as it turns out, Oracle has been working on a package to disable the AWR data collection without requiring a license for at least two months. But as of yesterday, it had not yet been published.

An Open Letter to Larry Ellison on AWR and ASH Licensing

15 years ago, with the release of Oracle 7.0.12, Oracle gave the world—or at least its customers—something really great: the Oracle Wait Interface (OWI). We believe that the Oracle database software is the best instrumented database software available. The fact that Oracle already leads the industry in this regard probably led to their decision to make this leap forward in instrumentation an extra-cost item. However, in the interest of making Oracle even better, we would like to invite readers to join us in signing the following open letter to Larry Ellison, CEO of Oracle Corporation.

Page 244 of 284« First Page...10...242243244245246...250...Last Page »