Home » RDBMS Server » Backup & Recovery » Rman status report (oracle 10.1.0.4, windows servers)
Rman status report [message #575878] Mon, 28 January 2013 12:57 Go to next message
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 #577275 is a reply to message #575878] Wed, 13 February 2013 22:55 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Are you sure about backup schedule ? Just wondering if you scheduled every one hour
Re: Rman status report [message #577366 is a reply to message #577275] Thu, 14 February 2013 08:51 Go to previous messageGo to next message
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
Member
Thanks for the reply, my contract has ended at that location.
Re: Rman status report [message #577367 is a reply to message #577366] Thu, 14 February 2013 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59984
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without solving the issue?

Regards
Michel
Re: Rman status report [message #577372 is a reply to message #577367] Thu, 14 February 2013 10:39 Go to previous message
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.
Previous Topic: recovery catalog creating error
Next Topic: Issue in SPFILE Autobackup
Goto Forum:
  


Current Time: Thu Dec 18 13:48:28 CST 2014

Total time taken to generate the page: 0.11495 seconds