CURRENT_SCN is behind SYSDATE after DBUA upgrade
upgraded the DB from 12c to 19c via the DBUA. now the CURRENT_SCN is several hours behind:
SQL> select scn_to_timestamp(current_scn),systimestamp from v$database;
SCN_TO_TIMESTAMP(CURRENT_SCN)
---------------------------------------------------------------------------
SYSTIMESTAMP
---------------------------------------------------------------------------
30-NOV-22 11.30.05.000000000 PM
01-DEC-22 08.30.06.624000 AM +01:00
which causes following error:
SQL> select timestamp_to_scn(sysdate) from dual;
select timestamp_to_scn(sysdate) from dual
*
ERROR at line 1:
ORA-08186: invalid timestamp specified
ORA-06512: at "SYS.TIMESTAMP_TO_SCN", line 1
SQL>
Any advise ?
0