Migrate tablespace and data files from ASM to the file system

Migrate tablespace and data files from ASM to file system 1.2.1. tablespace and data file migration-from ASM to the file system www.2cto.com RMAN> backup as copy datafile 5 format'/u01/oracle/10g/oradata/gt10g/gtlions01.dbf '; starting backup at 25-FEB-13using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyinput datafile fno = 00005 name = + DATA01/gt10g/datafile/platform =/u01/oracle/10g/oradata/gt10g/gtlions01.dbf tag = platform = 121 stamp = 808327359 channel ORA_DISK_1: datafile copy complete, elapsed time: 00: 00: 01 Finished backup at 25-FEB-13 RMAN> backup as copy datafile 6 format'/u01/oracle/10g/oradata/gt10g/gtlions02.dbf '; starting backup at 25-FEB-13using channel ORA_DISK_1channel ORA_DISK_1: starting datafile copyinput datafile fno = 00006 name = + DATA01/gt10g/datafile/platform =/u01/oracle/10g/oradata/gt10g/gtlions02.dbf tag = platform = 122 stamp = 808327367 channel ORA_DISK_1: datafile copy complete, elapsed time: 00: 00: 01 Finished backup at 25-FEB-13 RMAN> switch datafile 5 to copy; datafile 5 switched to datafile copy "/u01/oracle/10g/oradata/gt10g/gtlions01.dbf" RMAN> switch datafile 6 to copy; datafile 6 switched to datafile copy "/u01/oracle/10g/oradata/gt10g/gtlions02.dbf" RMAN> SQL 'alter tablespace gtlions online'; SQL statement: alter tablespace gtlions online RMAN> report schema; report of database schema List of Permanent Datafiles ============================ File Size (MB) tablespace RB segs Datafile Name ---- -------- ------------------ lifecycle 1 440 SYSTEM ***/u01/oracle/10g/oradata/gt10g/system01.dbf2 25 UNDOTBS1 ***/u01/oracle/10g /oradata/gt10g/undotbs1.dbf3 250 SYSAUX ***/u01/oracle/10g/oradata/gt10g/sysaux01.dbf4 5 USERS ***/u01/oracle/10g/oradata/gt10g /users01.dbf5 10 GTLIONS ***/u01/oracle/10g/oradata/gt10g/gtlions01.dbf6 10 GTLIONS ***/u01/oracle/10g/oradata/gt10g/upload List temporary Files =============================== File Size (MB) tablespace Maxsize (MB) tempfile Name ---- -------- ------------------ bytes 1 100 TEMP 100/u01/oracle/10g/oradata/gt10g/temp01.dbf4 100 GTLIONSTEMP 100/u01/oracle/10g/oradata/gt10g/PostgreSQL> Select ts #, name From v $ tablespace WhereName = 'gtlions' 2 Union All 3 Select file #, Name From v $ datafile Wherets # = 7; TS # NAME --- iis7 GTLIONS 5/u01/oracle/10g/oradata/gt10g/gtlions01.dbf 6/u01/oracle/10g/oradata/gt10g/gtlions02.dbf-The End-