Hi,
i am looking for an answer but couldnt find for a while.
for example, I backed up my system with this command:
backup database section size 1G;
and 4 file created for backup (I assume my database approximately 4.5G and overall backup is 3.5G). there are 4 different file under one backup set after backup command. I run this command again and 4 more files for and second backup.
Now, how can I understand from RMAN or sql dynamic views, which backup file is belong to which backupset.
in RMAN "List Backup" command doesnt show backup sets (or I couldnt find a common point).
also in sql there are V$BACKUP_SET and V$BACKUP_PIECE views but I couldnt find master detail relation between these views. in V$Backup_Set view I can see backup header info and how many file that backup has, in V$Backup_Piece view RMAN_STATUS_RECID column has the same id for same backups but it is not exist in V$Backup_Set
especially I want to see this list in RMAN. is there a solution ?
thanks for help.