RC_DATAFILE

This view lists information about all datafiles registered in the recovery catalog. It corresponds to the V$DATAFILE view. A datafile is shown as dropped if its tablespace was dropped.

Column	Datatype	Description
`DB_KEY`	`NUMBER`	The primary key for this database in the recovery catalog. 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.
`TS#`	`NUMBER`	The number of the tablespace to which the datafile belongs. The `TS#` may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
`TABLESPACE_NAME`	`VARCHAR2(30)`	The tablespace name. The name may exist multiple times in the same incarnation if the tablespace is dropped and re-created.
`FILE#`	`NUMBER`	The absolute file number of the datafile. The same datafile number may exist multiple times in the same incarnation if the datafile is dropped and re-created.
`CREATION_CHANGE#`	`NUMBER`	The SCN at datafile creation.
`CREATION_TIME`	`DATE`	The time of datafile creation.
`DROP_CHANGE#`	`NUMBER`	The SCN recorded when the datafile was dropped. If a new datafile with the same file number is discovered, then the `DROP_CHANGE#` is set to `CREATION_CHANGE#` for the datafile; otherwise the value is set to `RC_CHECKPOINT.CKP_SCN`.
`DROP_TIME`	`DATE`	The time when the datafile was dropped. If a new datafile with the same file number is discovered, then the `DROP_TIME` is set to `CREATION_TIME` for the datafile; otherwise the value is set to `RC_CHECKPOINT.CKP_TIME`.
`BYTES`	`NUMBER`	The size of the datafile in bytes.
`BLOCKS`	`NUMBER`	The size of the datafile in blocks.
`BLOCK_SIZE`	`NUMBER`	The size of the data blocks in bytes.
`NAME`	`VARCHAR2(1024)`	The datafile filename.
`STOP_CHANGE#`	`NUMBER`	For offline or read-only datafiles, the SCN value such that no changes in the redo stream at an equal or greater SCN apply to this file.
`STOP_TIME`	`DATE`	For offline normal or read-only datafiles, the time beyond which there are no changes in the redo stream that apply to this datafile.
`READ_ONLY`	`NUMBER`	`1` if the file is read-only; otherwise `0`.
`RFILE#`	`NUMBER`	The relative file number of this datafile within its tablespace.
`INCLUDED_IN_DATABASE_BACKUP`	`VARCHAR2(3)`	Indicates whether this tablespace is included in whole database backups: `YES` or `NO`. The `NO` value occurs only if `CONFIGURE EXCLUDE` was run on the tablespace that owns this datafile.
`AUX_NAME`	`VARCHAR2(1024)`	Indicates the auxiliary name for the datafile as set by `CONFIGURE` `AUXNAME`.
`ENCRYPT_IN_BACKUP`	`VARCHAR2(3)`	`YES` if this datafile has been configured to be transparently encrypted when backed up; otherwise `NULL`.
`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.
`DB_UNIQUE_NAME`	`VARCHAR2(512)`	The `DB_UNIQUE_NAME` of the database incarnation to which this record belongs. All databases in a Data Guard environment share the same DBID but different `DB_UNIQUE_NAME` values. The value in this column is null when the database name is not known for a specific file. For example, rows for databases managed by versions of RMAN before Oracle Database 11g are null.
`FOREIGN_DBID`	`NUMBER`	Foreign DBID from which this data file came from. The value is `0` if this file is not a foreign database file.
`FOREIGN_CREATION_CHANGE#`	`NUMBER`	Creation SCN of a foreign datafile. The value is `0` if this file is not a foreign database file.
`FOREIGN_CREATION_TIME`	`DATE`	Creation time of a foreign datafile. The value is `0` if this file is not a foreign database file.
`PLUGGED_READONLY`	`VARCHAR2(3)`	`YES` if this is a transported read-only foreign file; otherwise `NO`.
`PLUGIN_CHANGE#`	`NUMBER`	SCN at which the foreign datafile was transported into the database. The value is `0` if this file is not a foreign database file.
`PLUGIN_RESETLOGS_CHANGE#`	`NUMBER`	The SCN of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is `0` if this file is not a foreign database file.
`PLUGIN_RESETLOGS_TIME`	`DATE`	The time of the `RESETLOGS` operation for the incarnation into which this foreign file was transported. The value is `0` if this file is not a foreign database file.