This discussion is archived
9 Replies Latest reply: Apr 8, 2009 5:08 AM by 686167 RSS

ORA-01157: cannot identify/lock data file

686167 Newbie
Currently Being Moderated
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

Legend

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