Environment: 11.2.0.1 + RHEL6.5 Reference Document ID:1678747.11. Simulate creating a node:sql> create tablespace tdb datafile '/u02/app/oracle/datafile/ tdb.dbf ' size 10m autoextend off; Tablespace Created.2. Viewing a data File node: file# NAME----------------------------------------------------------------------- ---------------------------------------4 +data/orcl/datafile/users.257.901333687 3 +data/orcl/datafile/un dotbs1.264.901333687 2 +data/orcl/datafile/sysaux.256.901333685 1 +data/orcl/datafile/system.265.901333685 5 +data/orcl/datafile/undotbs2.266.901333943 6/u02/app/oracle/datafile/tdb.dbf Two node:sql> select File_na Me,file_id,online_status,tablespace_name from Dba_data_files; Error:ora-01157:cannot identify/lock data file 6-see DBWR trace fileora-01110:data file 6: '/u02/app/oracle/datafile/t DB.DBF ' 3. Convert the data file offlinesql> ALTER DATABASE datafile 6 offline;database Altered.4. Use Rman to move local files to asmrman> copy DataFile '/u02/app/oracle/datafile/tdb.dbf ' to ' +data '; Starting backup at03-feb-16using Target Database control file instead of recovery catalogallocated Channel:ora_disk_1channel Ora_disk_1:si d=35 INSTANCE=ORCL1 device Type=diskchannel ora_disk_1:starting datafile copyinput datafile file number=00006 name=/u02/ App/oracle/datafile/tdb.dbfoutput file name=+data/orcl/datafile/tdb.268.902813699 tag=TAG20160203T053456 RECID=1 Stamp=902813699channel ora_disk_1:datafile copy complete, elapsed time:00:00:03finished backup at 03-feb-165. renaming files sql& Gt Alter DATABASE rename file '/u02/app/oracle/datafile/tdb.dbf ' to ' +data/orcl/datafile/tdb.268.902813699 ';D atabase Altered.6. viewing data File status 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 ONLINE sysaux+data/orcl/datafile/system.265.90133 3685 1 SYSTEM system+data/orcl/datafile/undotbs2.266.901333943 5 ONLINE undotbs2+data/orcl/datafile/tdb.dbf 6 RECOVER TDB7. RECOVER The data file sql> Recover DataFile 6; Media recovery complete. 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 online sysaux+data /orcl/datafile/system.265.901333685 1 System system+data/orcl/datafile/undotbs2.266.901333943 5 ONLINE undotbs2+data/orcl/datafile/tdb.dbf 6 OFFLINE TDB8. Convert the data file onlinesql> ALTER DATABASE datafile 6 online;database Altered.9. Checking data files 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+d ata/orcl/datafile/sysaux.256.901333685 2 ONLINE sysaux+data/orcl/datafile/system.265.9013336 1 SYSTEM system+data/orcl/datafile/undotbs2.266.901333943 5 on Line UNDOTBS2+DATA/ORCL/DATAFILE/TDB.DBF 6 ONLINE TDB
Data files in RAC are created to local path (non-system tablespace) using Rman transfer