Hello ;
one day ago i switched over our primary database to standby database, everything went fine. but today when i checked current scn for both database i saw both were different. and current scn was not changing on standby database. What reason can cause this problem?
here some outputs when i tried to find out problem..
on primary database ;
SQL> select thread#, max(sequence#) from v$archived_log group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 156
on standby database;
SQL> select thread#, max(sequence#) from v$archived_log where applied='YES' group by thread#;
THREAD# MAX(SEQUENCE#)
---------- --------------
1 156
on standby
SQL> select LAST_CHANGE#, STATUS from V$STANDBY_LOG;
LAST_CHANGE# STATUS
------------ ----------
2927636 ACTIVE
0 UNASSIGNED
0 UNASSIGNED
0 UNASSIGNED
on standby
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
2916773
on primary
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
2927809
Edited by: Ecimen on 18.Eki.2012 01:36
Edited by: Ecimen on 18.Eki.2012 01:47