|Redo log Files
The redo log files are only used for recovery.
|The redo log
files oracle RDBMS are only used for data recovery. The Oracle
server maintains online redo log files to minimize the loss of data in
the database. Thee redo log files stores redo records written from
the redo log buffer.
During a transaction, before a user
receives a "Commit complete" message, the system must first successfully
write the new or changed data to a redo log file.
SQL> select blocksize from v$log;
|SQL> select group#, sequence#, bytes, members, status
2 from v$log;
SQL> select group#, archived, status from v$log;