-
v$sessionlongops doesn't show progress RMAN
I should check the progress of the full rman backup.
The following query does not extract any records.
Percentage rman backup
select
sid
,start_time
,totalwork
,sofar
,case totalwork when 0 then round((sofar/1) * 100,2) else round((sofar/totalwork) * 100,2) end pct_done
from
v$session_longops
where
totalwork > sofar
order by start_time desc;
The last extracted records are from 6 days ago and opname='Gather Table's Index Statistics'.
select * from v$session_longops order by start_time desc;
The full rman backup is running: is there a reason why no records are being extracted?
Until last week I was extracting correctly.
Thanks
-
after restarting oracle 19 instance, the v$session_longops table resumed correctly extracting records: could this be a bug?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|