Database open Archive mode, non-system tablespace data File migration can not stop the database. <span><span> when moving, be aware of ASM disk space. </span></span>1. 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. Move the data file offlinesql> ALTER DATABASE datafile 6 offline;database Altered.4. Moving data files under Asmcmd to +data/orcl/ Datafile/asmcmd [+dAta/orcl/datafile] > cp/u02/app/oracle/datafile/tdb.dbf copying/u02/app/oracle/datafile/tdb.dbf-+data/ Orcl/datafile/tdb.dbf5. Renaming a file sql> ALTER DATABASE rename file '/u02/app/oracle/datafile/tdb.dbf ' to ' +data/orcl/ DATAFILE/TDB.DBF ';D atabase Altered.6. View data File status file_name file_id onlin E_ tablespace_name--------------------------------------------------------------------------------------------- ------------------------+data/orcl/datafile/users.257.901333687 4 ONLINE Users+data/orcl/da tafile/undotbs1.264.901333687 3 ONLINE undotbs1+data/orcl/datafile/sysaux.256.901333685 2 ONLINE sysaux+data/orcl/datafile/system.265.901333685 1 system SYS tem+data/orcl/datafile/undotbs2.266.901333943 5 ONLINE undotbs2+data/orcl/datafile/tdb.dbf 6 RECOVERTDB7. 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.90133394 3 5 ONLINE undotbs2+data/orcl/datafile/tdb.dbf 6 OFF Line TDB8. Convert data files 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+data/orcl/datafile/sysaux.256.901333685 2 online SY saux+data/orcl/datafile/system.265.901333685 1 System system+data/orcl/datafile/undotbs2.266 .901333943 5 ONLINE undotbs2+data/orcl/datafile/tdb.dbf 6 ONLINE TDB
Data files in RAC are created to local path (non-system tablespace)