RC_REDO

RC_REDO_LOG

This view lists information about the online redo logs for all incarnations of the database since the last catalog resynchronization. This view corresponds to a combination of the V$LOG and V$LOGFILE views.

Column	Datatype	Description
`DB_KEY`	`NUMBER`	The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`THREAD#`	`NUMBER`	The number of the redo thread.
`GROUP#`	`NUMBER`	The number of the online redo log group.
`NAME`	`VARCHAR2(1024)`	The name of the online redo log file.