How to monitor RMAN progress?


Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backpiece new sessions are created so overall progress can be monitored by looking at where context = 3 as in the case below it shows the overall progress is 38.05% complete.

— works in 8i/9i/10g.

SQL> SELECT sid, serial#, context, sofar, totalwork,
round(sofar/totalwork*100,2) “% Complete”
FROM v$session_longops
WHERE totalwork 0
and upper(opname) like ‘%RMAN%’
and sofar totalwork;

SID SERIAL# CONTEXT SOFAR TOTALWORK % Complete
1026 26544 1 2081106 10752000 19.36
1002 28050 3 102401569 269149445 38.05
1037 16054 1 9125198 10854400 84.07
962 18556 1 9226142 10854400 85
1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s