Datafiles redistribution across mountpoints

Posted by Karthik on Sep 08, 2020; 6:24pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Datafiles-redistribution-across-mountpoints-tp8751.html

Hi Erman,

We are using EBS R12.2.9 with Database 19c (19.7). Both Application tier and Database tier(Non-Rac, Non-ASM) running on separate servers. Database size 3.7 TB.

In Database server, We have three mountpoints containing datafiles, one mountpoint for Oracle Binaries,  CDB datafiles and redo logs, and one more point to archive logs. All these mountpoints are created using single lun to storage. Now storage team wants to create multiple luns and mount those as 5 mountpoints for datafiles(1 Lun for 1 mountpoint). So we have to redistribute datafiles across 5 mountpoints. we are planningto redistribute all datafiles by using data file_id as below. Kindly provide your inputs on this approach. If you have any suggestions, please let me know.

file_id 1 --> mountpoint1
file_id 2 --> mountpoint2
file_id 3 --> mountpoint3
file_id 4 --> mountpoint4
file_id 5 --> mountpoint5
file_id 6 --> mountpoint1
file_id 7 --> mountpoint2
file_id 8 --> mountpoint3
file_id 9 --> mountpoint4
file_id 10 --> mountpoint5

FYI, We have 160 datafiles for PDB. We had ran ASH report also to identify around 15 hot datafiles and not to keep all those datafiles in one mountpoint. We are shuffling those datafiles across mountpoints.

Thanks in Advance,
Karthik