On Standby: ############ SQL> SELECT CHECKPOINT_CHANGE# FROM v$datafile_header; CHECKPOINT_CHANGE# ================== 7691499 7691499 7691499 7691499 7691499 SQL> select current_scn from v$database; CURRENT_SCN =========== 7691498 SQL> SQL> SELECT ROUND((SYSDATE-MAX(FIRST_TIME))*24,2) "HOURS BEHIND" FROM V$LOG_HISTORY; HOURS BEHIND ============ 5.5 SQL> On Prod: ######### SQL> SELECT CHECKPOINT_CHANGE# FROM v$datafile_header; CHECKPOINT_CHANGE# ------------------ 7699591 7699591 ...