Database Administration (MOSC)

MOSC Banner

Incorrect Time recorded in v$archived_log

edited Jun 19, 2018 9:16AM in Database Administration (MOSC) 8 commentsAnswered
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
------------- -------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center