![The New AUTO_ONLY option for USE_LARGE_PAGES parameter [19c feature]](https://project42.site/wp-content/uploads/2020/10/Screenshot-2020-10-31-at-15.08.03-360x240.png)
Setting up the memory of a Database is always a process that requires planification, specially if you want to get the maximum of your server and setup Memory Huge Pages in your Linux system, which is recommended. The concern is that other applications/processes wont be able to use that portion of memory, causing instability if... » read more
Converting a Physical Standby Database to Snapshot Standby can be of a great solution if you need to do some new code test in a system but you can’t have a full Test Clone. Also, since the standby is a block by block copy of the Primary, we are making sure the test is made... » read more
I already mentioned that Autoupgrade allows now to be used in RAC Databases, but something that was also added recently (Autoupgrade 19.9.0 if I’m not mistaken) is the capacity to upgrade a Non-CDB database and plug-in it into a higher version Multitenant Database you already have in the system. You can see the needed configuration... » read more
![Create RAC Standby Database Using DBCA [19c Version]](https://project42.site/wp-content/uploads/2020/08/Standby_DBCA_RAC-360x240.png)
DBCA evolves the same way than most Oracle Components, and since 12.2 version, you can create Standby Databases directly using DBCA. Before you start, is important to check your version limitation, so for example, 12.2 only allows single instance Databases to be created (see this article by Frank Pachot [https://blog.dbi-services.com/12cr2-dbca-can-create-a-standby-database/]), but that is not longer... » read more
![Create Single Instance Standby Using DBCA [12.2 Version]](https://project42.site/wp-content/uploads/2020/08/Standby_DBCA-360x240.png)
Since 12.2, dbca can create Standby Databases directly, but with some restrictions, like only for Single Instance Databases and only non container Databases. This has changed for each version, and since 18c, you can create the RAC Standby and they can have PDBs (will have an article about that soon 🙂 ) For this test,... » read more
![Create Standby using RMAN Duplicate [12.2 Version]](https://project42.site/wp-content/uploads/2020/08/Standby-360x240.png)
While I was starting another project, I realised I don’t have any post covering Standby Database creation. Everyone has their own way of doing things, but last time I needed to create one, this was how I ended up doing it. The Primary Database will be called TEST and run in RAC1 cluster (rac1-node1 /... » read more
Hi Arthur, before you start your journey, is important to have a good test environment where we can try any endeavour we please. As important as having an stable Test system is the possibility to recreate it on few simple steps. This chapter of our guide will show you how to make Marvin create a... » read more