ASMCMD ls -lt command does not show TIME TO MINUTE/SECONDS (Doc ID 744486.1)

Last updated on APRIL 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.2 [Release 10.2 to 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

ASMCMD ls -lt command doest not show correct time.

ASMCMD> ls -lt
Type            Redund     Striped      Time                    Sys Name
DATAFILE UNPROT COARSE OCT 21 09:00:00 Y TS5.256.668685255

asmcmd command is internally running the following query to get a result.

SQL> select group_number, file_number, incarnation, block_size, blocks, bytes, space, type, redundancy, striped, creation_date, to_char(modification_date, 'MON DD HH24:MI:SS') "MOD_TIME", to_char(modification_date, 'MON DD YYYY') "MOD_DATE", to_char(modification_date, 'J HH24 MI SS') "JULIAN_TIME", to_char(modification_date, 'J') "JULIAN_DATE" from v$asm_file where compound_index = 16777472 ;

GROUP_NUMBER FILE_NUMBER INCARNATION BLOCK_SIZE BLOCKS BYTES SPACE
------------ ----------- ----------- ---------- ---------- ---------- ----------
TYPE REDUND STRIPE
---------------------------------------------------------------- ------ ------
CREATION_ MOD_TIME MOD_DATE JULIAN_TIME JULIAN_
--------- --------------- ----------- ---------------- -------
1 256 668685255 8192 12801 104865792 106954752
DATAFILE UNPROT COARSE
21-OCT-08 OCT 21 09:00:00 OCT 21 2008 2454761 09 00 00 2454761

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms