Researching a Bug

A few months ago we hit an Oracle bug related to streams replication crash after creating an index (bug 21320182). There is a patch so we installed the patch in test and it seemed to solve the problem, but we never patched the production. Today we hit this issue in production after creating an index … Continue reading Researching a Bug

Datapach issues

This week I worked on a messy patch. I have a RAC environment with 12.1.0.2 and an old PSU and all kind of one-off patches and I wanted to install the latest PSU (180417). It sounds simple, but it’s not so simple. The thing is that I have 4 database running from the same ORACLE_HOME, … Continue reading Datapach issues

V$LOCK Missing Information

In our first BCOUG Tech Day conference, I presented my session “Look Inside the Locking Mechanism”. I presented this topics before a few times and prepared a few demos to show different locking scenarios. During the BCOUG Tech Day I did the same, while the only difference was that for the demo I used Oracle … Continue reading V$LOCK Missing Information

BCOUG Tech Day 18 Summary

On April 27th (2018) we had our first BCOUG Tech Day conference! If you are reading this and you’re part of an OUG board, you know how stressful and how much work it is to organize such an event. But the bottom line: it was very successful! I decided to write this post for a … Continue reading BCOUG Tech Day 18 Summary

Did You Know #26 – Restoring Standby Control File

If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs even though the database was consistent. Apparently, there is a  restore option that I wasn’t aware of in RMAN. When I restored the control file … Continue reading Did You Know #26 – Restoring Standby Control File

Restore Standby Database

Over the years I ran into all kind of weird and wonderful backup and restore scenarios. This case has challenged me for a while now and I finally had the chance to check it properly and figure out what’s going on. So here is the story. The environment This client has a few database, some … Continue reading Restore Standby Database

Did You Know #25 – Archives in FRA

One of my clients is restoring their database backup to another server for some testing. They do it periodically so we can also verify that the backup is good (which is great!). In a few cases, after the restore I saw that the restored database has an incarnation that the original database doesn’t have (and … Continue reading Did You Know #25 – Archives in FRA

Did You Know #24 – Blocked Instances

Even after years of working with something, you can always learn new stuff. Today I tried to create a standby database using the duplicate command. When you duplicate a database you need to connect to both instances (primary as target and standby as auxiliary) using SQL*Net (and not “/”). Since the standby is in nomount, … Continue reading Did You Know #24 – Blocked Instances

Tool to Assist with Basic SQL Analysis

I just came back from RMOUG Training Days conference. It was my first time in Colorado (and obviously my first RMOUG training day) and it was really great (I wrote about it in another post). During my second session (From 4 Minutes to 8 Seconds – about a real SQL tuning case I had quite … Continue reading Tool to Assist with Basic SQL Analysis

RMOUG Training Days 2018

This year was the first time I attended (and spoke) at RMOUG Training Days. Last year I submitted a few sessions but they were rejected. This year I had the honor of having 2 of my sessions accepted to the conference. Let’s start in a chronological order. Pre-Conference and arrival This year, the conference had … Continue reading RMOUG Training Days 2018