Oracle 视图 V$BACKUP_SET 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$BACKUP_SET用于查看RMAN备份进度,查看该备份包括哪些datafiles在内,以及其他需要备份的要素。
可以使用V$BACKUP_SET访问数据库备份及恢复信息。 使用该视图可以查看RMAN及全文备份的配置情况,如是否只备份控制文件等。
使用此视图查询数据库备份信息,可以帮助DBA更容易操作RMAN备份等操作,而不会出现备份存在状况和恢复问题。 例如,使用V$BACKUP_SET,DBA可以查看先前备份的相关信息,以及可以进行RMAN备份时包括哪些数据库对象和对象在备份中。
官方英文解释
V$BACKUP_SET
displays information about backup sets from the control file.
A backup set record is inserted after the backup set is successfully completed.
Column | Datatype | Description |
---|---|---|
|
|
Backup set record ID |
|
|
Backup set record stamp |
|
|
Backup set stamp. The backup set stamp and count uniquely identify the backup set. Primary key for the |
|
|
Backup set count. The backup set count is incremented by one every time a new backup set is started (if the backup set is never completed the number is “lost”). If the control file is re-created then the count is reset to Primary key for the |
|
|
Type of files that are in this backup. If the backup contains archived redo logs, the value is |
|
|
Provides information about the control file in the backup set:
|
|
|
Location where this backup set fits into the database’s backup strategy. Set to NULL for full datafile, archivelog, controlfile, and spfile backups, set to 0 for incremental level 0 datafile backups, and set to 1 for incremental level 1 datafile backups. |
|
|
Number of distinct backup pieces in the backup set |
|
|
Starting time |
|
|
Time that this backup set completed |
|
|
The number of elapsed seconds |
|
|
Block size of the backup set |
|
|
|
|
|
( |
|
|
If |
|
|
Lists additional retention options for this backup set. Possible values are:
|
|
|
Indicates whether or not this backup set is a multi-section backup. Valid values are |
|
|
Indicates whether this is a cross platform backup set:
|
|
|
If the value of |
|
|
If the value of |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
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. |