Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not getting out put on RMAN backup error

AryacoolDec 16 2014 — edited Jan 5 2015

Hi Friends,

In our production Nagios is configured and for RMAN back up error one query set to check "SELECT COUNT(*) FROM v$rman_status WHERE status != 'COMPLETED' AND status != 'RUNNING' AND start_time > sysdate-3 " .

But in above query its hang up .

I have also checked up from database side manually its hanging the session no output is coming .

Also i have changed the query a bit to get result "select count(*) from V$RMAN_STATUS where operation= 'BACKUP' and nvl(status, 'X') not in ('COMPLETED', 'RUNNING') and start_time >= trunc(sysdate - 3) ; " but same happen no output

Please tell me how to get the output for last 3 days from present day .

Db Version - 11.2.0.2

Regards,

Arya

This post has been answered by Aryacool on Jan 5 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2015

Added on Dec 16 2014

#general-database-discussions

14 comments

3,043 views