Data Dictionary Redo Information

Information concerning online redo log files, groups, and members can be obtained by querying the data dictionary. The following views provide information about both your online redo log files and your archived redo log files:

• V$LOG Contains information about the redo logs from the control file.

• V$LOG_HISTORY Contains information concerning archived redo logs from the control file. From here you can find the System Change Number (SCN) view of the archived log files.

• V$LOGFILES This view provides the current status of all the redo logs.

• V$LOGHIST This view contains information about the redo log file history from the control file.