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 identifier |
|
|
Session recid |
|
|
Session stamp |
|
|
Backup set identifier |
|
|
Backup piece key |
|
|
Backup piece record ID |
|
|
Backup piece record stamp |
|
|
Backup set stamp |
|
|
Backup set count |
|
|
Backup piece number (1-N) |
|
|
Indicates the copy number for backup pieces created with duplex enabled. The value is 1 if the backup piece is not duplexed. |
|
|
Type of device on which the backup piece resides. Set to DISK for backup sets on disk. |
|
|
Backup piece handle identifies the backup piece on restore |
|
|
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. |
|
|
Name of the media on which the backup piece resides. This value is informational only. It is not needed for restore. |
|
|
The media pool in which the copy resides. This is the same value that was entered in the |
|
|
(YES|NO) indicates whether or not the piece is on a media that can be accessed concurrently |
|
|
Backup piece tag. The tag is specified at backup set level, but stored at piece level. |
|
|
Indicates the status of the piece: |
|
|
Starting time |
|
|
Completion time |
|
|
Number of elapsed seconds |
|
|
|
|
|
Size of the backup piece, in bytes |
|
|
Indicates whether or not the file was created in the fast recovery area ( |
|
|
Owning |
|
|
Owning |
|
|
Indicates whether the backup piece is compressed ( |
|
|
Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use. |
|
|
A value of |
|
|
A value of |
|
|
Indicates whether this is a cross platform backup piece:
|
|
|
If the value of |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Number of backup pieces per set |
|
|
Size (in bytes) of the backup piece to display |