Re: 600 Gb migration from Sun to Aix in 8 hrs

well i had guesssed that everyoen wd b surprised to see those number.

We had done around 10 pilot runs b4 we did the final migration. object validity and table count was also matched during each and every run.
index creatino of big tables took around an hr as i said earlier.

as far as the parametes go - we did some research on the net abt the same. but we also tested them during the dry runs and found great improvements.

storage was hitachi san - dunno the number.

Kris wrote:

> We have successfully migrated 600 Gb database for a banking client from
> SUN to AIX in 7 hrs.we had several pilot runs before the final ball.
>
> we used following parameters during export
>
> db_file_multiblock_read_count=20480
> db_file_multiblock_io_count=128
>
> and for import
> parallel_max_servers=60
> parallel_automatic_tuning=TRUE
>
>
> AIX box had just 7 cpu's.
> export ON the basis of table size run parallely in 7 diff sessions.(3
> hrs)
> import without indexes (for big tables) in 7 diff session.(4 hrs)
> index creation for big tables (2 hrs)
Received on Mon Dec 12 2005 - 10:10:22 CST