Skip to content
Use the V$LOG and V$LOGFILE views to display information about the online redo log groups and corresponding members: Here is some sample output: When you are diagnosing online redo log issues, the V$LOG and V$LOGFILE views are particularly helpful. You can query these views while the database is mounted or open. The STATUS column of […]
