MES数据库存储迁移Action_PROD(5)

Oracle RAC 迁移解决方案(存储迁移)

贝：

rman target / <<EOF

copy datafile '+ORADATA1/cmesrel/datafile/system.262.858768375' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/undotbs1.263.858768383' to '+ORADATA/'; copy datafile '+ORADATA1/cmesrel/datafile/sysaux.264.858768399' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/undotbs2.265.858768407' to '+ORADATA/'; copy datafile '+ORADATA1/cmesrel/datafile/users.266.858768423' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.267.858768425' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.268.858768473' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.269.858768487' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.270.858768501' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.271.858768521' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.276.858768545' to '+ORADATA/';

copy datafile '+ORADATA1/cmesrel/datafile/mes_dt.277.858768561' to '+ORADATA/';

…(略，详见MES_Prod_Storage切换His.txt)

…

…

EOF

nohup sh rman.sh > rman.log &

DataBase cmeshis

select 'copy datafile '||''''||file_name||''''||' to '||''''||'+ORADATA/'||''';' from dba_data_files;

产生脚本文件，考虑到在不影响生产的情况下，采用一个进程处理，不开启并行拷贝：

rman target / <<EOF

…(略，详见MES_Prod_Storage切换His.txt)

…

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.526.858875635' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.525.858875621' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.524.858875605' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.523.858875589' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.522.858875575' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.521.858875559' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/mes_dt.520.858875523' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/users.519.858875523' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/undotbs2.518.858875507' to '+ORADATA/'; copy datafile '+ORADATA1/cmeshis/datafile/sysaux.517.858875501' to '+ORADATA/';

copy datafile '+ORADATA1/cmeshis/datafile/undotbs1.516.858875483' to '+ORADATA/'; copy datafile '+ORADATA1/cmeshis/datafile/system.515.858875471' to '+ORADATA/';

EOF

查看Log确认Copy结果