Let’s assume, we are doing a backup of a large database. At a given time, if we need to check, how much backup is finished & how much is left, so that we can have some estimates.
Following query can be used to check the RMAN backup status
If multiple channels are allocated for the backup, then this query will return multiple records. Each record will be indicating the status of individual channel.