I have a situation where the SCN on the standby database is greater than the SCN on the Primary database. I referred a few threads earlier which said that this cannot be possible, but this is something which I am facing now.
Primary:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select status,instance_name,database_role,current_scn from v$database,v$instance;
STATUS INSTANCE_NAME DATABASE_ROLE CURRENT_SCN
------------ ---------------- ---------------- -----------
OPEN KRA1T PRIMARY 421851938
SQL> select max(sequence#) From v$archived_log;
MAX(SEQUENCE#)
--------------
31310
Standby:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> select status,instance_name,database_role,current_scn from v$database,v$instance;
STATUS INSTANCE_NAME DATABASE_ROLE CURRENT_SCN
------------ ---------------- ---------------- -----------
OPEN KRA1S PHYSICAL STANDBY 421856797
SQL> select max(sequence#) From v$archived_log where applied='YES';
MAX(SEQUENCE#)
--------------
31310
The Standby is in sync with the primary and there is no errors reported in the alert logs. Everything looks perfect, but my concern is why is it that the SCN on the standby is greater than the primary. Any help on this would really be appreciated.