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 write the results in this blog Below the actual configuration of my Data Guard environment 1 2 3 4 5…
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 can be used as a master to provide PDB snapshots. In this blog we are going to continue in the same topic and talk about PDB Snapshot Carousel…
By Mouhamadou Diaw In a previous blog , I talked about refreshable PDB technology which can be used to refresh a target PDB. The target PDB can be in mounted state (mandatory to be refreshed) or can be opened in a read only mode. One application is to use the target refreshable PDB as a master to provide PDB snapshots.…
By Mouhamadou Diaw A refreshable clone PDB is a way to refresh a single PDB instead of refreshing all PDBs in a container as in a Data Guard environment. It consists to make a clone of a source PDB and the clone PDB is updated with redo accumulated since the last redo log apply In this blog I did some…
By Mouhamadou Diaw When creating a database in a multitenant environment we must understand how character set works for CDB and PDBS. In Oracle documentation we can find following lines -When the character set of the CDB root is AL32UTF8, PDBs that are plugged into the CDB can have a different character set from the CDB root. PDBs that you…
By Mouhamadou Diaw When deploying new Oracle Home on the same server or on a new server, you may use the downloaded Oracle binaries and do an install from scratch as usual. You may then apply any patch you have on your actually Oracle Homes. This may take time. Oracle provides tools to clone an existing Oracle Home with all…
Introduction When it comes to performance analysis on Oracle databases, everybody think about Diagnostic Pack. This is a very complete tool and it brings much more metrics than a DBA can analyze. But there is a big drawback with this tool: it’s not included in Standard Edition and it’s an option with Enterprise Edition. If you don’t have this tool,…
By Mouhamadou Diaw Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked from using these diagnostics to better support separation of duty. Indeed with Oracle 21c, we have a new mechanism to…
Last week I did some upgrade tests from 19c to 21c. The plan was to copy a 19c PDB to a CDB 21c using Online Clone and then upgrade it to 21c. I have done this many times for 19c as well and just wanted to verify that it still worked with 21c. Clone PDB to 21c CDB Since it…
Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let’s test if this new feature really works and…
By Mouhamadou Diaw Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below the addresses I am using. Note that a dns server is setup 1 2 3 4 5 6 192.168.0.101 racp1vm1.dbi.lab racp1vm1 –public network 192.168.0.103…
Oracle Blockchain Tables With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties. Database security can be improved by using Blockchain Tables to avoid user fraud and administrator fraud as well. One of the main characteristics of Oracle Blockchain…
