Explain the column of the list backup summary
[oracle@servername ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 12 16:00:31 2023
Version 19.9.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: dbname (DBID=47384729)
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
34020 B F A DISK 09-OCT-23 1 1 NO TAG20231009T230243
34020 B F A DISK 09-OCT-23 1 1 NO TAG20231009T230243
This output is from the LIST BACKUP SUMMARY command in RMAN. Here’s a brief explanation of the columns in the output:
Key: The unique identifier for the backup set.
TY: The type of backup. B indicates a backup set, while C indicates a copy.
LV: The level of the backup. F indicates a full backup, while I indicates an incremental backup.
S: The status of the backup. A indicates that the backup is available, while U indicates that it is unavailable.
Device Type: The type of device used for the backup.
Completion Time: The time when the backup is completed.
#Pieces: The number of pieces in which the backup is stored.
#Copies: The number of copies of the backup that exist.
Compressed: Indicates whether the backup is compressed or not. NO indicates that it is not compressed.
Tag: The tag assigned to the backup.
similarly for 2nd output:
This output is from the LIST BACKUP SUMMARY command in RMAN. Here’s a brief explanation of the columns in the output:
Key: The unique identifier for the backup set.
TY: The type of backup. B indicates a backup set, while C indicates a copy.
LV: The level of the backup. A indicates an archive log backup.
S: The status of the backup. A indicates that the backup is available, while U indicates that it is unavailable.
Device Type: The type of device used for the backup.
Completion Time: The time when the backup is completed.
#Pieces: The number of pieces in which the backup is stored.
#Copies: The number of copies of the backup that exist.
Compressed: Indicates whether the backup is compressed or not. NO indicates that it is not compressed.
Tag: The tag assigned to the backup.
I hope this helps!
Tags:
RMAN