RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

來(lái)源：懂視網(wǎng) 責(zé)編：小采時(shí)間：2020-11-09 16:29:59

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET: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 RECID NUMBER Backup set record ID STAMP NUMBER Backup se

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

導(dǎo)讀RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET: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 RECID NUMBER Backup set record ID STAMP NUMBER Backup se

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 RECID NUMBER Backup set record ID STAMP NUMBER Backup se

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
`RECID`	`NUMBER`	Backup set record ID
`STAMP`	`NUMBER`	Backup set record stamp
`SET_STAMP`	`NUMBER`	Backup set stamp. The backup set stamp and count uniquely identify the backup set. Primary key for the`V$BACKUP_SET` table, and the foreign key for the following tables: `V$BACKUP_PIECE`,`V$BACKUP_DATAFILE`,`V$BACKUP_REDOLOG`,`V$BACKUP_CORRUPTION`. 備份集標(biāo)記。備份集標(biāo)記和計(jì)數(shù)唯一地標(biāo)識(shí)了備份集。
`SET_COUNT`	`NUMBER`	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 `1`. Therefore the count must be used with the stamp to uniquely identify a backup set. Primary key for the`V$BACKUP_SET` table, and the foreign key for the following tables: `V$BACKUP_PIECE`,`V$BACKUP_DATAFILE`,`V$BACKUP_REDOLOG`,`V$BACKUP_CORRUPTION` `備份集計(jì)數(shù)。每次一個(gè)新的備份集開始備份集計(jì)數(shù)會(huì)增加1。（如果備份集從來(lái)沒有完成則編號(hào)“丟失”）。如果控制文件被重新創(chuàng)建則計(jì)數(shù)重置為1，因此計(jì)數(shù)必須和標(biāo)記一起使用來(lái)唯一地標(biāo)識(shí)一個(gè)備份集。`
`BACKUP_TYPE`	`VARCHAR2(1)`	Type of files that are in this backup. If the backup contains archived redo logs, the value is `L`. If this is a datafile full backup, the value is `D`. If this is an incremental backup, the value is `I`.
`CONTROLFILE_INCLUDED`	`VARCHAR2(3)`	Set to `YES` if there is a control file included in this backup set, otherwise set to `NO`
`INCREMENTAL_LEVEL`	`NUMBER`	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.
`PIECES`	`NUMBER`	Number of distinct backup pieces in the backup set
`START_TIME`	`DATE`	Starting time
`COMPLETION_TIME`	`DATE`	Time that this backup set completed
`ELAPSED_SECONDS`	`NUMBER`	The number of elapsed seconds
`BLOCK_SIZE`	`NUMBER`	Block size of the backup set
`INPUT_FILE_SCAN_ONLY`	`VARCHAR2(3)`	`YES` indicates no actual backup is performed, but the datafiles are read. `NO` indicates a normal backup is performed.
`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 `KEEP_UNTIL`_TIME is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.
`KEEP_OPTIONS`	`VARCHAR2(10)`	Lists additional retention options for this backup set. Possible values are: `LOGS` - The logs need to recover this backup are kept `NOLOGS` - The logs needed to recover this backup will not be kept `BACKUP_LOGS` - An archive log backup exists to support this backup set
`MULTI_SECTION`	`VARCHAR2(3)`	Indicates whether or not this backup set is a multi-section backup. Valid values are `YES` and`NO`. A multi-section backup is a backup in which multiple backup pieces are produced independently in parallel by multiple channels.

該視圖查看的信息與RMAN中命令LIST BACKUP類似，只不過(guò)表示形式不同。其中BACKUP_TYPE列標(biāo)記該備份集中包含的文件類型，有下列幾個(gè)值：

L：表示包含歸檔重做日志文件；

D：表示數(shù)據(jù)文件完全備份；

I：表示增量備份。

還有一個(gè)常用的關(guān)聯(lián)視圖V$BACKUP_SET_DETAILS，該視圖除了包含V$BACKUP_SET中的數(shù)據(jù)外，還額外記錄了備份集的詳細(xì)信息，比如備份集大小、備份集所在設(shè)備等。額外的列也都比較簡(jiǎn)單，用字面意義理解列定義即可。

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

推薦度：

點(diǎn)擊下載本文 文檔為doc格式

標(biāo)簽：備份動(dòng)態(tài) ba

熱門焦點(diǎn)

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

RMAN備份動(dòng)態(tài)性能視圖V$BACKUP_SET

最新推薦

猜你喜歡

熱門推薦