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

E17615-23
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

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