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