| ORA-01157: cannot identify/lock data file 201 [message #592759] |
Mon, 12 August 2013 02:46  |
mary.yujin
Messages: 26
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  |
John Watson
Messages: 8960
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 #592900 is a reply to message #592759] |
Tue, 13 August 2013 00:44 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
