Monitor recovery progress in standby db - Oracle Database Script.
SELECT to_char(START_TIME, 'DD-MON-YYYY HH24:MI:SS') "Recovery Start Time",
to_char(item)||' = '||to_char(sofar)||' '||to_char(units) "Progress"
FROM v$recovery_progress
WHERE start_time=
(SELECT max(start_time)
FROM v$recovery_progress);