Oracle 视图 V$DATABASE_INCARNATION 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$DATABASE_INCARNATION是用于显示数据库当前存在的实例（incarnation）信息的V$表视图。它包括当前存在的所有数据库版本、各个数据库版本下所拥有的实例，以及实例的状态。
要使用这个视图，首先需要登录数据库，然后可以通过在SQL*Plus中键入如下SQL语句来查询：
SELECT * FROM v$database_incarnation;
这句话将显示数据库当前拥有的所有incarnation信息。
官方英文解释
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 |
|---|---|---|
|
|
|
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 |
|
|
|
Incarnation status:
|
|
|
|
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. |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$DATABASE”
