9 Replies Latest reply: Apr 8, 2009 7:08 AM by 686167 RSS

    ORA-01157: cannot identify/lock data file

    686167
      Hi all,

      Last week, I added a new tablespace with a new data file. The fact is since this moment, the backup faild with this error:

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on TSM3 channel at 04/06/2009 02:08:44
      ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
      ORA-01110: data file 8: '/dev/rtf7moc_d_00_lv'

      I search this error at metalink but always refers a problem with a problem for oracle to see the datafile. I try to create a new elements (tables, indexes, etc) over this tablespace and I have no problems to do it. And if i make querys over it always have answers (like dba_tables or dba_segments).

      Someone knows what happens?

      Thanks in advance,
      Regards,
      Jordi