在做Oracle数据库restore地时候遇到地问题

发表于 2011-10-14 | 来源：互联网 | 阅读：

SQL> ALTER DATABASE RENAME file ‘/db_9i01/oradata/lwlmj/temp01.dbf’ TO ‘/db_9i01/oradata/new_lwlmj/temp01.dbf’;
ALTER DATABASE RENAME file ‘/db_9i01/oradata/lwlmj/temp01.dbf’ TO ‘/db_9i01/oradata/new_lwlmj/temp01.dbf’
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, datafile, or tempfile
"/db_9i01/oradata/lwlmj/temp01.dbf"

分隔线
======================================================================
[root@CentOSForOracle9i new_lwlmj]# pwd
/db_9i01/oradata/new_lwlmj
[root@CentOSForOracle9i new_lwlmj]# ll
total 1195360
-rw-r—– 1 oracle oinstall 1880064 Oct 12 20:52 control01.ctl
-rw-r—– 1 oracle oinstall 1880064 Oct 12 20:52 control02.ctl
-rw-r—– 1 oracle oinstall 1880064 Oct 12 20:52 control03.ctl
-rw-r–r– 1 oracle oinstall 20975616 Oct 12 19:50 drsys01.dbf
-rw-r–r– 1 oracle oinstall 152702976 Oct 12 19:50 example01.dbf
-rw-r–r– 1 oracle oinstall 26218496 Oct 12 19:50 indx01.dbf
drwx—— 2 oracle oinstall 16384 Oct 12 19:12 lost+found
-rw-r–r– 1 oracle oinstall 20975616 Oct 12 19:50 odm01.dbf
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:50 redo01.log
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:50 redo02.log
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:51 redo03.log
-rw-r–r– 1 oracle oinstall 346034176 Oct 12 19:51 system01.dbf
-rw-r–r– 1 oracle oinstall 41947136 Oct 12 19:51 temp01.dbf
-rw-r–r– 1 oracle oinstall 10489856 Oct 12 19:51 tools01.dbf
-rw-r–r– 1 oracle oinstall 209719296 Oct 12 19:52 undotbs01.dbf
-rw-r–r– 1 oracle oinstall 26218496 Oct 12 19:52 users01.dbf
-rw-r–r– 1 oracle oinstall 47190016 Oct 12 19:52 xdb01.dbf

[root@CentOSForOracle9i oradata]# cd lwlmj/
[root@CentOSForOracle9i lwlmj]# ll
total 1195352
drwxr-xr-x 2 oracle oinstall 4096 Oct 12 19:30 archive
-rw-r—– 1 oracle oinstall 1880064 Oct 12 19:38 control01.ctl
-rw-r—– 1 oracle oinstall 1880064 Oct 12 19:38 control02.ctl
-rw-r—– 1 oracle oinstall 1880064 Oct 12 19:38 control03.ctl
-rw-r–r– 1 oracle oinstall 20975616 Oct 12 19:38 drsys01.dbf
-rw-r–r– 1 oracle oinstall 152702976 Oct 12 19:38 example01.dbf
-rw-r–r– 1 oracle oinstall 26218496 Oct 12 19:38 indx01.dbf
-rw-r–r– 1 oracle oinstall 20975616 Oct 12 19:38 odm01.dbf
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:38 redo01.log
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:33 redo02.log
-rw-r—– 1 oracle oinstall 104858112 Oct 12 19:33 redo03.log
-rw-r–r– 1 oracle oinstall 346034176 Oct 12 19:38 system01.dbf
-rw-r–r– 1 oracle oinstall 41947136 Aug 25 15:23 temp01.dbf
-rw-r–r– 1 oracle oinstall 10489856 Oct 12 19:38 tools01.dbf
-rw-r–r– 1 oracle oinstall 209719296 Oct 12 19:38 undotbs01.dbf
-rw-r–r– 1 oracle oinstall 26218496 Oct 12 19:38 users01.dbf
-rw-r–r– 1 oracle oinstall 47190016 Oct 12 19:38 xdb01.dbf

分隔线
======================================================================
SQL> SELECT group#,member FROM v$logfile;

GROUP# MEMBER
———- —————————————-
3 /db_9i01/oradata/new_lwlmj/redo03.log
2 /db_9i01/oradata/new_lwlmj/redo02.log
1 /db_9i01/oradata/new_lwlmj/redo01.log

SQL> SELECT file#,name FROM v$datafile;

FILE# NAME
———- —————————————-
1 /db_9i01/oradata/new_lwlmj/system01.dbf
2 /db_9i01/oradata/new_lwlmj/undotbs01.dbf
3 /db_9i01/oradata/new_lwlmj/drsys01.dbf
4 /db_9i01/oradata/new_lwlmj/example01.dbf
5 /db_9i01/oradata/new_lwlmj/indx01.dbf
6 /db_9i01/oradata/new_lwlmj/odm01.dbf
7 /db_9i01/oradata/new_lwlmj/tools01.dbf
8 /db_9i01/oradata/new_lwlmj/users01.dbf
9 /db_9i01/oradata/new_lwlmj/xdb01.dbf

我地数据文件和重做日志文件都已经成功修改,但惟独这个临时文件修改遇到这样地问题
这种情况应该怎么处理呢