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.
Column | Datatype | Description |
INCARNATION# | NUMBER | Record ID for the branch record in the control file |
RESETLOGS_CHANGE# | NUMBER | Resetlogs system change number (SCN) for the incarnation of the current row |
RESETLOGS_TIME | DATE | Resetlogs timestamp for the incarnation of the current row |
PRIOR_RESETLOGS_CHANGE# | NUMBER | Resetlogs SCN for the previous incarnation |
PRIOR_RESETLOGS_TIME | DATE | Resetlogs timestamp for the previous incarnation |
STATUS | VARCHAR2(7) | Incarnation status:
|
RESETLOGS_ID | NUMBER | 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) |
PRIOR_INCARNATION# | NUMBER | Parent incarnation record ID if nonzero |
FLASHBACK_DATABASE_ALLOWED | VARCHAR2(26) | 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. |
Oracle data dictionary views
Last updated: 2009-11-05 Thursday |
No comments:
Post a Comment