My Oracle Support Banner

Diagnosing Excessive Redo Generation - Limit with Nologging (Doc ID 199298.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


To help with diagnosing excessive redo generation.

First, some background on redo generation:

What is the Online Redo Log?
The most crucial structure for recovery operations is the online redo log,
which consists of two or more pre-allocated files that store all changes made
to the database as they occur. Every instance of an Oracle database has an
associated online redo log to protect the database in case of an instance

What are the contents of the Online Redo Log?
Online redo log files are filled with redo records. A redo record, also called
a redo entry, is made up of a group of change vectors, each of which is a
description of a change made to a single block in the database. For example,
if you change a salary value in an employee table, you generate a redo record
containing change vectors that describe changes to the data segment block for
the table, the rollback segment data block, and the transaction table of the
rollback segments.

Redo entries record data that you can use to reconstruct all changes made to
the database, including the rollback segments. Therefore, the online redo log
also protects rollback data. When you recover the database using redo data,
Oracle reads the change vectors in the redo records and applies the changes
to the relevant blocks.


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!

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