Create RAC Standby Database Using DBCA [19c Version]
Create RAC Standby Database Using DBCA [19c Version]

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

Fixing No-logging corruption the easy way [12.2 feature]
Fixing No-logging corruption the easy way [12.2 feature]

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]
How to enable Multi Instance Redo Apply (MIRA) [12.2 feature]

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