My Oracle Support Banner

Known Issues and Recommendations related to MIRA from 12.2 Onwards (Exadata and Non Exadata environment) (Doc ID 2678711.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

This Document lists down known issues related to MIRA and few recommendation when using it on Exadata .

Starting with Oracle Database 12.2, Multi-Instance Redo Apply (MIRA) greatly improves scalability of redo apply for
Oracle RAC databases. Instead of merging all threads of redo into a single apply process, multiple apply instances
divide the threads of redo between the apply instances. For example, when two apply nodes are used to apply four
threads of redo from the primary, each apply instance will apply two threads.


Important :- In Rac database it is recommended  to use single instance redo apply (SIRA) instead of MIRA when online patching for RAC rolling upgrade is in progress.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.