Oracle

Oracle Zero Downtime Migration : Offline logical database migration from on-premises to Autonomous DB 

I have recently written a blog introducing the Oracle ZDM (Zero Downtime Migration) tool : https://www.dbi-services.com/blog/zero-downtime-migration-zdm-to-oracle-cloud-infrastructure-oci/ I have also done some tests performing an offline logical database migration from a database running on an OCI(…)

ODA version 19.18 is available: how to patch?

Applying 19.18 patch on your Oracle Database Appliance(…)

Zero Downtime Migration (ZDM) to Oracle Cloud Infrastructure (OCI)

The question to migrate or not to the Cloud comes more and more often now. There are some added values to go to the Cloud as analytics capabilities, scalability and flexibility, cost saving, no dedicated hardware and its related maintenance,(…)

ODA vnetwork bridge with no IP address

It is not mandatory to setup an IP address on a bridge interface. A bridge forwards packets at MAC layer. But of course, if I would like to reach the DB System or the Compute Instance from the ODA, then(…)

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug  of pluggable(…)

Why you should consider keeping your ODA more than 5 years

ODA is a long-lifetime platform!(…)

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

Quering database's by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain. Templating simplify the script by taking(…)

Want to easily test Dbvisit StandbyMP for Oracle SE?

As you might know Dbvisit StandbyMP is a great Disaster Recovery solution for Oracle SE databases. Dbvisit recently communicated, providing now, a Test Drive system for customer to easily try the product and for partner to easily have a Demo(…)

Oracle TDE part II : Encrypting Data

By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests As specified before TDE(…)