Posts

Transporting Data to a Different Operating System

If you want to perform a cross-platform upgrade, you need to know the restrictions and guidelines of this method.

When using DBUA or performing a manual upgrade for Oracle Database, you cannot directly migrate or transport data in a database on one operating system to another operating system. For example, you cannot migrate data in an Oracle database on Solaris to an Oracle 19c database on Windows using DBUA. You must follow procedures specific to your operating system platforms.

To see the platforms that support cross-platform data transport, run the following query using SQL*Plus:

SELECT * FROM V$TRANSPORTABLE_PLATFORM ORDER BY PLATFORM_NAME;
If the source platform and the target platform are of different endianness, then you cannot use the RMAN CONVERT DATABASE  command. This process requires both the source and target platform to be the same endian value. Your available options are Data Pump replication, Data Pump export/import, or Transportable Tablespace, with an RMAN CONVERT TABLESPACE. If the platforms are of the same endianness, then no conversion is necessary and data can be transported as if on the same platform.

For more information see:

Oracle Database Administrator’s Guide for a discussion of transporting data across platforms

Oracle Database Backup and Recovery User’s Guide for information on using the RMAN CONVERT DATABASE and RMAN CONVERT TABLESPACE commands

/0 Comments/by