This note briefly describes the steps required to perform a cross platform database migration (AIX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2 which is attained with zero downtime using a combination of RMAN, Cross Platform TTS and GoldenGate to achieve the same. This is the environment that […]
In one of my earlier posts How To Transport a Tablespace from 10g ASM to 11g ASM on AIX we discussed how to transport a tablespace stored on ASM storage from Windows to AIX using the DBMS_FILE_TRANSFER package. We will now look at how the same thing can be done using FTP with Oracle XML […]
This example demonstrates how to transport a tablespace from a 10g ASM on Windows environment to 11g ASM on AIX environment using the DBMS_FILE_TRANSFER package. The source database on Windows is GENUA1 and the target database is a 11g RAC database RACDB1. Create the tablespace and the test object in the source database SQL> create […]
This note decribes in detail the steps used to migrate a 1.4 TB Oracle 10g database from an AIX platform to a Red Hat Linux platform with minimal downtime using the Cross Platform TTS technology introduced in Oracle 10g.