[go: up one dir, main page]
Scribd
Upload
207 views13 pages

Exadata Migration

This document discusses different strategies for migrating a database to an Exadata machine. It outlines both physical and logical migration methods. The physical methods include using a physical standby database, transportable database, or transportable tablespaces. The logical methods include using a logical standby, GoldenGate, Data Pump export/import, or insert as select statements. It also notes that moving data directly to the Exadata storage can help avoid bottlenecks that are not always due to the network.

Uploaded by

KanjaFit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
207 views13 pages

Exadata Migration

This document discusses different strategies for migrating a database to an Exadata machine. It outlines both physical and logical migration methods. The physical methods include using a physical standby database, transportable database, or transportable tablespaces. The logical methods include using a logical standby, GoldenGate, Data Pump export/import, or insert as select statements. It also notes that moving data directly to the Exadata storage can help avoid bottlenecks that are not always due to the network.

Uploaded by

KanjaFit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Migrating Database to an

Exadata Machine

Migrating to Exadata

Migration Goal

Migration Strategy

Migration Strategy

Migration Methods

Migration Methods

Physical Migration methods


Method

Details

1.) Physical Standby


Lowest Downtime

11.1 or later
Limited cross plotform support

2.) Transportable Database(TDB)

RMAN CONVERT DATABASE ON TARGET to generate scripts


Transfer datafile to exadata storage and run scripts

3.) Transportable Tablespaces(TTS)

Build Empty 11.2 Exadata database


TTS Export source system metadata
Transfer files to Exadata
TTS import metatdata in to Exadata database

Logical Migration methods


Method

Details

1.) Logical Standby

11.1 or later
Limited cross plotform support

2.) Golden Gate


Lowest Downtime

Different Source platform


oracle 9.2 or later

3.) Data pump

oracle 10.1 or later


Direct path load
file or netwrok mode

3.) Insert as Select(IAS)

Manually parallelize if dblink


initial bulk load

Fast Network

Bottleneck not always network

Moving Data direct to ASM

Questions?

You might also like