Revisando el estado de operaciones de RMAN

Si respaldas tu base de datos Oracle con RMAN y quieres revisar la ejecución de las operaciones de RMAN, puedes usar la vista V$RMAN_STATUS como en el siguiente ejemplo:

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.