RMAN status report - oracle 10.1.0.4 on windows 64 bit servers
We run rman backups every night (level 0 on weekend, level 1 other 6 days). Backups are running fine. The problem I'm having is we also have a OEM report that runs morning to report on the status of those backups. For some reason, the status of the OEM database is always "RUNNING", everything else is "COMPLETED". This is the sql that is being run:
SELECT
DB_NAME, STATUS, START_TIME,
END_TIME
FROM RMAN.RC_RMAN_STATUS
where start_time between sysdate - 1 and sysdate
and operation = 'RMAN'
order by db_name, start_time desc;
The databases that are being backedup are oracle 10 and 11, the respository is 10.1.0.4
SELECT
DB_NAME, STATUS, START_TIME,
END_TIME
FROM RMAN.RC_RMAN_STATUS
where start_time between sysdate - 1 and sysdate
and operation = 'RMAN'
order by db_name, start_time desc;
The databases that are being backedup are oracle 10 and 11, the respository is 10.1.0.4
0