| Rman status report [message #575878] |
Mon, 28 January 2013 12:57  |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
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 status reports runs at 7AM and all the backups run between noon and midnight, this is the output from the sql:
DB_NAME STATUS START_TIME END_TIME
-------- --------------------------------- -------------------- --------------------
OEMREP RUNNING 27-JAN-2013 18:00:05
XXXXXXX COMPLETED 27-JAN-2013 19:00:06 27-JAN-2013 19:06:23
XCXXXXX COMPLETED 27-JAN-2013 21:00:07 27-JAN-2013 21:28:48
XXXXXXX COMPLETED 27-JAN-2013 21:00:04 27-JAN-2013 23:03:20
I've tested restoring the OEM REP database and it restores fine. Anyone know why the status shows as "Running"???
TIA
Dave
PS and yes there are more databases but no sense in listing them all.
|
|
|
|
|
|
|
|
|
|
| Re: Rman status report [message #577372 is a reply to message #577367] |
Thu, 14 February 2013 10:39  |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
|
Contract ended, no access to their system. I was there for a data center move which was completed, I was just looking into other things, trying to help out, but the contract ended before this could be resolved.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
