Command Line Interfaces (CLIs) in the Oracle Cloud

Introduction Oracle offers the Cloud Console, which is an easy to use web-based interface to create and manage all Oracle cloud resources. However, in many use cases it is more efficient to do your tasks programmatically using command line tools instead of clicking on every button in the web browser manually: Provision and terminate the…

Real-time Data Replication between Oracle Autonomous Databases using Oracle GoldenGate

Introduction Oracle GoldenGate is a software product that allows you to replicate, filter, and transform data from one database to another in real-time. It can be used to migrate databases with (near) zero downtime. As logical replication, source and target databases could be of different versions, platforms, and character sets. Even many non-Oracle databases are supported.…

Create PDBs in a Data Guard Environment with TDE enabled

Introduction See what happens and how to proceed after creating or cloning a PDB in a Data Guard environment while Transparent Data Encryption (TDE) is enabled. If you are new to TDE, have a look at this blog first. The Environment I’m using Oracle Database Cloud service Enterprise Edition Extreme Performance. The database version is 19.8. TDE…

Do I need the Advanced Security Option on-premises for Hybrid Cloud Disaster Recovery?

In the case of hybrid disaster recovery and having an unencrypted database on-premises, you can create the corresponding unencrypted standby database in the cloud using RMAN DUPLICATE or RESTORE from Object Storage. When you create a new unencrypted tablespace on the on-premises primary database, the standby database in the cloud creates the corresponding unencrypted tablespace via redo. So everything is fine and you…

Is the Multitenant Option mandatory in the Oracle Cloud?

No, not necessarily. All Oracle databases from version 12.1 in the Oracle Cloud are automatically deployed using the Multitenant architecture. This is probably the reason why this question is asked. Let’s have a deeper look. Database Cloud Service (DBCS) License Included For EE-HP and EE-EP, you can create up to 4096 PDBs. For SE and…

Can I use fewer CPUs on Data Guard Standby to save costs?

One of the most beneficial cloud features is scalability on-demand, paying only for what you use, and releasing the resources when not needed anymore. So the question is, could I configure the standby database to use fewer CPUs than the primary to save costs? Yes, BUT… you have to consider a few things! Oracle Cloud provides…