What is a Redo log corruption?
In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists of redo records. A redo record, also called a redo entry, holds a group of change vectors, each of which describes or represents a change made to a single block in the database.
For example, if a user UPDATE
s a salary-value in a table containing employee-related data, the DBMS generates a redo record containing change-vectors that describe changes to the data segment block for the table. And if the user then COMMIT
s the update, Oracle generates another redo record and assigns the change a “system change number” (SCN).
So whenever Oracle throws the following error, it means that Redo is corrupted.
Continue reading “Redo log corruption”