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.logSQL> 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
我的数据文件和重做日志文件都已经成功修改,但惟独这个临时文件修改遇到这样的问题
这种情况应该如何处理呢
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.logSQL> 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
我的数据文件和重做日志文件都已经成功修改,但惟独这个临时文件修改遇到这样的问题
这种情况应该如何处理呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货