![Standby Automatic Flashback [19c feature]](https://project42.site/wp-content/uploads/2020/12/Automatic_flashback-360x240.jpg)
One of the new Database 19c Features is the possibility of automatically Flashback the standby database if the Primary has been Flashback. There are couple of requisites though, the Standby has to have Flashback enabled, and in order for the Automatic flashback to start, the standby has to be mounted Lets do a quick test... » read more
![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
![Fixing No-logging corruption the easy way [12.2 feature]](https://project42.site/wp-content/uploads/2020/08/nologging-360x240.gif)
I have recently discovered a new way to easily fix nologging corruption in a standby which version is 12.2 or higher. The first thing we need to do for this test is to disable the force logging parameter from our Primary Database db1221 > select name,force_logging from v$database; NAME FORCE_LOGGING ________ ________________ DB122 YES db1221... » read more
![How to enable Multi Instance Redo Apply (MIRA) [12.2 feature]](https://project42.site/wp-content/uploads/2020/08/MIRA_spiderman_meme-1-360x240.jpg)
Since 12.2, Managed Recovery Process (MRP) can be started on multiple instances, making Standby recovery much faster and making easier for the system to be kept on Sync with your Primary Database (Found thanks to this old post: http://jeyaseelan-m.blogspot.com/2018/05/mira-multi-instance-redo-apply-12cr2.html) This new feature is called MIRA (more info in following PDF https://www.oracle.com/technetwork/database/availability/redo-apply-2745943.pdf) The process to enable... » read more
![Rolling Forward a Physical Standby using “Recover From Service” command [12.1 feature]](https://project42.site/wp-content/uploads/2020/08/mind-gap-360x240.jpg)
This is what we can see from the Oracle Doc ID 1987763.1 regarding Recover standby from Service option added in 12.1: Rolling Forward a Physical Standby Using Recover From Service Command in 12c (Doc ID 1987763.1) ========================================================================= Prior to 12c, in order to roll forward the standby database using incremental backups you would need to:... » read more
You probably already know about the Oracle cloud free tier which include Autonomous Database and 2 VMs for free forever. Something Id dint know, is that you can actually set a second (or third) database using it thanks to Oracle XE Database and couple of memory tricks. If you don’t know about Oracle XE, please... » read more
By the time you are reading this, I would expect you don’t need this, and that you are already using your "Always Free Autonomous Database and Cloud Infrastructure"… if that is not the case, don’t worry, is never too late to start!! Just in case, lets have a look what you got for free, for... » read more