Oracle教程

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

本站中文解释

视图

V$BACKUP_COPY_DETAILS 视图是Oracle的系统视图，用于报告RMAN的复制备份相关的细节信息。查看该视图中的数据可以了解备份的文件名称，时间，报道状态等信息。该视图可以使用多种不同方式来帮助管理RMAN备份，例如监视RMAN作业的进程，确保定期备份，检查恢复脚本中是否存在错误或缺失等信息。

要使用V$BACKUP_COPY_DETAILS视图，首先需要连接到Oracle数据库，然后使用 SQL 语句来查询视图中的数据，例如：

SELECT * FROM V$BACKUP_COPY_DETAILS;

该语句将返回V$BACKUP_COPY_DETAILS中的所有列。也可以使用WHERE子句来限制返回的列，例如：

SELECT * FROM V$BACKUP_COPY_DETAILS WHERE STATUS=’COMPLETED’;

该语句将只返回完成的备份。另外，也可以使用ORDER BY子句来按要求排序查询结果，例如：

SELECT * FROM V$BACKUP_COPY_DETAILS ORDER BY FILENAME;

该语句将使用备份文件名排序查询结果。

官方英文解释

V$BACKUP_COPY_DETAILS contains information about all available control file and data file copies.

Column Datatype Description

SESSION_KEY

NUMBER

Session identifier

SESSION_RECID

NUMBER

Session recid

SESSION_STAMP

NUMBER

Session stamp

COPY_KEY

NUMBER

Unique identifier for this data file or control file copy

FILE#

NUMBER

Absolute data file number

NAME

VARCHAR2(513)

File name of the data file copy. The maximum length of the name is dependent on your operating system.

TAG

VARCHAR2(32)

Data file copy tag

CREATION_CHANGE#

NUMBER

Data file creation change number

CREATION_TIME

DATE

Data file creation timestamp

CHECKPOINT_CHANGE#

NUMBER

Checkpoint change number of the data file when the copy was made

CHECKPOINT_TIME

DATE

Checkpoint timestamp of the data file when the copy was made

MARKED_CORRUPT

NUMBER

Number of blocks marked corrupt by this copy operation. That is, blocks that were not marked corrupted in the source data file, but were detected and marked as corrupted during the copy operation.

OUTPUT_BYTES

NUMBER

Total output bytes written

COMPLETION_TIME

DATE

Time when the copy was completed

CONTROLFILE_TYPE

VARCHAR2(1)

Type of control file. B indicates normal copies. S indicates standby copies.

KEEP

VARCHAR2(3)

(YES|NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy

KEEP_UNTIL

DATE

If specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.

KEEP_OPTIONS

VARCHAR2(11)

Lists additional retention options for this backup set. Possible values are:

  • LOGS – The logs needed to recover this backup set are kept

  • NOLOGS – The logs needed to recover this backup set are not kept

IS_RECOVERY_DEST_FILE

VARCHAR2(3)

Indicates whether the file was created in the fast recovery area (YES) or not (NO)

SPARSE_BACKUP

VARCHAR2(3)

Indicates whether the file is sparse (YES) or not (NO)

OUTPUT_BYTES_DISPLAY

VARCHAR2(4000)

Size of backup set to display

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$BACKUP_COPY_DETAILS 官方解释，作用，如何使用详细说明
分享到：

相关推荐