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

本站中文解释

V$CLONEDFILE是Oracle数据库查看备份进度和状态的视图。它显示用于耗时较长且会破坏性能的备份操作的文件信息,包括文件名、大小、路径以及复制进度等。通过它监控备份操作,可以及时知道备份任务的进度,并且发现有问题及时修复。

使用V$CLONEDFILE视图,可以通过以下SQL语句查询备份进度:

SELECT file_name 需要备份的文件名,
bytes_remaining 还剩余的字节,
bytes_copied 已经复制的字节
FROM v$clonedfile;

官方英文解释

V$CLONEDFILE provides CloneDB file information.

Column Datatype Description

SNAPSHOTFILENAME

VARCHAR2(513)

Snapshot/master file name. This file is the master file from the master database. The snapshot file is also sometimes referred to as the srcfile.

CLONEFILENAME

VARCHAR2(513)

CloneDB file name. This file is the cloned file (of master file) which resides in the current (cloned database). The cloned file is sometimes referred to as the destfile.

SNAPSHOTBLKREAD

NUMBER

Number of blocks reads to the snapshot file (master file)

SNAPSHOTREQUEST

NUMBER

Number of read requests to the snapshot file (master file)

FILENUMBER

NUMBER

File number of the cloned file

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

BLOCKS_ALLOCATED

NUMBER

Amount of space allocated in blocks in the file system. This is less than or equal to the actual file size.

Note:

When this view is queried in an Oracle Database environment, rows are returned for every opened file, even those without a parent file backing them (in those cases the column is empty/NULL).

In an Oracle ASM environement, rows are returned for files that an Oracle ASM instance has mounted in disk groups only if those files are children (a clonefile) of a parent snapshot file.


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