Skip Headers
Oracle® Database Backup and Recovery Reference
11g Release 2 (11.2)

Part Number E10643-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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 join of the V$LOG and V$LOGFILE views.

Column Data Type Description
DB_KEY NUMBER The primary key for the target database. Use this column to join with almost any other catalog view.
DBINC_KEY NUMBER The primary key for the incarnation of the target database. Use this column to 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.
SITE_KEY NUMBER 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.
BYTES NUMBER The size of the file in bytes.
TYPE VARCHAR2(7) The type of redo log: ONLINE or STANDBY.