Skip Headers
Oracle® Database Backup and Recovery Reference
12c Release 1 (12.1)

E17631-15
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
PDF · Mobi · ePub

RC_OFFLINE_RANGE

This view lists the offline ranges for data files. It corresponds to the V$OFFLINE_RANGE view.

An offline range is created for a data file when its tablespace is first altered to be offline normal or read-only, and then subsequently altered to be online or read/write. No offline range is created if the data file itself is altered to be offline or if the tablespace is altered to be offline immediate.

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.
RECID NUMBER The record identifier for the offline range from V$OFFLINE_RANGE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
STAMP NUMBER The stamp for the offline range from V$OFFLINE_RANGE. RECID and STAMP form a concatenated primary key that uniquely identifies this record in the target database control file.
FILE# NUMBER The absolute file number of the data file.
CREATION_CHANGE# NUMBER The SCN at data file creation.
OFFLINE_CHANGE# NUMBER The SCN taken when the data file was taken offline.
ONLINE_CHANGE# NUMBER The online checkpoint SCN.
ONLINE_TIME DATE The online checkpoint time.
CF_CREATE_TIME DATE The time of control file creation.
RESETLOGS_CHANGE# NUMBER The SCN of the most recent RESETLOGS in the data file header.
RESETLOGS_TIME DATE The time corresponding to RESETLOGS_CHANGE#.
OFFR_KEY NUMBER