My Oracle Support Banner

ORA-313 Occurs Repeatedly in rsm Process on Standby Database (Doc ID 3034312.1)

Last updated on JULY 27, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

ORA-313 occurs repeatedly in rsm process on standby database.

alert log on standby database:

2024-07-08T13:07:39.771047+09:00
Errors in file <PATH>/trace/<SID>_rsm0_6977.trc:
ORA-00313: open failed for members of log group 10 of thread 0
2024-07-08T13:07:39.773806+09:00
Errors in file <PATH>/trace/<SID>_rsm0_6977.trc:
ORA-00313: open failed for members of log group 11 of thread 0
2024-07-08T13:07:39.776763+09:00
Errors in file <PATH>/trace/<SID>_rsm0_6977.trc:
ORA-00313: open failed for members of log group 12 of thread 0
2024-07-08T13:07:39.778587+09:00
Errors in file <PATH>/trace/<SID>_rsm0_6977.trc:
ORA-00313: open failed for members of log group 13 of thread 0

Changes

Add REDO member to REDO group on standby database.

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


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