Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-19905

LOG_ARCHIVE_FORMAT must contain sequence %string, thread %string, and resetlogs ID %%r for files to be unique.

Cause

The LOG_ARCHIVE_FORMAT initialization parameter was missing a mandatory format element. Starting with Oracle Database 10g, archived log file names must contain sequence, thread, and resetlogs ID to ensure that all archived log file names are unique.


Action

Add the missing format elements to the LOG_ARCHIVE_FORMAT parameter.