1

In my DG environment, alert log shows the logs are applied on standby.

Then, I am querying the standby and primary using v$archive_gap. The query returns no rows selected. Because there is no gap? Only when there is archive gaps on a standby database, a row is returned??

R-K
  • 119
  • 1
  • 1
  • 8

1 Answers1

0

This will give you the interval of missing arch-files, if none are missing then you will get no rows..

select * from v$archive_gap; 
F.Madsen
  • 702
  • 4
  • 6