Originally posted by lemjoh01
The command you sent tells me what backups were done on a database but does not tell me if the backup succeeded. For example, some of my database are on tape and sometimes, we get an error because of the tape. I was wondering if I can get the status from the database. Here is an example of one error I got :

RMAN-10035: exception raised in RPC: ORA-19506: failed to create sequential file, name="al_17894_1_537998539", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to open for backup.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Recovery Manager complete.
If you get an error like that, you won't have an entry in the Catalog. Only successful backups are in the catalog. So, you can check for a backup, if there isn't one, you had a problem!