My Oracle Support Banner

Primary Note: Troubleshooting Redo Logs and Archiving (Doc ID 1507157.1)

Last updated on JANUARY 22, 2024

Applies to:

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

Purpose

This document provides troubleshooting steps to resolve issues with Redo logs and Archiving i.e ORA-337, ORA-338. It also lists known issue and bugs related to Redo logs and Archiving.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Concepts
 Common Issues related to Redo logs and Archiving
 Created Archived Logs are smaller in size than the related Redolog files
 Excessive Generation of Archive Logs
 Frequent Log Switches
 Checkpoint Not Complete
 ORA- errors related to the Redo Logs and Archiving
 ORA-336 log file size <num> blocks is less than minimum <num> blocks
 ORA-337 log file <name> does not exist and no size specified
 ORA-1198 must specify size for log file <name> if RESETLOGS
 ORA-00338: log <Log_Number> of thread <thread_number> is more recent than control file
ORA-00312: online log <Log_Number> thread <thread_number>: 'redo.log'
 Further Diagnosis
References

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