Browsed by
Category: 19c

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

%d bloggers like this: