Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-01516

tad_csApr 18 2009 — edited Apr 20 2009
Hi all,

I've copied all files of a database to other server. so I've generated alter database renam file
to datafiles, redo log files and temp files.

But, when I try to do an alter database renam file for temp file, I get the following error:
SQL> ALTER DATABASE RENAME FILE '/opt/oracle/data/temp01.dbf'
TO 'NEW_ORACLE/data/temp01.dbf';  2
ALTER DATABASE RENAME FILE '/opt/oracle/data/temp01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile "/opt/oracle/data/temp01.dbf"
But I can see the temp files by using the view v$tempfile.

Somebody can help me please???

thank you very much!!!!

PS.: The database is mounted.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2009
Added on Apr 18 2009
8 comments
5,362 views