My Oracle Support Banner

ACFS Files's "ACCESS" timestamp is not updated using "STAT" command (Doc ID 2424741.1)

Last updated on JANUARY 02, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

The ACFS fs access time for the file created in the ACFS filesystem is modified on the node#1 to the time when we issued the cat command,
whereas in node#2 the file access time is still showing the created time, it is not getting reflected in the ACFS filesystem on node#2 and vice-versa.

NODE-1:

<< create one file in node 1 in ACFS filesystem >>

<user>@<host1>:/ora_fra/tmp []>ls > ACFSFILE_NODE1

<user>@<host1>:/ora_fra/tmp []>ls -l ACFSFILE_NODE1
-rw-r--r-- 1 oracle oinstall 142 Jul 18 12:34 ACFSFILE_NODE1
<user>@<host1>:/ora_fra/tmp []>

NODE-2:

<< check the file created in node 2 >>

<user>@<host2>:/ora_fra/tmp []> ls -l ACFSFILE_NODE1
-rw-r--r-- 1 oracle oinstall 142 Jul 18 12:34 ACFSFILE_NODE1
<user>@<host2>:/ora_fra/tmp []>

 

NODE-1:

<< check the file access time for the newly created file in node 2 >>

<user>@<host1>:/ora_fra/tmp []>stat ACFSFILE_NODE1
File: 'ACFSFILE_NODE1'
Size: 142 Blocks: 8 IO Block: 4096 regular file
Device: 3920f902h/958462210d Inode: 6288 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 555/ oracle) Gid: ( 56/oinstall)
Access: 2018-07-18 12:34:12.073749059 +0800                                          <<<<<<<<<<<<<<
Modify: 2018-07-18 12:34:12.077749087 +0800
Change: 2018-07-18 12:34:12.077749087 +0800
<user>@<host1>:/ora_fra/tmp []>

NODE-2:

<< Check the file access time for newly created file in node 2>>

<user>@<host2>:/ora_fra/tmp []> stat ACFSFILE_NODE1
File: 'ACFSFILE_NODE1'
Size: 142 Blocks: 8 IO Block: 4096 regular file
Device: 3920f902h/958462210d Inode: 6288 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 555/ oracle) Gid: ( 56/oinstall)
Access: 2018-07-18 12:34:12.073749059 +0800                                        <<<<<<<<<<<<<<<
Modify: 2018-07-18 12:34:12.077749087 +0800
Change: 2018-07-18 12:34:12.077749087 +0800
<user>@<host2>:/ora_fra/tmp []>

 

<<<<<<<< Wait for 2 or 3 mins >>>>>>>>>>>>>

 

Node -1

<< VI or CAT the newly created file in node 1 using command cat NFSFILE_NODE1 >>

<user>@<host1>:/ora_fra/tmp []>cat ACFSFILE_NODE1
1_5959_926279385.dbf
1_5960_926279385.dbf
ACFSFILE_NODE1
GTPS_DATA01_45.tf
o1_mf_1_5959_ffpv3rby_.arc.gz
o1_mf_1_5960_ffpv3w0d_.arc.gz
stat

<< check the stat of the file on NODE 1 stat ACFSFILE_NODE1 >>

<user>@<host1>:/ora_fra/tmp []>
<user>@<host1>:/ora_fra/tmp []>stat ACFSFILE_NODE1
File: 'ACFSFILE_NODE1'
Size: 142 Blocks: 8 IO Block: 4096 regular file
Device: 3920f902h/958462210d Inode: 6288 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 555/ oracle) Gid: ( 56/oinstall)
Access: 2018-07-18 12:39:54.317144347 +0800                                           <<< access time changed for this file
Modify: 2018-07-18 12:34:12.077749087 +0800
Change: 2018-07-18 12:34:12.077749087 +0800
<user>@<host1>:/ora_fra/tmp []>

NODE-2

<< execute the stat command on the file to check the access time on NODE 2 stat ACFSFILE_NODE1 >>

<user>@<host2>:/ora_fra/tmp []> stat ACFSFILE_NODE1
File: 'ACFSFILE_NODE1'
Size: 142 Blocks: 8 IO Block: 4096 regular file
Device: 3920f902h/958462210d Inode: 6288 Links: 1
Access: (0644/-rw-r--r--) Uid: ( 555/ oracle) Gid: ( 56/oinstall)
Access: 2018-07-18 12:34:12.073749059 +0800                                                 <<< access time still points to file creation time in node 2
Modify: 2018-07-18 12:34:12.077749087 +0800
Change: 2018-07-18 12:34:12.077749087 +0800
<user>@<host2>:/ora_fra/tmp []>

 

timesync is correct on both nodes:

<user>@<host1>[~] $ date
Wed Jul 18 15:22:32 HKT 2018
<user>@<host1>[~] $

<user>@<host2>[~] $ date
Wed Jul 18 15:22:32 HKT 2018
<user>@<host1>[~] $ 

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.