Search notes:

Oracle: redo log sequence

The redo log sequence is an ever increasing number that uniquely identifies each redo log file.
The log sequence is increased when a log switch is performed.
The current sequence number is stored in the control file.
If the database is opened with resetlogs, the sequence number is reset to 1.

See also

The SQL Statement flashback database allows to rewind a database to a given log sequence number.

Index