RC_PLUGGABLE_DATABASE_INC

RC_PLUGGABLE_DATABASE_INC displays information about all pluggable database (PDB) incarnations. A new PDB incarnation is created whenever a PDB is opened with the RESETLOGS option. It corresponds to the V$PDB_INCARNATION view.

Column Data Type Description
PDB_KEY NUMBER The primary key for this PDB in the recovery catalog.
NAME VARCHAR2(30) Name of the PDB.
CON_ID NUMBER Unique identifier of the multitenant container database (CDB) that contains this PDB.
DBID NUMBER Unique identifier of the PDB.
CREATE_SCN NUMBER Creation SCN of PDB.
PDBINC_KEY NUMBER The primary key for this PDB incarnation in recovery catalog.
DB_KEY NUMBER The primary key for this CDB in the recovery catalog.
CURRENT_INCARNATION VARCHAR2(3) YES if it is the current incarnation; NO if it is not.
INCARNATION_SCN NUMBER The SCN to flashback or recover to for this PDB incarnation.
BEGIN_RESETLOGS_SCN NUMBER The SCN at the beginning of the PDB resetlogs.
BEGIN_RESETLOGS_TIME DATE The time of the SCN in BEGIN_RESETLOGS_SCN.
END_RESETLOGS_SCN NUMBER The SCN at the end of the PDB resetlogs.
DBINC_KEY NUMBER The primary key for the incarnation of CDB at which this PDB incarnation is created.
DB_RESETLOGS_SCN NUMBER The incarnation SCN of CDB at which this PDB incarnation is created.
DB_RESETLOGS_TIME DATE The incarnation time of CDB at which this PDB incarnation is created.
PRIOR_PDBINC_KEY NUMBER The primary key of the parent PDB incarnation.
PRIOR_INCARNATION_SCN NUMBER INCARNATION_SCN of parent PDB incarnation.
PRIOR_BEGIN_RESETLOGS_SCN NUMBER BEGIN_RESETLOGS_SCN of parent PDB incarnation
PRIOR_BEGIN_RESETLOGS_TIME DATE BEGIN_RESETLOGS_TIME of parent PDB incarnation.
PRIOR_END_RESETLOGS_TIME NUMBER END_RESETLOGS_TIME of parent PDB incarnation.
PRIOR_DBINC_KEY NUMBER DBINC_KEY of parent PDB incarnation.
PRIOR_DB_RESETLOGS_SCN NUMBER DB_RESETLOGS_SCN of parent PDB incarnation
PRIOR_DB_RESETLOGS_TIME DATE DB_RESETLOGS_TIME of parent PDB incarnation
STATUS VARCHAR2(8) Incarnation status:
  • ORPHAN: Orphan incarnation

  • CURRENT: Current incarnation of the PDB

  • PARENT: Parent of current incarnation