Oracle 视图 DBA_PDB_SNAPSHOTS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_PDB_SNAPSHOTS对应于数据库范围的子体/容器数据库的快照状态,该视图显示从可用的PDB到完全受限的PDB所有状态。
DBA_PDB_SNAPSHOTS用于显示容器数据库的快照状态。它显示了在特定容器数据库上执行快照操作后每个PDB的当前状态,包括PDB的创建日期和时间,打开状态和操作。
这是用于管理容器数据库及其子体/PDB的有用信息。它还有助于监视用于打开或关闭容器数据库/PDB的操作的进度。
可以使用如下查询来检查容器数据库/PDB的信息:
SELECT PDB_NAME, PDB_MODE, RESTRICTED, SNAP_TIMESTAMP FROM DBA_PDB_SNAPSHOTS where container_name=”
官方英文解释
DBA_PDB_SNAPSHOTS
describes the snapshots taken of pluggable databases (PDBs).
Rows are added to this view when a snapshot of a PDB is taken by using the ALTER
PLUGGABLE
DATABASE
SNAPSHOT
SQL statement.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
The ID of the PDB |
|
|
|
Unique ID assigned to the PDB at creation time |
|
|
|
Name of the PDB |
|
|
|
Snapshot name of the PDB |
|
|
|
SCN at which the snapshot was taken |
|
|
|
SCN at which the previous snapshot for the PDB was taken |
|
|
|
Timestamp at which the snapshot was taken |
|
|
|
Timestamp of the previous snapshot for this PDB |
|
|
|
Full path for the snapshot |
Note:
This view does not display snapshot copy PDBs, which are created by using the CREATE
PLUGGABLE
DATABASE
… SNAPSHOT
COPY
SQL statement.
See Also:
“DBA_PDB_SNAPSHOTFILE” for information about the files associated with a particular PDB snapshot