Re: datafile lock

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

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;