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

CON_ID

NUMBER

NOT NULL

The ID of the PDB

CON_UID

NUMBER

NOT NULL

Unique ID assigned to the PDB at creation time

CON_NAME

VARCHAR2(128)

NOT NULL

Name of the PDB

SNAPSHOT_NAME

VARCHAR2(128)

NOT NULL

Snapshot name of the PDB

SNAPSHOT_SCN

NUMBER

NOT NULL

SCN at which the snapshot was taken

PREVIOUS_SNAPSHOT_SCN

NUMBER

NOT NULL

SCN at which the previous snapshot for the PDB was taken

SNAPSHOT_TIME

NUMBER

NOT NULL

Timestamp at which the snapshot was taken

PREVIOUS_SNAPSHOT_TIME

NUMBER

NOT NULL

Timestamp of the previous snapshot for this PDB

FULL_SNAPSHOT_PATH

VARCHAR2(4000)

NOT NULL

Full path for the snapshot

Note:

This view does not display snapshot copy PDBs, which are created by using the CREATE PLUGGABLE DATABASESNAPSHOT COPY SQL statement.

See Also:

“DBA_PDB_SNAPSHOTFILE” for information about the files associated with a particular PDB snapshot


数据运维技术 » Oracle 视图 DBA_PDB_SNAPSHOTS 官方解释,作用,如何使用详细说明