datafile lock

Posted by Roshan on Nov 29, 2016; 9:06am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-lock-tp1630.html

Hello Erman,

after completing a restore, we are getting the error below
CausedByException is:
Load failed; CausedByException is:
ORA-01157: cannot identify/lock data file 20001 - see DBWR trace file
ORA-01110: data file 20001: '/ORADATA7/WINSTEMP/TEMPPRD.dbf'

I am reviewing (Doc ID 1593130.1)

followed by Doc ID 212053.1

The file /ORADATA7/WINSTEMP/TEMPPRD.dbf does not exist in this folder /ORADATA7/WINSTEMP

All datafiles I have restored in /data/WINSDB.

Is the procedure ok? I recreate a new tablespace after dropping the file from controlfile?

Thx.
ROshan