V$RECOVERY_PROGRESS NO DATA for "Active Apply Rate"
edited Feb 14, 2017 12:32AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
We have create a new standby database in 11gr2 but when I run the below query I am not getting information related to "Active Apply Rate" and "Redo Applied". Through the related documents I can see the under lying table x$ksulop is not having this information. Is there a way we can rectify and start populating the data?
SQL> select to_char(start_time, 'DD-MON-RR HH24:MI:SS') start_time, item , sofar from v$recovery_progress
where item in ('Active Apply Rate', 'Average Apply Rate', 'Redo Applied','Last Applied Redo');
2
START_TIME ITEM SOFAR
--------------------------- -------------------------------- ----------
31-AUG-16 03:39:52 Average Apply Rate 322
0