Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datafiles for sysaux tablespace listed multiple times from v$datafile

sumeetp45Mar 12 2014 — edited Mar 13 2014

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.

This post has been answered by Richard Harrison . on Mar 12 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2014
Added on Mar 12 2014
2 comments
357 views