The online redo log is a set of two or more online redo log files that record all changes made to the database, including both uncommitted and committed changes. Redo entries are temporarily stored in redo log buffers of the system global area, and the background process LGWR writes the redo entries sequentially to an online redo log file. See Also: redo log, system global area (SGA), background process, log writer process (LGWR)
The online redo log is a set of two or more files that record all changes made to Oracle datafiles and control files. Whenever a change is made to the database, Oracle generates a redo record in the redo buffer. The LGWR process flushes the contents of the redo buffer into the online redo log. The current online redo log is the one being written to by LGWR. When LGWR gets to the end of the file, it performs a log switch and begins writing to a new log file. If you run the database in ARCHIVELOG mode, then the archiver process or processes copy the redo data into an archived redo log. See Also: archived redo log
The online redo log is a set of two or more files which record all changes made to Oracle data files and control files.
(1) Redo log files that have not been archived, but are either available to the instance for recording database activity or are filled and waiting to be archived or reused. (2) A set of two or more online redo log files that record all committed changes made to the database.
A set of two or more files that records all changes made to datafiles and control files. Whenever a change is made to the database, the Oracle database server generates a redo record in the redo buffer. The LGWR process flushes the contents of the redo buffer into the online redo log. Every database must contain at least two online redo log files. If you are multiplexing your online redo log, LGWR concurrently writes the same redo data to multiple files. The individual files are called members of an online redo log group. See also archived redo log, current online redo log, redo log, and standby redo log