This content has been marked as final. Show 3 replies
I would remove my email ASAP from the post above. Otherwise you become Spam target Plus plus
951368 wrote:Use the script of MSeberg, Modify v$instance as gv$instance for RAC
Can anyone please provide me data guard gap monitoring script for databases(primary,standby) on RAC.
Oracle RDBMS 18.104.22.168(4-node RAC) on RHEL 5.6.
Edited by: 951368 on Dec 26, 2012 9:21 AM
Hi, could you monitoring doing this query in the standby database:
select process, status, sequence#, thread# from v$managed_standby;
where the result must show you the process MRP0 and also the status must be APPLYING_LOG or WAIT_FOR_LOG other value you should review because it is not syncronization.