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

本站中文解释

及V$MEDIA_PIECE

Oracle 视图V$BACKUP_PIECE及V$MEDIA_PIECE提供有关在Oracle备份中已经存在的备份块的信息,可用于检查备份进度或重新加载备份组件的独立备份块等。

V$BACKUP_PIECE:主要可以查看该控制文件中相应备份块的信息,内容包括备份块的路径,大小,创建时间,备份类型等。

V$MEDIA_PIECE:可以查看已备份控制文件中所有卷或块的信息,其中包括每个卷或块的类型,大小,保存状态等。

使用方法:

1、查询出现在归档日志中曾备份过的文件和控制文件:

SELECT distinct b.PIECE#,b.LOGICAL_MAX_BUF,b.STATUS,
b.CREATION_TIME,b.DEVICE_TYPE,b.WHERE_PATH,
FROM v$backup_piece b,
v$backup_set_details d
WHERE b.set#=d.group#
AND d.COMPLETION_TIME >= trunc(sysdate)-1;

2、查询出归档日志中某个特定的备份文件的详情:

SELECT b.PIECE#,b.STATUS,b.DEVICE_TYPE,b.WHERE_PATH,
b.CHECKSUM,b.TAG,b.CREATION_TIME,
FROM v$backup_piece b
WHERE PIECE_NAME like ‘&filename’;

官方英文解释

V$BACKUP_PIECE displays information about backup pieces from the control file. Each backup set consists of one or more backup pieces.

Column Datatype Description

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. 1 if the backup piece is not duplexed.

DEVICE_TYPE

VARCHAR2(17)

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

See Also: V$BACKUP_DEVICE

HANDLE

VARCHAR2(513)

Backup piece handle identifies the backup piece on restore

COMMENTS

VARCHAR2(64)

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

MEDIA

VARCHAR2(65)

Name of the media on which the backup piece resides. This value is informational only; 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 the piece 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)

(YES/NO) NO indicates that the file still exists. YES indicates 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 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

GUID

RAW(16)

The GUID of the PDB to which the backup belongs. This is useful after the PDB is dropped to identify which PDB the backup belongs to.


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