📋Steps in this guide1/1

Monitor recovery progress in standby db

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

oracle configurationintermediate

by OracleDba

13 views

Monitor recovery progress in standby db

Code/Command (click line numbers to comment):

1
2

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!