Oracle教程 2023-04-07

Oracle 视图 V$PDB_INCARNATION 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$PDB_INCARNATION用于显示当前Pluggable Database(PDB)的恢复序号，每次插拔、换出或克隆PDB操作，都将会更新其取值，该恢复序号由更细粒度的恢复操作（比如PDB切换）设置为0。

该视图的使用：使用Oracle的SELECT语句查询V$PDB_INCARNATION视图，以获取PDB当前的恢复序号信息

例如：
SELECT CON_ID, RESETLOGS_CHANGE#, CURRENT_SCN
FROM V$PDB_INCARNATION
WHERE CON_ID = ;

官方英文解释

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

数据运维技术 » Oracle 视图 V$PDB_INCARNATION 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐