Oracle单机转RAC.docxVIP

1、rman全备数据库????????RMAN run????????2 {allocate channel c1 type disk;????????3 allocate channel c2 type disk;????????4 backup database format /oracle/back/full_%d_%T_%s_%p;????????5 sql alter system archive log current;????????6 backup archivelog all format /oracle/back/arc_%d_%T_%s_%p delete input;????????7 backup current controlfile format /oracle/back/ctl_%d_%T_%s_%p;????????8 }2、将所有备份集移动到目标rac节点上???????????[oracle@standby back]$ scp * node1:/oracle/back/????????arc_ORCL14_1???????????????? 100%? 234KB 233.5KB/s?? 00:00???????????arc_ORCL15_1???????????????? 100%???? 2560?? 2.5KB/s?? 00:00???????????ctl_ORCL16_1???????????????? 100%?? 18MB? 18.0MB/s?? 00:01???????????full_ORCL10_1??????????????? 100%? 185MB?? 8.8MB/s?? 00:21???????????full_ORCL11_1??????????????? 100%?? 55MB? 13.6MB/s?? 00:04???????????full_ORCL12_1??????????????? 100%?? 18MB? 18.0MB/s?? 00:013、目标端安装好完整的RAC（带库），做恢复????1) 使用原有的参数文件启动数据库到nomount状态????????SQL startup nomount;????2) rman恢复控制文件，启动数据库到mount状态????????RMAN restore controlfile from /oracle/back/ctl_ORCL16_1;????????RMAN alter database mount;????3) 将备份集注册到rman中???????????catalog backuppiece /oracle/back/arc_ORCL14_1;????????catalog backuppiece /oracle/back/arc_ORCL15_1;????????catalog backuppiece /oracle/back/full_ORCL10_1;????????catalog backuppiece /oracle/back/full_ORCL11_1;????????catalog backuppiece /oracle/back/full_ORCL12_1;????????catalog backuppiece /oracle/back/full_ORCL13_1;????3) 恢复数据文件（注意要set newname）???????????????run????????{allocate channel c1 type disk;????????allocate channel c2 type disk;????????set newname for datafile /oradata/orcl/system01.dbf to +DATA01;????---只指定DG名????????set newname for datafile /oradata/orcl/sysaux01.dbf to +DATA01;????????set newname for datafile /oradata/orcl/undotbs01.dbf to +DATA01;????????set newname for datafile /oradata/orcl/users01.dbf to +DATA01;????????restore