Logical Standby Sync

## if you are using a logical standby then you need to check the following to confirm the redo has been
## applied

sql> select applied_scn, latest_scn, mining_scn from v$logstdby_progress;

## if the mining scn is behind you may have a gap check this by using the following

sql> select status from v$logstdby_process where type = 'READER';

SELECT APPLIED_SCN, APPLIED_TIME, READ_SCN, READ_TIME, NEWEST_SCN, NEWEST_TIME
FROM DBA_LOGSTDBY_PROGRESS;

From:
http://aprilcsims.wordpress.com/logical-standby-10gr2-open-issues/
http://www.datadisk.co.uk/html_docs/oracle_dg/cheatsheet.htm