This discussion is archived
3 Replies Latest reply: Feb 5, 2013 11:50 PM by brunors RSS

ASM files not in database

902332 Newbie
Currently Being Moderated
Hi all,

we have oracle 11.2.0 2 node cluster database. there are 20 database files for that database. but when i checked in that location appears 23 datafiles. looks like 3 datafiles are not related to the database. result is like below. i think first 3 files are not updating any thing and which are not listed in the dba_data_files view. so i think i can remove this. please suggest.

Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name
DATAFILE UNPROT COARSE NOV 04 15:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE NOV 04 15:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE NOV 04 15:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194177 34358697984 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 02:00:00 Y 8192 4194303 34359730176 34360786944 xxxx
DATAFILE UNPROT COARSE JAN 30 03:00:00 Y 8192 4188161 34309414912 34327232512 xxxx
DATAFILE UNPROT COARSE JAN 30 03:00:00 Y 8192 3932161 32212262912 32246857728 xxxx

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points