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' ;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步