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?
A.
Use transportable table spaces to migrate data to the new environment.
B.
Use Data Guard logical standby to reproduce data on the new system.
C.
Use Data Guard physical standby to migrate data to the new system.
D.
Use ASM to rebalance data from the old system to the new system.
E.
Use Data Pump to move data to the new system.
Explanation:
There are two migration options:
A) Physical Migration
• Move entire table spaces and data files
• Do not look at the data inside
• Easiest way to migrate (if it is possible)
B) Logical Migration
• Get the data out
• Data pump
• Import/Export
• Dump to files
• Golden Gate / Streams
• More difficult to setup
• More flexible
1)If source is on Linux and 11.x
• Data Guard Physical Standby
• Transportable Database
• Restore backup to Exadata2) 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
http://docs.google.com/viewer?a=v&q=cache:btGrvQ3QxVUJ:ogh.nl/downloads/OGH20100914_O
racle_Exadata_-_Robert_Pastijn_(Oracle).pdf+Exadata+Database+migrate+using+Data+Guard+physical+standby
+If+source+is+%3C10.2&hl=en&gl=in&pid=bl&srcid=ADGEESjPM0BvJUJ_z_oXBxajzmTQ1x1GjE
EmV_OLfEahwLENTlVg89h8gIzpRy9bBETs2KhIH6TVV1CAqEd8yKigw9bYuR2kDEPc8Kx75WuspAPGZWg6
wOmhprObxHsPV65IcImhuCC&sig=AHIEtbRLknKbX7YL_nSwUlK2mwmC-8Ivnghttp://docs.google.com/viewer?a=v&q=cache:wRYLeYKLMt8J:www.oracle.com/technetwork/datab
ase/features/availability/xmigration-11-133466.pdf+Exadata+Database+migrate+using+Data+Guard+physical+standby+from+Linux+mac
hine+to+Oracle+Exadata+Database+Machine&hl=en&gl=in&pid=bl&srcid=ADGEESgf0c36ot1GSJ
p5mlA0CHjOB57wun8QRInHZga_F-Hx97x1yVTf-0Mx64X1MWZ6A-JzpnJmSzLV_8pSLqA2auNztoZS4SkNTMA92GnXM0IfInrnQyU5X5c_Yp8Sk2OtCgTwDm&sig=AHIEtbRzWchIdonXHeCnlDmStS75Rveagg