SELECT TO_CHAR(START_TIME,'DD-MON-YYYY HH24:MI:SS') "Recovery Start Time",
TO_CHAR(item)
||' = '
||TO_CHAR(sofar)
||' '
||TO_CHAR(units) "Progress", comments
FROM v$recovery_progress
WHERE start_time=
(SELECT MAX(start_time) FROM v$recovery_progress
);
No comments:
Post a Comment