RMAN BACKUP SUMMARY EXPLAINED

In RMAN , we can see the backup summary report to get an overview of the types of backup happened, backup level, device information and other stuffs clearly. But you should first be familiar with the conventions used or shortcut letters used for representation of each backup run. These short letters often confuse or difficult to remember or understand during interpretation

RMAN> list backup summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
78      B  F  A DISK        02-AUG-21       1       1       YES        FULL_BKP_AUG2_2021
79      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T144203
80      B  0  A DISK        02-AUG-21       1       1       YES        INC_LVL_0_AUG2_2021
81      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T144911
82      B  1  A DISK        02-AUG-21       1       1       YES        INC_LVL_1_AUG2_2021
83      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T145121
84      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
85      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
86      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
87      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
88      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
89      B  A  A DISK        02-AUG-21       1       1       NO         TAG20210802T145228
90      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T145410
91      B  A  A DISK        02-AUG-21       1       1       NO         ARCHIVE_BKP_AUG2_2021_06_02
92      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T145625
93      B  F  A DISK        02-AUG-21       1       1       NO         CONTROL_BKP_AUG2_2021
94      B  F  A DISK        02-AUG-21       1       1       NO         TAG20210802T153114

-----------------------------------------------------------------------
Key represents the backup key using to uniquely identify a backup piece 
-----------------------------------------------------------------------
TY represents the type of backup 
-----------------------------------------------------------------------
LV represents the backup level 
F - full backup(backupset or image copy) or controlfile/spfile backup(if auto backup is ON)
0 - incremental level 0
1 - incremental level 1
A - archivelog backup
-----------------------------------------------------------------------
S represents the backup status.
A - available
U - unavailable
X - expired 
-----------------------------------------------------------------------
Device Type represents the DISK or SBT_TAPE 
-----------------------------------------------------------------------
Completion time the time at which backup got completed
-----------------------------------------------------------------------
#Pieces represent the number of backup pieces 
-----------------------------------------------------------------------
.....
Rest are self explanatory

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s