Replicating users and tablespaces with Oracle GoldenGate

I decided to write this blog post after reading some comments on my older posts and several online discussions where ...

Parting with ocm.rsp isn't really sweet sorrow...

Context Now that we're well into 2017, let's sit back and ask the question: "What was the best news of 2016 in the ...

A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point. 1) Set the environment to ...

How to patch an exadata (part 6) - timing

Quick links to Part 1 / Part 2 / Part 3 / Part 4 / Part 5 / Part 6 6: Timing Now that we know how to patch every ...

Oracle E-business suite: virtual host names solution for R12.2

You have seen me rant about Oracle's provided virtual hostname solution before. If you have not, check it out here. In ...

SharePlex replication between two instances on the same host

Several days ago I was asked a question about SharePlex and should verify behaviour before providing the answer. I had ...

Oracle Database 12c: PSUs vs database proactive bundle patches

Background When it comes to performing quarterly patches to the Oracle database the options used to be pretty straight ...

ORA-30926 while using impdp over a database link

Background The other day I was doing an import using impdp in 12.1.0.2, and received the following error:'ORA-30926: ...

Oracle service secrets: group and filter

At the KSCOPE16 conference in Chicago I recorded a two minute tech-tip with Bob Rhubart of OTN about adding services to ...

Reading execution plans for parallel DML

Introduction: Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post ...

ORA-01156 when adding standy redo log in dataguard configuration

Database version = 11.2.0.3.0 If you get following error while adding a Standby Redo Log (SRL) to a standby database in ...

Truncates and sequences replication in Oracle GoldenGate

We use the terms DDL and DML in our DBA life with Oracle all the time. The first stands for Data Definition Language ...

What's eating my database? Where to focus performance efforts using Oracle AWR

Defining the Gold Standard: Average Active Sessions (AAS) Traditional methods would include looking at CPU, load and ...

ASM 12c : how to rename a Diskgroup

The first time I was asked to rename a diskgroup, I thought that it would be a trivial operation, but what should be an ...

Analyze index validate structure - the dark side

Recently, a co-worker encountered a significant performance hurdle after a database upgrade. The plan included ...

Add space to tablespace - corrective action in OEM 13c

OEM 13c came out with a good new feature as a corrective action to add space to tablespaces. It could be done in OEM ...

AWS DMS tips for Oracle migrations

Investigating IO performance on Amazon EC2

I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

ASM disk group just will not mount

I recently had an issue involving a damaged ASM disk group. Each time an attempt was made to mount the disk group it ...

Backup Oracle databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take ...

Enabling achivelog mode in 12c RAC database

Distinguish real SQL execution plans from fake ones!

As an Oracle DBA, one of our daily tasks is to optimize bad SQL statements that are affecting the system and causing ...

ASMCMD> a better DU, version 2

Benefits of ASMDU A while ago, I posted a better "du" for asmcmd . Since then, Oracle 12cR2 beta has been released but ...

The getMOSPatch V2 is here!

A while ago I created a Bash script called getMOSPatch.sh. Its purpose was to allow downloading Oracle patches directly ...

How to Install a brand new Exadata X5 (part 2)

Now that all the prerequisites have been performed in Part 1, we can now jump in the Exadata installation procedure ...

Investigating IO performance on Amazon RDS for Oracle

I've recently been involved in quite a few database migrations to Oracle RDS. One thing that I had noticed when dealing ...

GoldenGate 12.2 big data adapters: part 4 - HBASE

This is the next post in my series about Oracle GoldenGate Big Data adapters.

How to install a brand new Exadata X5 (Part 1)

When you buy an Exadata machine, you can ask Oracle to proceed with the installation or let some brilliant DBAs like ...