My Oracle Support Banner

Starting Primary Database Crashes Or Hangs On "Redo Transport Attach" Wait (Doc ID 3041722.1)

Last updated on SEPTEMBER 19, 2024

Applies to:

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

Symptoms

In a RAC + Data Guard environment, when opening the primary database, the foreground process executing "ALTER DATABASE OPEN" (usually the CRSD agent) may hang at the "Redo Transport Attach" wait. After waiting for 240 seconds, this process may be killed by the TMON process, which can lead to the entire database crashing.

Here is a case from a 5-node database running on Oracle 19c.

Instance 5:

 

Changes

None.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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