Hello All,
Previously DBA has configured Data Guard as Physical Standby.
Now we want to check replication status of log files into Standby DB.
However, we can't connect remotely to Standby DB using pl/sql and etc..., because db is in the mount mode(Physical Standby).
Do anyone have a script which can show replication status between sites.
Script can be run only in primary db
Using below script we can't be sure that logs applied on standby:
select sequence#, first_time, applied from v$archived_log order by sequence#
Please share this script if you have one!
Thanks in advance!
Regards,
Ravil