mysql异构迁移_convert database异构同字节迁移

最近有项目需要异构迁移，源平台是windows 64bit的，需要迁移到linux 64bit的，数据库平台是oracle 10.2.0.4 64bit的，这里主要想讨论的迁移方式是oracle rman的convert database。 官档中有一个简要的说明： Restrictions on CONVERT DATABASE The primary

最近有项目需要异构迁移，源平台是windows 64bit的，需要迁移到linux 64bit的，数据库平台是oracle 10.2.0.4 64bit的，这里主要想讨论的迁移方式是oracle rman的convert database。

官档中有一个简要的说明：

Restrictions on CONVERT DATABASE

The primary additional restriction on transporting entire databases is that the source and target platform must share the same endian format. For example, while you can transport a database from Microsoft Windows to Linux for x86 (both little-endian), or from HP-UX to AIX (both big-endian), you cannot transport a whole database from Solaris to Linux to x86 using this feature. You can, however, create a new database on a target platform manually, and transport individual tablespaces from the source database using the RMAN CONVERT TABLESPACE or CONVERT DATAFILE commands.

Oracle 10g 已经有了convert database，可以转换迁移同字节的oracle database，但是如果是不同的字节，那么convert database无法完成，此时只能使用tts来迁移个别的tablespace

Convert database有以下需要注意的地方：

Also note that some parts of the database are not transported directly:

?Redo log files and control files from the source database are not transported. New control files and redo log files are created for the target database during the transport process, and an OPEN RESETLOGS is performed once the new database is created.

?the output for the CONVERT DATABASE command, but users must copy the BFILEs themselves and fix their locations on the target platform.

?Datafiles for locally managed temporary tablespaces are not transported. The temporary tablespaces are re-created at the target platform by running the transport script.

?External tables and directories are not transported. RMAN provides a list of affected objects as part of the output of the CONVERT DATABASE command, but users must redefine these on the target platform. See Oracle Database Administrator's Guide for more information on managing external tables and directories.

?Password files are not transported. If a password file was used with the source database, the output of CONVERT DATABASE includes