Monitor the online backup progress in Oracle 11g (RMAN)

[Former Member]

Hi,

is there  a simple way to see the progress of the online backp for oracle?

We are using oracle 11g and using RMAN td level-0 and level-1 backups in the SAP environment(SAP Netweaver 7.01)

Regards,

Rakesh

[Reagan · Accepted solution]

Hello Rakesh

Have a look at this SAP note point 21

618868 - FAQ: Oracle performance

You can use that query or adapt it according to you requirements.

In addition to that if you do a quick search on Google using "rman backup progress" you will find few of them.

Few references

Monitoring RMAN Through V$ Views

Script to monitor RMAN progress

Regards

RB

[Former Member · Accepted solution]

you can try this

RMAN backup overall progress status

SELECT decode(context,1,'This Task:',2,'Agregate:','?') Context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete"

FROM v$session_longops

WHERE opname LIKE 'RMAN%'

AND opname LIKE '%aggregate%'

AND totalwork != 0

AND sofar <> totalwork

UNION

SELECT decode(context,1,'This Task:',2,'Agregate:','?') Context, sofar, totalwork, round(sofar/totalwork*100,2) "% Complete"

FROM v$session_longops

WHERE opname LIKE 'RMAN%'

AND opname NOT LIKE '%aggregate%'

AND totalwork != 0

AND sofar <> totalwork;

[Former Member]

you can monitor the .anf in /oracle/<SID>/sapbackup directory if you use brbackup. generally you can get the status when querying the v$session_longops via SQL

Thanks ,Siva

[Former Member]

Thanks Siva!

I was looking for something like a script which tells me the running backup progress.

Like the following script which tells the status of RMAN backup (completed/failed):

col STATUS format a9

col hrs format 999.99

select

SESSION_KEY, INPUT_TYPE, STATUS,

to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,

to_char(END_TIME,'mm/dd/yy hh24:mi')   end_time,

elapsed_seconds/3600                   hrs

from V$RMAN_BACKUP_JOB_DETAILS

order by session_key;

regards,

Rakesh

[Former Member]

Siva,

Can you please confirm if this script is okay to find the online backup progress

col STATUS format a9

select sid, serial#, sofar, totalwork, opname,

round(sofar/totalwork*100,2) "% Complete"

from   v$session_longops

where  opname LIKE 'RMAN%'

and    opname NOT LIKE '%aggregate%'

and    totalwork != 0

and    sofar <> totalwork;

Right now we don't have running backup to check this.

Regards,

Rakesh