问题描述
- 您好,请教一个ORACLE跨OS数据迁移问题
- PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
6 AIX-Based Systems (64-bit) Big 18 IBM Power Based Linux Big 2 Solaris[tm] OE (64-bit) Big 4 HP-UX IA (64-bit) Big 16 Apple Mac OS Big 1 Solaris[tm] OE (32-bit) Big 9 IBM zSeries Based Linux Big 3 HP-UX (64-bit) Big 17 Solaris Operating System (x86) Little 20 Solaris Operating System (x86-64) Little 12 Microsoft Windows x86 64-bit Little
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
13 Linux x86 64-bit Little 8 Microsoft Windows IA (64-bit) Little 19 HP IA Open VMS Little 11 Linux IA (64-bit) Little 5 HP Tru64 UNIX Little 10 Linux IA (32-bit) Little 7 Microsoft Windows IA (32-bit) Little 15 HP Open VMS Little
19 rows selected.
源库
SQL> select platform_name from v$database;PLATFORM_NAME
AIX-Based Systems (64-bit)
SQL> select sum(bytes/1024/1024/1024) GB from dba_segments; --逻辑大小
GB
303.956665SQL> select sum(bytes/1024/1024/1024) GB from dba_data_files; ----物理大小
GB
480.219727目标平台是pc server 。
计划安装RHEL 5.4 x86_64 操作系统。--目标平台PLATFORM_NAME为 Linux x86 64-bit。存储;
源库:纯裸设备(参数文件,控制文件,redo logdata file)。
目标库:裸设备 或 ASM。(还未确定)。需求:
将AIX 平台ORACLE RAC 10.2.0.4 迁移到 linux 平台 ORACLE RAC 10.2.0.4 。
迁移过程中源库可以停机。
用什么方式可以实现数据无损的快速的迁移到新的平台上呢。
时间: 2024-10-03 11:46:22