Hello,
My oracle environment is DataGuard 11.2.0.1.0 on physical standby,when i use SQL query below,
SYS@standby> col current_scn for 9999999999999999
SYS@standby> select scn_to_timestamp(current_scn) from v$database;
select scn_to_timestamp(current_scn) 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
and if not using function 'scn_to_timestamp' is OK,
SYS@standby> select current_scn from v$database;
CURRENT_SCN
-----------------------
12204021200
Why is it ? Please give me some suggestions,thanks!
Best Regards
Quanwen Zhao