You Asked

Hi,guy!
I use RMAN to backup the database on Nov 13 through the COMMVAULT software,but on Nov 15,the oracle server CPU is high,then I connect to the server and check,found that the wait event is 'RMAN backup&rcovery I/O',and the logon time is the same as I check the view v$rman_backup_job_details.start_time,the v$rman_backup_job_details.status show 'COMPLETED WITH ERROR',and the v$rman_backup_job_details.end_time was the current time(sysdate),and the end_time update when I check the view again and alaways equal to the value of sysdate,and the RMAN session was not doing anything. So I go to chekc the RMAN backup log in the COMMVAULT software,I found that backup job was completed and found no errors in the RMAN backup log.The end,I kill that session to reduce the usage of CPU.
I'm still wonder why this would happen? And I don't know how to trace the reason.Could you tips me?

Thanks for your help! And hope for your response!

Best wishes!

and Connor said...

Sounds like it get stuck spinning (ie, tight CPU loop).

RMAN supports some debugging options, eg

rman target / debug trace 'mytracefile.trc'

but of course, you need to start rman with those activated. Also, you can sometimes get some information by querying the V$ views

V$RMAN_OUTPUT
V$RMAN_STATUS

MOS Note 1198753.1 also has some more info on how to trace an RMAN session that is currently running.

Rating

(1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

For thanks!

Li, November 17, 2016 - 5:55 am UTC

Thanks for your guidance! I would trace it the next time the same problem happen!
Thanks a lot!!!

November 18, 2016 - 4:10 am UTC

glad we could help

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.

Breadcrumb

Question and Answer