3 Replies Latest reply: Feb 6, 2013 1:50 AM by brunors RSS

    ASM files not in database

    902332
      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