The data files in the RAC are created to the local path (system table space)

Reference Documentation: 1607292.1 If the data files for the system tablespace are created locally, then downtime is required. <span><span> when moving, note the ASM disk space. </span></span> 1. Simulate creation node one: sql> alter tablespace system add datafile '/u02/app/oracle/datafile/tsys.dbf '

Size 10m autoextend off;

Tablespace altered. 2. Check data file node one: sql>/file# NAME------------------------------------------------------------4 +data/o rcl/datafile/users.257.901333687 3 +data/orcl/datafile/undotbs1.264.901333687 2 +data/orcl/datafile/sysa 
         ux.256.901333685 1 +data/orcl/datafile/system.265.901333685 5 +data/orcl/datafile/undotbs2.266.901333943 6 +data/orcl/datafile/tdb.dbf 7/u02/app/oracle/datafile/tsys.dbf node two: sql> Select File_name,file_
Id,online_status,tablespace_name from Dba_data_files; Error:ora-01157:cannot identify/lock data file 7-see DBWR trace file Ora-01110:data file 7: '/u02/app/oracle/datafile /TSYS.DBF ' 1.
Offline the data file sql> ALTER DATABASE datafile 7 offline; Alter DATabase datafile 7 Offline * ERROR at line 1:ora-01541:system Tablespace cannot to brought;
Shut down if necessary-this is why downtime is required 4. Execute at one node: sql> shutdown immediate Database closed.
Database dismounted.

ORACLE instance shut down.

Another node: sql> select Open_mode from Gv$database; Open_mode--------------------READ WRITE 5. Use Asmcmd to move local files to ASM Asmcmd [+data/orcl/datafile] > cp/u02/app/oracle/
Datafile/tsys.dbf.
COPYING/U02/APP/ORACLE/DATAFILE/TSYS.DBF-> +data/orcl/datafile/tsys.dbf 6. Start database to mount status sql> startup mount;

ORACLE instance started. Total System Global area 1336176640 bytes Fixed size 2213136 bytes Variable Size 587205360 by

TEs database buffers 738197504 bytes Redo buffers 8560640 Database bytes. 

7. Modify the data file path sql> ALTER DATABASE rename file '/u02/app/oracle/datafile/tsys.dbf ' to ' +data/orcl/datafile/tsys.dbf ' 2;

Database altered.

8. Start database sql> alter DB open; Database altEred. 9. Check data File Status node one: file_name file_id online_ Tablespace_name------------------- ------------------------------------------------------------------------------+data/orcl/datafile/ users.257.901333687 4 ONLINE USERS +data/orcl/datafile/undotbs1.264.901333687 3 Onli NE UNDOTBS1 +data/orcl/datafile/sysaux.256.901333685 2 ONLINE sysaux +data/orcl/datafile/system.265.9 01333685 1 System System +data/orcl/datafile/undotbs2.266.901333943 5 ONLINE Undotbs                                2 +data/orcl/datafile/tdb.dbf 6 ONLINE TDB +DATA/ORCL/DATAFILE/TSYS.DBF
7 System System node two: sql> select File_name,file_id,online_status,tablespace_name from Dba_data_files; Error:ora-01157:cannot identify/lock data file 7-see DBWR trace file Ora-01110:data file 7: ' +data/orcl/datafile/tsys . dbf ' 10. So the last step is to restart node two sql> shutDown immediate Database closed.
Database dismounted.
ORACLE instance shut down.

Sql> Startup ORACLE instance started. Total System Global area 1336176640 bytes Fixed size 2213136 bytes Variable Size 486542064 by
TEs database buffers 838860800 bytes Redo buffers 8560640 Database bytes.

Database opened. 11. Check the data file file_name file_id online_ tablespace_name--------------- ------------------------------------------------------------------------------------------------------+data/                             orcl/datafile/users.257.901333687 4 ONLINE users +data/orcl/datafile/undotbs1.264.901333687 3 ONLINE UNDOTBS1 +data/orcl/datafile/sysaux.256.901333685 2 ONL INE sysaux +data/orcl/datafile/system.265.901333685 1 System System +data/orcl/datafile/und             otbs2.266.901333943               5 Online UNDOTBS2 +data/orcl/datafile/tdb.dbf 6 online tdb +dat


A/ORCL/DATAFILE/TSYS.DBF 7 System System 7 rows selected.
 Ok.