Renamedatafile reports error ORA-01511, ORA-01121, ORA-01110

Renamedatafile reports error ORA-01511, ORA-01121, ORA-01110

Rename datafile reports error ORA-01511, ORA-01121, ORA-01110

Symptom:
After the instance is started to mount, rename datafile reports an error 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'

Analysis:
This is the case because my DB is in the RAC environment and the other node is in the open state, resulting in the above error.

Solution:
Close the instance of another node.
[Oracle @ saprac4 ~] $ Dba

SQL * Plus: Release 11.1.0.6.0-Production on Thu Dec 5 16:15:06 2013

Copyright (c) 1982,200 7, Oracle. All rights reserved.

Connected:
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 options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

SQL>
Then run rename datafile on node 1.
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.ux.8333820.7' TO '+ TESTDG/rac/datafile/sysaux. dbf ';
Alter database rename file '+ DATA/rac/datafile/undotbs1.418.8333820.7' 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.20..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.dbf

SQL>

Related reading:

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store

,