Oracle Team

How to create an Oracle GoldenGate EXTRACT in Multitenant

Create an EXTRACT process into container database has some specificity : From the CDB$ROOT, create a common user and configure the database to be ready to extract data via GoldenGate: SQL> create user c##gg_admin identified by "*****" default tablespace goldengate(…)

Near Zero Downtime Migration and failback with GoldenGate

Oracle GoldenGate allows to migrate Oracle database with Near Zero Downtime and with failback capability. Near Zero Downtime migration means very minimal application switchover downtime. The failback consists to rollback the migration from 19c to 12c. The goal of this(…)

Oracle Data Guard : Where to Host The Master Observer

By Mouhamadou Diaw An observer is an OCI client that connects to the primary and target standby databases using the same SYS credentials you used when you connected to the Oracle Data Guard configuration with DGMGRL. The observer is(…)

Oracle 21c : Dealing with FastStartFailoverActionOnPreCalloutFailure

By Mouhamadou Diaw In a previous blog I talked about the FSFO callout scripts which is a new feature with Oracle 21c with the broker. This feature will allow to execute some tasks before and after a(…)

Active Duplicate from standby database

By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I(…)

Oracle 21c Broker : Fast-Start Failover Callout Scripts in Action

By Mouhamadou Diaw With Oracle 21c (In fact Oracle 20c), we have a nice new feature with the broker which is the Fast-start Failover Callout Configuration scripts. I talked about this feature in some presentations I did about the(…)

DctmAPI.awk revisited (part I)

In the 2-part blog article Adding a Documentum Extension to gawk, I showed how to extend the gawk scripting language in order to implement the Documentum dmAPI(…)

DctmAPI.awk revisited (part II)

This is part II of the article DctmAPI.awk revisited. See Part I here. The table presentation can be visually quite rich: it supports row colorization with optional color alternation and gridding, i.e. enclosing the table and(…)

PDB Snapshot Carousel with Oracle 21c

By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. We have seen here how the target refreshable PDB(…)

Important DBCA Parameter if you plan to use Storage Snapshot Cloning in ASM

I am currently working on a customer project to create database clones using storage snapshots. The advantages are obvious, because using a storage snapshot as a clone not only saves space, but is also extremely fast compared to a full(…)