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

本站中文解释

Oracle视图DBA_PDB_SNAPSHOTFILE存储信息，该信息描述有关容器数据库（CDB）结构中每个pluggable数据库（PDB）存储在cdb_datafiles中的备份信息。

该视图随着CDB中PDB的发展而发展，它具有以下列：

– PDB_ID：指定的PDB的ID
– FILENAME：指定的PDB的快照文件名
– FILE_SIZE：指定的PDB的快照文件大小
– STATUS：当前PDB的快照文件的状态（可用/使用中）
– LAST_MODIFIED：指定PDB的快照文件上次修改时间

要使用DBA_PDB_SNAPSHOTFILE视图，可以使用SELECT语句查询所有PDB在cdb_datafiles中存储的备份信息：

SELECT *
FROM DBA_PDB_SNAPSHOTFILE
ORDER BY PDB_ID;

官方英文解释

DBA_PDB_SNAPSHOTFILE displays the files associated with snapshots taken of pluggable databases (PDBs).

You can use this view in conjunction with the DBA_PDB_SNAPSHOT view. Join the SNAPSHOT_SCN column in this view with the SNAPSHOT_SCN column in DBA_PDB_SNAPSHOT to determine the files associated with a particular PDB snapshot. A PDB snapshot consists of an archive log file, one or more data files, and one or more XML files. A row is added to this view for each file associated with a PDB snapshot.

See Also:

“DBA_PDB_SNAPSHOTS”