Environment: 11.2.0.1 + RHEL5.8 reference documentation id:1678747.1 1. Simulate creating a node: sql> create tablespace tdb datafile '/u02/app/oracle/datafile/td
b.dbf ' size 10m autoextend off;
Tablespace created. 2. View data File One node: file# NAME----------------------------------------------------------------------------------------- ---------------------4 +data/orcl/datafile/users.257.901333687 3 +data/orcl/datafile/undotbs1.264.90133 3687 2 +data/orcl/datafile/sysaux.256.901333685 1 +data/orcl/datafile/system.265.901333685 5 +D ata/orcl/datafile/undotbs2.266.901333943 6/u02/app/oracle/datafile/tdb.dbf Two node: sql> select File_name,file_i
D,online_status,tablespace_name from Dba_data_files; Error:ora-01157:cannot identify/lock data file 6-see DBWR trace file Ora-01110:data file 6: '/u02/app/oracle/datafile
/TDB.DBF ' 3. Offline the data file sql> ALTER DATABASE datafile 6 offline;
Database altered. 4. Use RMAN to move local files to ASM rman> copy datafile '/U02/APP/ORACLE/DATAFILE/TDB.DBf ' to ' +data ';
Starting backup at 03-FEB-16 using target database control file instead of recovery catalog allocated Channel:ora_disk_1 Channel ora_disk_1:sid=35 INSTANCE=ORCL1 device Type=disk Channel-ora_disk_1:starting datafile copy input datafile file number=00006 name=/u02/app/oracle/datafile/tdb.dbf output File name=+data/orcl/datafile/tdb.268.902813699 tag= tag20160203t053456 recid=1 stamp=902813699 Channel ora_disk_1:datafile copy complete, elapsed time:00:00:03 finished BAC Kup at 03-feb-16 5. rename file sql> alter DATABASE rename file '/u02/app/oracle/datafile/tdb.dbf ' to ' +data/orcl/datafile/t
db.268.902813699 ';
Database altered. 6. View 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.901333685 1 System System +data/orcl/da tafile/undotbs2.266.901333943 5 ONLINE UNDOTBS2 +data/orcl/datafile/tdb.dbf
6 RECOVER TDB 7. 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 TDB 8. Data file online sql> alter
Database datafile 6 online;
Database altered. 9. 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 online Sysaux +data/orcl/datafile/system.265.901333685 1 System System +data/orcl/datafile/undotbs 2.266.901333943 5 ONLINE UNDOTBS2 +data/orcl/datafile/tdb.dbf 6 ONLINE TDB