High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center