My Oracle Support Banner

Wrong Data Files Path Under "File IO Stats" Section In AWR Report After Online Moving Of Data files (Doc ID 3027633.1)

Last updated on JUNE 12, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.21.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After online moving data files using ALTER DATABASE statement to different file system mount point (from /old to /new) or ASM disk group (from +OLDDG to +NEWDG), but in newly generated AWR reports still old data files path were showed instead of new data files path under "File IO Stats" section:

AWR Report File IO Stats Section:

Tablespace       Filename
--------------    ------------------------
TBLS               /old/datafile_1.dbf

 Or In case of ASM:

AWR Report File IO Stats Section:

Tablespace         Filename
--------------      -----------------------
TBLS                 +OLDDG/datafile_1.dbf

Changes

Datafiles were online moved from "/old" to "/new" or "+OLDDG" to "+NEWDG" using the below command:

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
Changes
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.