5.36 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. This view 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.

GUID

RAW(16)

Globally unique identifier (GUID) of this 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