Your customer wants to migrate their current large Oracle database to an Oracle Exadata Database Machine. They are currently running Oracle 10.1.0.3 on Linux. Which method could they use to migrate…

The correct answer is B. Logical Migration. There are two migration options: Move entire table spaces and data files Do not look at the data inside Easiest way to migrate (if it is possible) Get the data out Golden Gate / Streams More difficult to setup 1)If source is on Linux and 11.x Data Guard Physical Standby…

High Availability and Backup/Recovery

Question

Your customer wants to migrate their current large Oracle database to an Oracle Exadata Database Machine. They are currently running Oracle 10.1.0.3 on Linux. Which method could they use to migrate with the least amount of downtime?

Exhibit

Options

APhysical Migration
BLogical Migration
CUse Data Guard physical standby to migrate data to the new system.
DUse ASM to rebalance data from the old system to the new system.
EUse Data Pump to move data to the new system.

How the community answered

(53 responses)

A
11% (6)
B
79% (42)
C
4% (2)
D
4% (2)
E
2% (1)

Explanation

There are two migration options: Move entire table spaces and data files Do not look at the data inside Easiest way to migrate (if it is possible) Get the data out Golden Gate / Streams More difficult to setup 1)If source is on Linux and 11.x Data Guard Physical Standby Transportable Database Restore backup to Exadata 2) If source is on >10.2 Cross-Platform Transportable tablespaces Possible need of an Endian Change (using RMAN) on intermediate storage 3) If source is <10.2 Upgrade first to 10.2 Or choose for Logical migration

Topics

#logical migration#downtime minimization#database migration#Oracle version upgrade

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice