ORA-08181 ORA-06512: at "SYS.SCN_TO_TIMESTAMP"

Version: 11.2.0.3

SQL> select name, open_mode, database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
HSB62 READ ONLY PHYSICAL STANDBY

SQL> select scn_to_timestamp(current_scn) scn_sync_until from v$database;
select scn_to_timestamp(current_scn) scn_sync_until from v$database
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1


OR


SQL> select current_scn from v$database;

CURRENT_SCN
--------------------
10588754037

SQL> select scn_to_timestamp(10588754037) scn_sync_until from v$database;
select scn_to_timestamp(10588754037) scn_sync_until from v$database
*
ERROR at line 1:
ORA-08181: specified number is not a valid system change number
ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1


Workaround: To bounce the database and flush shared pool (doesn't worked for me..!)


Conclusion / Solution:

Bug 17214565.

There is no fixes for this bug currently.

The issue seems to be resolved in 12c.