V$DATABASE_INCARNATION displays information about all database incarnations. Oracle creates a new incarnation whenever a database is opened with the RESETLOGS option. Records about the current and immediately previous incarnation are also contained in the V$DATABASE view.
Record ID for the branch record in the control file
Resetlogs system change number (SCN) for the incarnation of the current row
Resetlogs timestamp for the incarnation of the current row
Resetlogs SCN for the previous incarnation
Resetlogs timestamp for the previous incarnation
ORPHAN - Orphan incarnation
CURRENT - Current incarnation of the database
PARENT - Parent of the current incarnation
Branch ID for the incarnation of the current row (used by user-managed recovery/RMAN restore to get unique names for archived logs across incarnations)
Parent incarnation record ID if nonzero
Indicate whether or not Flashback Database can be performed into SCNs or timestamps in the incarnation. A value of YES means that you can flashback to some point in that incarnation. A value of NO indicates that you cannot flashback into the incarnation.