Adding Online redo log groups to primary and standby
-- Version info
DB version: 19.11
OS : RHEL 8.10
-- DB Details
2-Node RAC Primary DB with standalone Standby DB (Dataguard)
Multitenant
Using ASM on SSD disks
Flashback logging enabled
I have 2-Node RAC DB as primary with a standbalone pysical standby DB (Active Dataguard).
I use broker to manage the Dataguard setup.
Standby Redo logs on both primary and standby are in N+1 configuration as per Oracle's recommendation.
Currently, the redo log size is 1 GB with 10 groups for each thread (2 threads).
The Online redo logs are multiplexed across 2 diskgroups.
Issue description:
Now, in primary DB, due to frequent 'log file sync' waits and 'Checkpoint not complete' errors in alert log, I want to add 5 more redo log groups.