Sunday, February 17, 2019

Monitor recovery progress from standby database

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