rename datafile时报错ORA-01511,ORA-01121,ORA-01110

现象：
实例启动到mount之后，rename datafile时报错ORA-01511,ORA-01121,ORA-01110
SQL>
SQL> ALTER DATABASE RENAME FILE "+DATA/rac/datafile/system.416.833384105" TO "+TESTDG/rac/datafile/system.dbf";
ALTER DATABASE RENAME FILE "+DATA/rac/datafile/system.416.833384105" TO "+TESTDG/rac/datafile/system.dbf"
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01121: cannot rename database file 1 - file is in use or recovery
ORA-01110: data file 1: "+DATA/rac/datafile/system.416.833384105"分析：
只所以出现这种情况因为我的DB是RAC环境，另一个节点是open状态，导致出现上面报错。解决方案：
关闭另一个节点的实例。
[Oracle@saprac4 ~]$ dbaSQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 5 16:15:06 2013Copyright （c） 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing optionsSQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>SQL>
再在节点1上执行rename datafile。
SQL> ALTER DATABASE RENAME FILE "+DATA/rac/datafile/system.416.833384105" TO "+TESTDG/rac/datafile/system.dbf";Database altered.SQL>
SQL>
SQL> ALTER DATABASE RENAME FILE "+DATA/rac/datafile/sysaux.417.833384107" TO "+TESTDG/rac/datafile/sysaux.dbf";
ALTER DATABASE RENAME FILE "+DATA/rac/datafile/undotbs1.418.833384107" TO "+TESTDG/rac/datafile/undotbs1.dbf";
ALTER DATABASE RENAME FILE "+DATA/rac/datafile/users.419.833384109" TO "+TESTDG/rac/datafile/users.dbf";
ALTER DATABASE RENAME FILE "+DATA/rac/datafile/undotbs2.424.833384491" TO "+TESTDG/rac/datafile/undotbs2.dbf";
Database altered.SQL>
Database altered.SQL>
Database altered.SQL>Database altered.SQL>
SQL>
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: "+TESTDG/rac/datafile/system.dbf"
SQL> recover database;
Media recovery complete.
SQL> alter database open;Database altered.SQL> select name from v$datafile;NAME
--------------------------------------------------------------------------------
+TESTDG/rac/datafile/system.dbf
+TESTDG/rac/datafile/sysaux.dbf
+TESTDG/rac/datafile/undotbs1.dbf
+TESTDG/rac/datafile/users.dbf
+TESTDG/rac/datafile/undotbs2.dbfSQL>更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12相关阅读：ORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htmORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htmORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htmORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htmORA-00314,redolog 损坏，或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htmORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm使用RMAN迁移数据文件操作步骤（RAC-ASM环境）Oracle的数据表压缩相关资讯 ORA-01110 ORA-01511 ORA-01121

ORA-00376/ORA-01110 故障处理办法（今 09:01）
ORA-01157&ORA-01110故障解决（07/17/2015 12:48:04）
legato备份不成功,报ORA-00604, （06/14/2014 21:10:16）

备库查询导致的ORA-01110错误及修（04月16日）
rman备份恢复到异机报ORA-01110 （08/02/2014 14:26:57）
ORA-01578 ORA-01110 坏块解决方法（01/04/2014 09:00:35）

本文评论查看全部评论（0）