Thursday, April 28, 2011

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.

No comments:

Post a Comment