Sunday 10 January 2016

Script for RMAN restore current status

Below script to know RMAN restore current status and remaining time to complete the refresh.

Script:

set lines 199
select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_RESTANTES, 
trunc(ELAPSED_SECONDS/60) MIN_ATEAGORA 
from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%';

Output:


No comments:

Post a Comment