SnapAssure迁移ASM+RAC库到单节点文件系统

recover controlfile from '恢复后的控制文件全路径';

创建adump、bdump、cdump、udump目录;

修改pfile里的各个参数。 startup mount pfile='/xxx/init.ora';

alter database rename file '+DATA/rac/datafile/undotbs1.260.781442329' to   '/backup/oradata/undotbs1.260.781442329'; alter database rename file '+DATA/rac/datafile/sysaux.261.781442329'  to  '/backup/oradata/sysaux.261.781442329'  ; alter database rename file '+DATA/rac/datafile/undotbs2.263.781442331'  to  '/backup/oradata/undotbs2.263.781442331'; alter database rename file '+DATA/rac/datafile/users.264.781442333'  to '/backup/oradata/users.264.781442333' ;  alter database rename file '+DATA/rac/datafile/test01.dbf'  to '/backup/oradata/test01.dbf';   

alter database rename file '+DATA/rac/onlinelog/group_1.257.781442325' to  '/backup/oradata/group_1.257.781442325' ; alter database rename file '+DATA/rac/onlinelog/group_2.258.781442325' to  '/backup/oradata/group_2.258.781442325' ; alter database rename file '+DATA/rac/onlinelog/group_3.265.781443203' to  '/backup/oradata/group_3.265.781443203' ; alter database rename file '+DATA/rac/onlinelog/group_4.266.781443205' to  '/backup/oradata/group_4.266.781443205' ; alter database rename file '+DATA/rac/onlinelog/group_5.269.781465249' to  '/backup/oradata/group_5.269.781465249' ; alter database rename file '+DATA/rac/onlinelog/group_6.270.781465267' to  '/backup/oradata/group_6.270.781465267' ;

原文地址:https://www.cnblogs.com/luoyx/p/2492140.html