datafile lock

[Roshan]

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

[ErmanArslansOracleBlog]

This seems like a temp file not datafile. If it is a tempfile, this error is normal, as the tempfiles are not included in db/rman backups.

Ensure it using v$tempfile, then drop the tempfile and add it back.

Example command:

alter database tempfile 'path-to-tempfile' drop  
alter tablespace your_TEMPTABLESPACE add tempfile 'path-to-tempfile' size 10G;

[Roshan]

Great.. It is working :)
Thanks