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);
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);