Real Time Aooly and SCN'S

Database A is primary Database B is a physical standby. The redo transport parameters include synch and affirm. Real time apply is not on.

If I query v$log on the primary and v$standby_log on the secondary I can that the lgs are in synch. If I look at the SCN on the primary it is ever increasing. The SCN on the secondary is static at one less than the first change# in the standby redo log. When that log switches the SCN becomes one less than the first change SCN, I the now current standby redo log.

This makes perfect sense as when real time apply is not on the changes are applied when upon log file switch.

If I go to real time apply, I thought the SCN would be changing every time I queried it. Instead it gets further behind. All the other factors, point to successful real time apply, but I don't understand what's happening with the SCN's

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

--
http://www.freelists.org/webpage/oracle-l