Very Huge DB Migration Questions

[tsenol]

Hi All,

We'll make a migration for a 7 TB database from AIX-Oracle to Windows-Oracle. System version is ECC 6.00 with NW 7.00

Can you please give your recommendation for minimum process time? Parallel Export-Import, Migmon etc...

Thanks A lot for the answers

Tutku

[Former Member · Accepted solution]

it always depends.

have you seen this sap note in case you cannot afford downtime :  1508271 - Oracle Lifecycle Migration Service (formerly O2O/Triple-O)

regards

Abdel

[tsenol · Accepted solution]

Hi,

Yes I've search about it but it's not a free tool and I've heard about 2-3 customers that used it.

Regards

Tutku

[tsenol]

Hi,

I meant Downtime minimisation.

Regards

Tutku

[Former Member]

You can use Cross Platform Transportable Tablespaces with Cross Platform Incremental Backup feature. You can read about this scenario in Oracle document 1389592.1.

[tsenol]

Hi Roman,

I'l try and write about this technique here.

Regards

Tutku

[Former Member]

What is your Oracle version? Try to check Cross-Platform Transportable Tablespaces option.

[tsenol]

Hi Roman,

The version is 10G. Yes I've read about Transportable Tablespaces(Snote 1035051, 1003028, 1367451)  , but I didn't use it before. I need to learn about Cons and pros of it. Do you have any recommendation about it?

Regards

Tutku

[Former Member]

What did you mean on minimum process time: overall process time or downtime minimization?