迁移ORACLE数据库文件到ASM

迁移数据文件到ASM

数据库一致性情况下迁移:将数据库启动到mount状态,生成rman copy 语句,然后在rman中执行:

SQL> startup mountSQL> select q'(copy datafile ')'||name||q'(' to '+oradata';)' from v$datafile;Q'(COPYDATAFILE')'||NAME||Q'('TO'+ORADATA';)'-------------------------------------------------------------------------------copy datafile 'D:\NSOADP\SYSTEM01.DBF' to '+oradata';copy datafile 'D:\NSOADP\SYSAUX01.DBF' to '+oradata';copy datafile 'F:\NSOADP\UNDOTBS01.DBF' to '+oradata';copy datafile 'D:\NSOADP\USERS01.DBF' to '+oradata';SQL> exitD:\>rman target /RMAN> run2> {3> copy datafile 'D:\NSOADP\SYSTEM01.DBF' to '+oradata';4> copy datafile 'D:\NSOADP\SYSAUX01.DBF' to '+oradata';5> copy datafile 'F:\NSOADP\UNDOTBS01.DBF' to '+oradata';6> copy datafile 'D:\NSOADP\USERS01.DBF' to '+oradata';7>}启动 backup 于 2015-04-15 10:02:44使用通道 ORA_DISK_1通道 ORA_DISK_1: 启动数据文件副本输入数据文件: 文件号=00001 名称=D:\NSOADP\SYSTEM01.DBF输出文件名=+ORADATA/nsoa/datafile/system.260.877082571 标记=TAG20150415T100250 RECID=265 STAMP=877082603通道 ORA_DISK_1: 数据文件复制完毕, 经过时间: 00:00:35完成 backup 于 2015-04-15 10:03:25……

原标题：迁移ORACLE数据库文件到ASM

关键词：数据库