Duplicate datafile name on different volumes for one database instance
DB: Oracle Enterprise 10.2.0.5
Host: Linux 5.0
Storage: NetApp volumes
Through some miscommunication and forgetfulness, we wound up with two different volumes mounted on the same server with the same directory name and with the same individual files within those directories.
For instance:
VOL1 /oradata/DBU1
VOL2 /oradata/DBU1
In each volume most of the same files exist, i.e. aschem_data_1.dbf, aschem_data_2.dbf, etc.
On the Database on this server, DBU1, it has a tablespace, ASCHEM_DATA, which has the files residing in (assigned to?) it.
The database is operational, but what I am seeing on the OEM performance monitor indicates that whenever an update is executed on a table/row which is stored in one (or more) of the files, the update is being applied to both of the files, so work is doubled.