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

E50791-02
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_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 current container:
  • 0: Rows containing data that pertain to the entire multitenant container database (CDB) or a traditional Oracle databases (non-CDBs)

  • 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  
CREATION_SIZE NUMBER