Oracle跨平台迁移



AIX_TO_LINUX oracle 数据库迁移方案



目录

四种迁移方案对比 

一、 使用数据泵迁移数据 

迁移前原环境检查及备份

目标环境准备 

原环境数据导出 

迁移后的验证 

处理验证过程中发现的问题 

收集统计信息 

三、使用增量  迁移数据 

先决条件检查 

 初始化设置 

 使用  备份方法的准备阶段 

 前滚阶段 

 最后的传输阶段 

 验证 



四种迁移方案对比

迁移方案 停机时间 复杂度 准备时间 磁盘临时额外空间需求 适用场景

数据泵 最长 简单 短

1.

使用

NFS

共享：需要等于当前数据

库数据量的磁盘空间

2.

使用独立的存储空间：需要等于两

倍当前数据库容量的磁盘空间

3.

dblink

1.

使用

NFS

共享：略大于需要迁移表

空间容量的磁盘空间

2.

使用独立的存储空间：略大于需要

迁移表空间容量的磁盘空间

使用独立的存储空间：大于两倍需

要迁移表空间容量的磁盘空间

ogg

1.

需要额外的空间用来存放

ogg

的

trail



如发现应用失效对象，需应用维护团队确认该失效对象是否对系统有影响

