Contents
What is cross platform migration?
Starting from 10gR2, Oracle introduced the next magical feature of RMAN its ability to convert the database from one platform to a different one which shares the same endian format. This feature is called Cross-Platform Database Migration.
What is transportable database?
The transportable database method involves copying an entire database, including the SYSTEM tablespace, from one platform to another. Because the whole database is copied, containment checks are unnecessary and no Data Pump export and import are required.
How do I migrate a database to Exadata?
Synchronize Physical database with Primary database on Exadata Machine. Activate the Standby database to make it as Primary. Upgrade the New Primary database on Exadata Database machine. Register the New Primary database into CRS and configure the database as RAC, to run all nodes.
What is transportable tablespace in Oracle?
Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i one of the restrictions was that the block size of both databases must be the same.
What is endian format in Oracle?
In Oracle databases, endian format is determined by the endian information in the environment in which it works. The endian format in the databases tells us which environments the related database can be moved to. It is not possible to move the database with normal methods between different endian environments.
What is Exadata migration?
Oracle Exadata Migration Pack is specifically designed to jump-start the path to success by quickly migrating your Oracle Database while minimizing risk and reducing costs. The migration assessment phase gathers detailed information on the environment that is to be migrated to your Oracle Exadata platform.
What is Oracle TTS?
Oracle Transportable Tablespaces (TTS) With Oracle 8i, Oracle introduced transportable tablespace (TTS) technology that moves tablespaces between databases. Oracle 8i supports tablespace transportation between databases that run on same OS platforms and use the same database block size.
Can You migrate from Oracle 10gR2 to Solaris?
I recently performed a migration from Oracle 10gR2 on Solaris to the same version on Linux, immediately followed by an upgrade to 11g. Both platforms were x86-64.
Do you need to convert database for cross platform migration?
It is important that you read MetaLink Doc 415884.1, if you are performing a migration to a different platform with the same endian. Oracle suggests that you should perform a CONVERT DATABASE, but later admits that you only need to perform a CONVERT on tablespaces containing UNDO segments:
What is cross platform migration in RMAN 10gR2?
Starting from 10gR2, Oracle introduced the next magical feature of RMAN its ability to convert the database from one platform to a different one which shares the same endian format. This feature is called Cross-Platform Database Migration.
What’s the best way to migrate an Oracle Database?
Oracle Zero Downtime Migration (ZDM) is the solution recommended by Oracle Maximum Availability Architecture (MAA) for migrating Oracle Databases to Oracle Cloud. ZDM has been designed with the goals of keeping the migration process as simple as possible and ensuring least impact on production workloads.