Home » RDBMS Server » Server Administration » ORA-01157: cannot identify/lock data file 201 (Oracle Forms 11g, Windows 2008 server)
ORA-01157: cannot identify/lock data file 201 [message #592759] Mon, 12 August 2013 02:46 Go to next message
mary.yujin
Messages: 25
Registered: June 2010
Junior Member
Hi,
Our server got crash in server1 and we recovered the same DB to server2 using RMAN back up. But while running our scheduler for email alert we got the error message as
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: 'D:\ORADATA\KFDB\TEMP01.DBF'
Our temp file is already in E folder.
Pls help me how to solve the issue.
Re: ORA-01157: cannot identify/lock data file 201 [message #592764 is a reply to message #592759] Mon, 12 August 2013 03:25 Go to previous messageGo to next message
John Watson
Messages: 4674
Registered: January 2010
Location: Global Village
Senior Member
If you have restored the tempfile to a different path/name, you will need to update the controlfile accordingly:

alter database rename 'D:\ORADATA\KFDB\TEMP01.DBF' to 'whatever_it_is_now';

(and, by the way, I'll move your topic from Forms to Server Admin)
Re: ORA-01157: cannot identify/lock data file 201 [message #592800 is a reply to message #592764] Mon, 12 August 2013 07:42 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi,you were renaming the tempfile, is it possible to recover tempfile in that sense,? does tempfile needs recovery?


Re: ORA-01157: cannot identify/lock data file 201 [message #592803 is a reply to message #592800] Mon, 12 August 2013 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59407
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it does not.

Regards
Michel
Re: ORA-01157: cannot identify/lock data file 201 [message #592900 is a reply to message #592759] Tue, 13 August 2013 00:44 Go to previous message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
A database backup and restore + recovery does not recreate the Temp files (those listed in DBA_TEMP_FILES and V$TEMPFILE).
You need to issue an "ALTER TABLESPACE TEMP ADD TEMPFILE 'path_to_tempfile' ;" statement.


Hemant K Chitale
Previous Topic: ORA-00020: maximum number of processes (400) exceeded
Next Topic: no of users logged on
Goto Forum:
  


Current Time: Tue Oct 21 02:18:25 CDT 2014

Total time taken to generate the page: 0.06800 seconds