How to apply Oracle feature OMF in File System?

If you company is using file system instead of ASM and OMF feature is enabled in your Oracle Database. I would said it is pretty difficult to manage the storage allocation because OMF feature is based on 3 database parameters: DB_CREATE_FILE_DEST, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST.
Both of these initialization parameters are dynamic, and can be set using the ALTER SYSTEM or ALTER SESSION statement.

Since OMF is define the structure for data files, however, it is also refer your parameter DB_CREATE_FILE_DEST to create data files.

Below is case study to simulate the situation. The case study is add data file into different file system (mount point).
I have tried to run this command to add datafiles into 2 mount points in the same time, but it was prompted error.



Even, I had planned to add single datafile into the existing tablespace. But, it wasn't go through.
Obviously, the command is not allow to use your own defined path to create data file







Furthermore, I have create tablespaces with only 1 datafile attached.












SQL> alter system set db_create_file_dest='/data2/oradata' scope=both;

After changed the db_create_file_dest parameter, I have added data file into tablespaces created just now.












Now, both mount points have the data files with OMF managed.
There are pros and cons in this feature which need you to consider it further.