Hello All,
I am using oracle 11.2.0.4 on windows 2008R2
I realise that at my standby database, current_scn of the database is lower than the fhscn.
Please, find below:
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
410387384
SQL> select min(fhscn) from x$kcvfh;
MIN(FHSCN)
----------------
591983152
SQL> select min(f.fhscn) from x$kcvfh f, v$datafile d
2 where f.hxfil =d.file#
3 and d.enabled != 'READ ONLY' ;
MIN(F.FHSCN)
----------------
591983152
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
410387384
SQL> select 'MAX ', greatest(max(fhscn), max(fhafs)) maxscn from x$kcvfh;
'MAX MAXSCN
---- ----------------
MAX 592107566
Please, can anyone advise.