Oracle

Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)

To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using(…)

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(…)