You plan to migrate your Oracle Version 11.1.0.2 database to your Exadata Database Machine.
The database supports an online transaction processing (OLTP) workload and is currently hosted
on a Little Endian platform
Which two are the supported and appropriate migration methods to minimize downtime?
A.
Upgrade source database to 11.2.0 and migrate using a physical standby database.
B.
Migrate using Data Pump.
C.
Migrate using GoldenGate.
D.
Migrate using cross platform Transportable Database.
E.
Migrate using ASM online migration.
Explanation:
B:Oracle Data Pump can be used to migrate an Oracle database to a new platform,
and to move
from an older release of the database to a newer release. Using Oracle Data Pump to move an
E-Business Suite database is a well-documented and tested procedure, and can be used to
migrate
your database to the Oracle Exadata Database Machine and upgrade it to Oracle Database 11g
release 2 (11.2) in the same exercise
Reference:Migrating the Oracle E-Business Suite Database to Oracle Exadata Database Machine
UsingTransportable Tablespaces
Reference:Migrating Oracle E-Business Suite to Oracle Exadata Database Machine Using Oracle
Data Pump
The correct answer is A and C. The hint is which methods “minimize downtime”. Data Pump and Transportable tablespace both require more downtime than A or C.
A- wrong no need to upgrade to 11.2 for physical standby as it is little endian
D-wrong must upgrade to 11.2 for this work
E-Must be on 11.2
So answers are B,C
A is wrong. same endian does not mean the same OS. So standby may not work
B is right. Data Pump is supported although it might be slow if data set is large
C is right. Golden Gate is good for zero downtime migration
D is wrong. Transportable Database requires 11.2
E is wrong. ASM online migration requires ASM and AU=4M
so B.C are correct
B not correct: surely consume significant time, database creation, configuration, export data and import data (need downtime)
A) Windows/Linux are Little Endian, physical standby is possible. But, to match up with Exa DB version, i.s, 11.2, you need to upgrade first and configure physical standby.
C & D also not correct : for both options, the source DB must be in 11.2.
No downtime needed in data pump.
Upgrade will require downtime
B & C
A is wrong becoz little endian maybe Windows
D is wrong becoz transportable database requires 11.2
E is wrong becoz little endian maybe Windows