How to check RMAN backups status when you use CATALOG

If you use CATALOG for RMAN backup you can just by using one SQL query to check whether backups are going well. Run this query as RMAN CATALOG owner user:

1. Connect to Database contained RMAN CATALOG as CATALOG owner user.
2. Run this query:
-- Run this query on RMANDBX instance:

SELECT
    DB_NAME,
    INPUT_TYPE,
    STATUS,
    TO_CHAR(START_TIME, 'MM-DD-YYYY HH24:MI:SS') START_TIME,
    TIME_TAKEN_DISPLAY TIME_TAKEN,
    INPUT_BYTES_DISPLAY INPUT_SIZE,
    OUTPUT_BYTES_DISPLAY OUTPUT_SIZE
  FROM RC_RMAN_BACKUP_JOB_DETAILS
  ORDER BY START_TIME
  DESC;


Result: