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

本站中文解释

Oracle视图V$BACKUP_PIECE_DETAILS用于查询数据库备份块的信息。在Oracle 11gR2中,可以使用此视图用于监控和检索备份块的信息。

它存储了关于备份和还原操作的所有细节,可以提供诸如完成日期和时间、进度、备份和恢复运行时长、警告、错误等细节。可以使用这些信息来监测备份进度,检查备份性能,查找/解决备份失败和错误等。

使用方法:

要查询V$BACKUP_PIECE_DETAILS视图,可以运行下列SQL查询:

SELECT * FROM V$BACKUP_PIECE_DETAILS

该查询将显示关于所有备份块的详细信息。可以使用where子句限定您感兴趣的备份块,例如:

SELECT * FROM V$BACKUP_PIECE_DETAILS
WHERE STATUS = ‘COMPLETED’;

这可以返回已成功完成的备份块的信息。

官方英文解释

V$BACKUP_PIECE_DETAILS displays information about all available backup pieces.

Column Datatype Description

SESSION_KEY

NUMBER

Session identifier

SESSION_RECID

NUMBER

Session recid

SESSION_STAMP

NUMBER

Session stamp

BS_KEY

NUMBER

Backup set identifier

BP_KEY

NUMBER

Backup piece key

RECID

NUMBER

Backup piece record ID

STAMP

NUMBER

Backup piece record stamp

SET_STAMP

NUMBER

Backup set stamp

SET_COUNT

NUMBER

Backup set count

PIECE#

NUMBER

Backup piece number (1-N)

COPY#

NUMBER

Indicates the copy number for backup pieces created with duplex enabled. The value is 1 if the backup piece is not duplexed.

DEVICE_TYPE

VARCHAR2(17)

Type of device on which the backup piece resides. Set to DISK for backup sets on disk.

HANDLE

VARCHAR2(513)

Backup piece handle identifies the backup piece on restore

COMMENTS

VARCHAR2(64)

Comments returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only. It is not needed for restore.

MEDIA

VARCHAR2(65)

Name of the media on which the backup piece resides. This value is informational only. It is not needed for restore.

MEDIA_POOL

NUMBER

The media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command.

CONCUR

VARCHAR2(3)

(YES|NO) indicates whether or not the piece is on a media that can be accessed concurrently

TAG

VARCHAR2(32)

Backup piece tag. The tag is specified at backup set level, but stored at piece level.

STATUS

VARCHAR2(1)

Indicates the status of the piece: A (available), D (deleted), or X (expired)

START_TIME

DATE

Starting time

COMPLETION_TIME

DATE

Completion time

ELAPSED_SECONDS

NUMBER

Number of elapsed seconds

DELETED

VARCHAR2(3)

NO indicates that the file still exists. YES indicates that the file no longer exists because it has been deleted.

BYTES

NUMBER

Size of the backup piece, in bytes

IS_RECOVERY_DEST_FILE

VARCHAR2(3)

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

RMAN_STATUS_RECID

NUMBER

Owning V$RMAN_STATUS record ID

RMAN_STATUS_STAMP

NUMBER

Owning V$RMAN_STATUS record stamp

COMPRESSED

VARCHAR2(3)

Indicates whether the backup piece is compressed (YES) or not (NO)

BACKED_BY_VSS

VARCHAR2(3)

Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use.

ENCRYPTED

VARCHAR2(3)

A value of YES means an encrypted backup, otherwise not an encrypted backup.

BACKED_BY_OSB

VARCHAR2(3)

A value of YES means the backup was done to Oracle Secure Backup. Otherwise, backed up by other third party tape library.

FOR_XTTS

VARCHAR2(3)

Indicates whether this is a cross platform backup piece:

  • YES: This is a cross platform backup piece.

  • NO: This is not a cross platform backup piece.

SAME_ENDIAN

VARCHAR2(3)

If the value of FOR_XTTS is YES, then this column indicates whether the backup piece has the same endianess as the current database (YES) or not (NO); otherwise NULL.

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

PIECES_PER_SET

NUMBER

Number of backup pieces per set

SIZE_BYTES_DISPLAY

VARCHAR2(4000)

Size (in bytes) of the backup piece to display


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