RAC数据库迁移到本地

1,数据库启动到mount状态，复制数据文件！

$$ startup mount copy datafile 1 to '/oradata/data/system.256.835309449'; copy datafile 2 to '/oradata/data/sysaux.257.835309449'; copy datafile 3 to '/oradata/data/undotbs1.258.835309451'; copy datafile 4 to '/oradata/data/users.259.835309451'; copy datafile 5 to '/oradata/data/undotbs2.264.835309617'; copy datafile 6 to '/oradata/data/undotbs3.265.835309619'; copy datafile 7 to '/oradata/data/undotbs4.266.835309619'; copy datafile 8 to '/oradata/data/itreasury.dbf'; copy datafile 9 to '/oradata/data/itreasury2.dbf'; copy datafile 10 to '/oradata/data/itreasury3.dbf'; copy datafile 11 to '/oradata/data/itreasury4.dbf'; copy datafile 12 to '/oradata/data/itreasury5.dbf'; copy datafile 13 to '/oradata/data/itreasury6.dbf'; copy datafile 14 to '/oradata/data/itreasury7.dbf'; copy datafile 15 to '/oradata/data/itreasury8.dbf'; copy datafile 16 to '/oradata/data/system01.dbf'; copy datafile 17 to '/oradata/data/itreasury1.dbf'; copy datafile 18 to '/oradata/data/itreasury9.dbf'; copy datafile 19 to '/oradata/data/itreasury10.dbf'; copy datafile 20 to '/oradata/data/sysaux.287.840290013'; copy datafile 21 to '/oradata/data/users01.dbf'; copy datafile 22 to '/oradata/data/ogg.304.1030128099'; switch database to copy; $$

2，复制控制文件到本地，并更改控制文件位置

$$ copy current controlfile to '/oradata/data/ctl01.ctl'; alter system set control_files='/oradata/data/ctl01.ctl' scope=spfile; $$

3，更改spfile到本地，并重启数据库

create pfile='/oradata/data/pfile.bak' from spfile;
startup mount pfile='/oradata/data/pfile.bak'

4，更改tempfile文件位置
alter database rename file '+DATADG/orcl/tempfile/temp.262.874700019' to '+newdata';
alter database rename file '+DATA/db/tempfile/temp.263.835309539' to '/oradata/data/tmp1.dbf';
alter database rename file '+DATA/db/tempfile/temp.286.840289257' to '/oradata/data/tmp2.dbf';
alter database rename file '+DATA/db/tempfile/temp.297.938962957' to '/oradata/data/tmp3.dbf';
alter database rename file '+DATA/db/tempfile/dbtemp.298.938976505' to '/oradata/data/tmp4.dbf';
alter database rename file '+DATA/db/tempfile/temp.299.938976833' to '/oradata/data/tmp5.dbf';
alter database rename file '+DATA/db/tempfile/temp.300.958492795' to '/oradata/data/tmp6.dbf';
alter database rename file '+DATA/db/tempfile/temp.301.958496011' to '/oradata/data/tmp7.dbf';

5，更改redo文件到本地
alter database add logfile thread 1 group 101 '/oradata/data/redo101' size 50m;
alter database add logfile thread 1 group 102 '/oradata/data/redo102' size 50m;
alter database add logfile thread 4 group 41 '/oradata/data/redo41' size 50m;
alter database add logfile thread 4 group 42 '/oradata/data/redo42' size 50m;
alter database add logfile thread 3 group 31 '/oradata/data/redo31' size 50m;
alter database add logfile thread 3 group 32 '/oradata/data/redo32' size 50m;
alter database add logfile thread 2 group 21 '/oradata/data/redo21' size 50m;
alter database add logfile thread 2 group 22 '/oradata/data/redo22' size 50m;
alter system switch logfile;
alter system checkpoint;

删除多余redo文件

alter database disable thread 3;
alter database drop logfile group 3;
alter database drop logfile group 4;
alter database drop logfile group 5;
alter database drop logfile group 6;
alter database drop logfile group 7;
alter database drop logfile group 8;`

检查redo文件位置

select 'alter database drop logfile member '''||member||''';' from v$logfile where member like '%online%';