myorama
3/25/2015 - 6:42 AM

Dataguard applying log progression (run on standby database)

Dataguard applying log progression (run on standby database)

select status || ':' || to_char(sequence#) 
       || ' (' || to_char(decode(status, 'APPLYING_LOG', trunc(100*block#/greatest(1,blocks)), 0)) || '%)'
       as status
from v$managed_standby
where process = 'MRP0'
and rownum=1 ;