When I execute the query -- select name, file# status from v\$datafile;
the datafiles for system tablespaces are listed multiple times.
For example, for sysaux, the output has below entries. Why is this?
Same is the case with system and users tablespace.
The setup is Oracle 12c
I have used this in earlier versions of oracle, but this is something new that I'm observing with 12c.
+ASM_DG/GDB/DATAFILE/sysaux.269.838407323 , 3
+ASM_DG/GDB/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/sysaux.273.838407639 , 7
+ASM_DG/GDB/F159D742BCE602C0E0438B59D10A581B/DATAFILE/sysaux.258.838409993 , 10
When I use the query --
SELECT FILE_NAME, BLOCKS, TABLESPACE_NAME
FROM DBA_DATA_FILES;
Then only single entry appears
+ASM_DG/GDB/DATAFILE/sysaux.269.838407323 , 108800,SYSAUX
Any help will be great.