Browsed by
Author: Pieter Van Puymbroeck

I am an Oracle dba started in Oracle 9i. I am currently working as a Senior Oracle DBA at Exitas NV . Check their twitter handle ( @Exitas_BE ) some nice things are shared through there as well. Most of the time I work on short term projects which put me in touch with a lot of different aspects of the Oracle database, going from infrastructural point to complete designs and implementations, the result of this is a nice allround experience and a broad personal network. Currently the focus is on Exadata/ODA and virtualisation on exadata. Exadata experience starting from X2 to X7 including complete reinstallation’s and redesigns of the environment. My main focus is to help the customer to find the best solution fitting in his budget and offer the maximum out of it given restrictions. That sometimes requires taking an exam. My most relevant badges are also here on my badges page at http://vanpupi.stepi.net/badges/. The bit of free time there is left, is mostly spent on being husband and a dad for my son. The time left I like to spend with sailing and playing the double bass, bass guitar and the saxophone. You can find me on twitter : @vanpupi or find me on about.me
Connectstrings in the OCI

Connectstrings in the OCI

Under the category; asked and answered. When you have created a Data Guard config, the most obvious is that you eventually would like to connect to the Database. This is done using a connect string, often specified in tnsnames.ora or via jdbc-thin. When you read this blog post, then you end up with a Primary and Standby database. One of the questions I got last week “How can we add 2 service names in the same connect string”? I was…

Read More Read More

DBMS_ROLLING explained

DBMS_ROLLING explained

Active Data Guard is more than just the Read-Only Standby database. Together with your Active Data Guard license comes the “Rolling Upgrade using Active Data Guard” Feature, better known as DBMS_ROLLING. If you search this blog for Transient logical standby, you can find it here. But DBMS_ROLLING is way easier. The principle remains the same: Create the guaranteed restore point Build the logminer dictionary Convert the physical standby to a logical standby Upgrade the logical standby Start the apply again…

Read More Read More

19c DML redirection and Far Sync Performance

19c DML redirection and Far Sync Performance

The 19c DML redirection is one of the key features in Active Data Guard 19c. This means that a lot of questions are coming to my e-mail for this one. This blogpost will indicate how the 19c DML redirection feature works together with the Oracle Active Data Guard Far Sync instance and how this impacts performance. The 19c New features guide, which you can find here, describes this feature as follows: Incidental Data Manipulation Language (DML) operations can be run…

Read More Read More

PDBs and role transitions

PDBs and role transitions

Now, we currently do not have per-PDB role transitions. Nevertheless, it is possible to move one PDB to another CDB. However, what if the other CDB is located at the DR site and you don’t want to copy all the data over the network again? Well, this is possible! For this to work, we need 2 CDB’s. One primary in Site A protected by a Standby CDB in Site B. The second CDB is primary in Site B and protected with…

Read More Read More

To CDB or not to CDB, that’s the question

To CDB or not to CDB, that’s the question

A product manager has several parts on the job. You can do outbound PM, that is what you, the readers or public, see. But we have also an inbound task. One of the things we do is answer internal questions and advise on how to use the product. This question is coming from a colleague who is doing an upgrade at a customer and facing some strange things with the move from non-cdb towards a cdb. On My Oracle Support…

Read More Read More

A walkthrough the Transient Logical Standby

A walkthrough the Transient Logical Standby

This blog post is created because I got some questions in the last weeks about upgrading using Data Guard. For migration to the cloud we now have Oracle Move and ZDM ( https://www.oracle.com/database/technologies/cloud-migration.html and https://www.oracle.com/database/technologies/rac/zdm.html) Check them out as well! Data Guard is meant as a Disaster Recovery (DR) solution, but to leverage the usage, one of the things it is often used for is also migrations. My colleague Mike Dietrich ( https://mikedietrichde.com ) can tell you all the differences between upgrade and migration,…

Read More Read More

Is your PDB state saved?

Is your PDB state saved?

This might save you a couple of minutes if you wonder how multitenant works in combination with Oracle Data Guard. The question I got was, is your PDB state saved after a switchover? The short answer is: Yes it is. No statements without proving them of course, so here we go. The primary database: I have the state of my pub always saved in my post creation script, but you can easily retrieve in what state the PDB will be…

Read More Read More

Data Guard made easy

Data Guard made easy

Sometimes I hear stories about struggles to setup Data Guard correctly. It should not be hard. There are lots of ways which lead to a correct setup. Die hards prefer the manual or own scripted way. Other people prefer the point and click method in Enterprise Manager. But one way, which is very easy, and I don’t hear people speaking a lot about it, is using the Database Creation Assistant (dbca).

%d bloggers like this: