Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is the unavailability of the database being refreshed during the DUPLICATE. You first need to remove the old version of the…
This tutorial showing simple database upgrade to 26ai using traditional method and autoupgrade tool, For operational databases please properly test and plan your upgrade. https://docs.oracle.com/en/database/oracle/oracle-database/26/fppad/upgrading-oracle-database-software.html This is one from 3 Articles related to 26.1 upgrade: Step 1. Downloading software and preparing Linux Download Base Gold image from Oracle support software from latest Oracle AI Database 26ai (23.26.1) for Linux x86-64…
Introduction Oracle 26ai is not yet available on Bare Metal ODA, but it will probably be in a few weeks. For now, 26ai is available as a DB System on Oracle Database Appliance, meaning that it’s already possible to test this new version. Let’s try to migrate a 19c Bare Metal PDB to a 26ai DB System using 3 different…
I was recently setting up GoldenGate for a client when I was struck by a ORA-44001 error. I definitely wasn’t the first one to come across this while playing with grants on GoldenGate users, but nowhere could I find the exact reason for the issue. Not a single question or comment on that matter offered a solution. The problem occurs…
I’m used to work with refreshable clones in several Oracle multitenant environments. However, due to the amount of Archived Redo Log generated we never really tried to offload the the “refresh” process on the Active Data Guard Standby database. Let’s quickly check what is required to achieve this together. What is required to create a refreshable ? Well, to create…
DMK is a Database Management Kit that can be used in various database environments. It simplifies command-line tasks for Databases Administrator on Unix and Windows systems. It supports multiple databases including Oracle, MongoDB, MariaDB, and PostgreSQL. It also includes additional modules for automating RMAN backups, database duplication, and database creation.dbi-services recently released version 2.2.0, introducing significant improvements for Oracle databases with RAC/ASM and enhanced support…
Well, this blog is unfortunately reserved to DBA folk running Oracle engineered systems #Exadata, #ExaCC, #ExaCS and Oracle Multitenant database (aka. CDB) architecture. One of our #ExaCC customer has a strong DevOps focused business and heavily relies on Exadata sparse clones to quickly provision “lightweight” database clones for their development teams. As part of the move of an mission critical…
I recently asked myself this question after having been confronted with a quite challenging situation, which will be been dissected in this post. Indeed, most of the DBA are aware about several mechanism offered by the Oracle database engine to call external programs.However, we rarely have the opportunity to get deep understanding of all of them due to the broad…
I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https://www.dbi-services.com/blog/create-new-pdb-in-a-data-guard-environment-on-exacc/. And what about if I clone a PDB on the primary CDB? Let’s see. Clone PDB on the primary database Let’s clone our previous NEWPDB into NEWPDB_2 with dbaascli. oracle@ExaCC-chz1-cl01n1:~/ [MYCDB1 (CDB$ROOT)] dbaascli pdb localclone –pdbName NEWPDB –dbName MYCDB –targetPDBName…
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 database We plan to unplug the pluggable database PDB1 from PROD01 and plug it into CLNE02. Both container have TDE configured…
Introduction On Oracle Database, Multitenant feature will be turning 9 in July, but it’s not yet widely deployed as most of the databases are still running on non-CDB architecture. With 19c, Multitenant is now mature and free if you stick to a maximum of 3 PDBs per CDB. If the benefits of Multitenant are not obvious at first glance, it’s…
Introduction One of the long requested features in case of Multitenant was the possibility to create and manage a data guard configuration on pdb level. Now with the Release Update 21.6 this was finaly implemented and the name of the new feature ist called DGPDB. If you want to know more about the data guard on pdb level and how…
