ASMCMD ls -lt command does not show TIME TO MINUTE/SECONDS
(Doc ID 744486.1)
Last updated on DECEMBER 20, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 19.25.0.0.0 [Release 10.2 to 19]
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 <NAME>.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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |