oracle 单机改rac,Oracle单机转RAC

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_ORCL_20130612_14_1 100% 234KB 233.5KB/s 00:00 arc_ORCL_20130612_15_1 100% 2560 2.5KB/s 00:00 ctl_ORCL_20130612_16_1 100% 18MB 18.0MB/s 00:01 full_ORCL_20130612_10_1 100% 185MB 8.8MB/s 00:21 full_ORCL_20130612_11_1 100% 55MB 13.6MB/s 00:04 full_ORCL_20130612_12_1 100% 18MB 18.0MB/s 00:01 3、目标端安装好完整的RAC(带库)，做恢复

1) 使用原有的参数文件启动数据库到nomount状态

SQL> startup nomount;

2) rman恢复控制文件，启动数据库到mount状态