V$PDB_INCARNATION

V$PDB_INCARNATION displays information about all PDB incarnations. Oracle creates a new PDB incarnation whenever a PDB is opened with the RESETLOGS option.


Column Datatype Description

DB_INCARNATION#

NUMBER

Database incarnation number

PDB_INCARNATION#

NUMBER

PDB incarnation number

STATUS

VARCHAR2(7)

Incarnation status:

  • ORPHAN: Orphan incarnation

  • CURRENT: Current incarnation of the PDB

  • PARENT: Parent of the current incarnation

INCARNATION_SCN

NUMBER

The SCN to flashback or recover to for this PDB incarnation

INCARNATION_TIME

DATE

The point in time recovered to for this PDB incarnation

BEGIN_RESETLOGS_SCN

NUMBER

The SCN at the beginning of PDB resetlogs

BEGIN_RESETLOGS_TIME

DATE

The time at the beginning of PDB resetlogs

END_RESETLOGS_SCN

NUMBER

The SCN at the end of PDB resetlogs

END_RESETLOGS_TIME

DATE

The time at the end of PDB resetlogs

PRIOR_DB_INCARNATION#

NUMBER

Parent database incarnation number

PRIOR_PDB_INCARNATION#

VARCHAR2(40)

Parent PDB incarnation number

FLASHBACK_DATABASE_ALLOWED

VARCHAR2(3)

Indicates whether the PDB can be flashbacked to this incarnation as part of a flashback database operation for the CDB

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data