Incorrect Time recorded in v$archived_log
Hi all,
DB version 10.2.0.5, OS: Oracle Solaris on x86-64 (64-bit)
Problem : Current time is Jul 1 2013 , but from the v$archived_log, time is 2013-07-30
!date
Mon Jul 1 06:46:24 UTC 2013
SQL> select sysdate from dual;
SYSDATE
-------------------
2013-07-01 06:54:35
SQL> select recid,sequence#,FIRST_TIME,NEXT_TIME,COMPLETION_TIME from v$archived_log where recid=514789;
RECID SEQUENCE# FIRST_TIME NEXT_TIME COMPLETION_TIME
---------- ---------- ------------------- ------------------- -------------------
514789 11306 2013-07-30 21:06:31 2013-07-30 21:21:19 2013-07-30 21:21:40
SQL> select * from v$log where rownum<10;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
0