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 join of the V$LOG and V$LOGFILE views.
The primary key for the target database. Use this column to join with almost any other catalog view.
The primary key for the incarnation of the target database. Use this column to join with RC_DATABASE_INCARNATION.
The DB_NAME of the database incarnation to which this record belongs.
The number of the redo thread.
The number of the online redo log group.
The name of the online redo log file.
Primary key of the Data Guard database associated with this file. Each database in a Data Guard environment has a unique SITE_KEY value. You can use SITE_KEY in a join with the RC_SITE view to obtain the DB_UNIQUE_NAME of the database.