Checking RMAN operation's status

If you backup your Oracle database with RMAN and you want to check the execution of RMAN operations, you would use the V$RMAN_STATUS view as follows:

SQL> select COMMAND_ID, OPERATION, STATUS, END_TIME from V$RMAN_STATUS WHERE END_TIME > sysdate - 5;

COMMAND_ID              OPERATION                         STATUS        END_TIME
----------------------- --------------------------------- ------------- ---------
2010-11-26T23:05:29     RMAN                              COMPLETED     26-NOV-10
backup_level_1          BACKUP                            COMPLETED     26-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     26-NOV-10
backup_level_1          BACKUP                            COMPLETED     26-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     26-NOV-10
2010-11-27T22:56:51     RMAN                              COMPLETED     27-NOV-10
backup_level_1          BACKUP                            COMPLETED     27-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     27-NOV-10
backup_level_1          BACKUP                            COMPLETED     27-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     27-NOV-10
2010-11-28T22:55:34     RMAN                              COMPLETED     29-NOV-10
backup_level_0          DELETE                            COMPLETED     28-NOV-10
backup_level_0          BACKUP                            COMPLETED     29-NOV-10
backup_level_0          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     29-NOV-10
backup_level_0          BACKUP                            COMPLETED     29-NOV-10
backup_level_0          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     29-NOV-10
backup_level_0          DELETE                            COMPLETED     29-NOV-10
backup_level_0          DELETE                            COMPLETED     29-NOV-10
2010-11-30T22:49:31     RMAN                              COMPLETED     30-NOV-10
backup_level_1          BACKUP                            COMPLETED     30-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     30-NOV-10
backup_level_1          BACKUP                            COMPLETED     30-NOV-10
backup_level_1          CONTROL FILE AND SPFILE AUTOBACK  COMPLETED     30-NOV-10

23 rows selected.