一楼送老百

转自 http://www.eygle.com/archives/2005/12/oracle_howto_move_datafile_raw.html
SQL> alter tablespace eygle offline;Tablespace altered.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options[oracle@danaly ~]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Wed Nov 30 16:00:42 2005Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: DANALY (DBID=3965153484)RMAN> copy datafile '/dev/cciss/c0d0p11' to '/opt/oracle/eygle01.dbf'; Starting backup at 30-NOV-05using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=137 devtype=DISKchannel ORA_DISK_1: starting datafile copyinput datafile fno=00002 name=/dev/cciss/c0d0p11output filename=/opt/oracle/eygle01.dbf tag=TAG20051130T160137 recid=2 stamp=575740898channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02Finished backup at 30-NOV-05RMAN> exitRecovery Manager complete.SQL> alter tablespace eygle offline;Tablespace altered.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options同时RMAN也可以完成从ASM到RAW的迁移