A good query to monitor your backups in your rman recovery catalog is.
SELECT db_name, start_time, end_time, status
FROM rcat.rc_rman_backup_job_details
WHERE end_time > sysdate -1
TEST 10/4/2011 12:30:04 AM 10/4/2011 12:32:51 AM COMPLETED
DEV1 10/4/2011 3:05:05 AM 10/4/2011 8:56:13 AM COMPLETED
PROD1 10/3/2011 11:24:07 PM 10/4/2011 9:57:56 AM RUNNING
No comments:
Post a Comment