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.
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 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.
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.
The absolute file number of the data file.
The SCN at data file creation.
The SCN taken when the data file was taken offline.
The online checkpoint SCN.
The online checkpoint time.
The time of control file creation.
The SCN of the most recent RESETLOGS in the data file header.