![Creating a Standby on 21c [Single Instance]](https://project42.site/wp-content/uploads/2021/09/Standby_DBCA_21c-360x240.png)
For this post, I just wanted to test the same DBCA option we saw in the past to create Standby but this time on 21c. The first thing I have to clarify is that I will be using rac1-node1 to host the 21c primary database (cdb21) and rac1-node2 to host our new Standby (cdbst21). The... » read more
![A warning about DG Broker “PREPARE DATABASE FOR DATA GUARD” command on 21c [21.3 version]](https://project42.site/wp-content/uploads/2021/09/21c-Data-Broker-360x240.png)
One of the new features of 21c Data Guard Broker is the ability to prepare a Database for Dataguard Configuration running a simple command. It is very handy feature since DG broker will enable Archive Mode, restart the database, create the Standby Redo logs, etc.. Before you use it though, please be aware of some... » read more
![Installing Oracle 21c Database on Linux [Single Instance]](https://project42.site/wp-content/uploads/2021/08/21c-246x240.jpeg)
After some time of been available on the cloud, 21c Database is now ready to install on premises (Linux version for now) @GeraldVenzl – Aug 13 You can read more about it from the usual suspects like Mike’s blog: Oracle Database 21c is available for download on Linux The first thing we need to do... » read more
I got inspired by this post Do you NID to rename an Oracle DB on ASM? by Rodrigo Mufalani to try DBNEWID Utility and rename some Databases at home. These are the different actions I will perform: System Details Remove Cluster options DBNEWID Utility Execution Complete DBNAME and DB_UNIQUE_NAME change Add Database to Clusterware Move... » read more
I posted recently How to Convert Non-CDB to PDB using Autoupgrade but I thought was good to know how it was done before Autoupgrade and also, to see how to do it in case you dont want to use Autoupgrade (even though I really reocmend it, is much more simple and specially easy to scale... » read more
If you didn’t hear it enough already, Multitenant and Pluggable Databases (PDBs) are here to stay. In fact, 21c (already here for Cloud users) is already the first "Only Multitenant" Version. So, what do you do with all those Non-CDB systems you didn’t want to convert to PDB? Easy, just Migrate them to your CDB.... » read more
When I created my RAC lab, I decided to create my 19c Databases ORACLE_HOME using the name "../19.3.0/dbhome_1" since it was 19.3 version, but of course, after last patching when I updated the system to 19.7, that didn’t make much sense. I tried to follow the document How to move RAC Database ORACLE_HOME from one... » read more
Is always nice to have some test systems where you can do testing and even find some inconsistencies between system versions behaviour, specially when we talk about new features. I recently watched a video from the fantastic channel Oracle Database Upgrades and Migrations related to Online Datafile movement which started in 12c For some reason... » read more
Since 11g is not longer supported, there are high chances people are looking for different and easy ways to upgrade their old Databases to a supported version. If that is the case, there is no easiest method than Autoupgrade. Now, with the latest version (at the time of writing this is version 21.1.2 / date... » read more