This content has been marked as final. Show 4 replies
Your post is unreadable, I do not think anyone can comment on what it is supposed to be reporting. There is a code formatter here http://www.dpriver.com/pp/sqlformat.htm that you might want to use, and then post the output enclosed within
i guess you are using a MAXIMUM PERFORMANCE configuration without standby redo logs, where changes get applied only at log switches
show parameter log_archive_dest_N (use the approriate number that is representing the standby destination)
select protection_mode, protection_level from v$database;
select bytes from v$log;
select status from v$managed_standby where process='MRP0';
select recovery_mode from v$archive_dest_status;
select group#, thread#, status from v$standby_log;
You haven't posted the output of your second query.
My guess is that the Primary hasn't generated a new ArchiveLog in the last 50minutes -- so there is nothing to apply on the standby. You should be using ARCHIVE_LAG_TARGET to ensure that the Primary generates and ships a new ArchiveLog at a predetermined frequency.
Hemant K Chitale
is that a RAC database ?