RMAN - LIST BACKUP SUMMARY

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!




Akash

I am working as a Data Engineer

Post a Comment

Previous Post Next Post