RC_DATAFILE

5.30 RC_DATAFILE

This view lists information about all data files registered in the recovery catalog. It corresponds to the V$DATAFILE view.

A data file is shown as dropped if its tablespace was dropped.

Column	Data Type	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.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: 0: Rows containing data that pertain to the entire multitenant container database (CDB) 1: Rows containing data that pertains only to the root n: Where n is the applicable container ID for the rows containing data
`PDB_NAME`	`VARCHAR2(31)`	Name of the pluggable database (PDB) in the recovery catalog.
`PDB_KEY`	`NUMBER`	The primary key for this PDB in the recovery catalog.
`PDBINC_KEY`	`NUMBER`	The primary key for the incarnation of the PDB.
`TS#`	`NUMBER`	The number of the tablespace to which the data file 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 data file. The same data file number may exist multiple times in the same incarnation if the data file is dropped and re-created.
`CREATION_CHANGE#`	`NUMBER`	The SCN at data file creation.
`CREATION_TIME`	`DATE`	The time of data file creation.
`DROP_CHANGE#`	`NUMBER`	The SCN recorded when the data file was dropped. If a new data file with the same file number is discovered, then the `DROP_CHANGE#` is set to `CREATION_CHANGE#` for the data file; otherwise the value is set to `RC_CHECKPOINT.CKP_SCN`.
`DROP_TIME`	`DATE`	The time when the data file was dropped. If a new data file with the same file number is discovered, then the `DROP_TIME` is set to `CREATION_TIME` for the data file; otherwise the value is set to `RC_CHECKPOINT.CKP_TIME`.
`BYTES`	`NUMBER`	The size of the data file in bytes.
`BLOCKS`	`NUMBER`	The size of the data file in blocks.
`BLOCK_SIZE`	`NUMBER`	The size of the data blocks in bytes.
`NAME`	`VARCHAR2(1024)`	The data file name.
`STOP_CHANGE#`	`NUMBER`	For offline or read-only data files, 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 data files, the time beyond which there are no changes in the redo stream that apply to this data file.
`READ_ONLY`	`NUMBER`	`1` if the file is read-only; otherwise `0`.
`RFILE#`	`NUMBER`	The relative file number of this data file 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 data file.
`AUX_NAME`	`VARCHAR2(1024)`	Indicates the auxiliary name for the data file as set by `CONFIGURE` `AUXNAME`.
`ENCRYPT_IN_BACKUP`	`VARCHAR2(3)`	`YES` if this data file 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 data file. The value is `0` if this file is not a foreign database file.
`FOREIGN_CREATION_TIME`	`DATE`	Creation time of a foreign data file. 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 data file 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.
`CREATION_THREAD`	`NUMBER`	The thread number of the data file describe by this row.
`CREATION_SIZE`	`NUMBER`	The size of the data file at the time of creation.