Re: Migrating 3TB size database from HP to AIX, also 9i to 10g.

I carried out a similar project to this several years ago.

The existing warehouse had a feed from the mainframe which was uploaded nightly. This was duplicated so that it was also loaded into the new system (which was precreated with empty objects). Both systems ran concurrently for a month, with the new data being loaded into both systems. During this time we migrated the historical (non volatile data).

At the end of the month, the two databases were logically in synch leading to a very short downtime for migration.

Ray

On 19/09/2007, Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> wrote:
> Hello list,
>
> I have a uphill taks of migrating our datawarehouse Oracle 9i database, 3TB
> size, from HP Superdom to AIX, Oracle 10g.
> Since the migration is across platofrms, exp/imp is the obvious option. But,
> 3TB size databse, exp/imp may take just too much time.
>
> I have thought the following:
>
> Upgrading 9i database on AIX to 10g (in place upgrade)
> Then, using the method of database cross platform conversion from HP to AIX.
>
> The problem with this method is that the temporary space required to hold
> the converted data files, it willd be difficult to have 3tb temporary sapce.
>
> Do you see any another solution for this task?
>
> Regards,
>
>
> Jaffar
> --
> Best Regards,
> Syed Jaffar Hussain
> Oracle ACE
> 8i,9i & 10g OCP DBA
>
> http://jaffardba.blogspot.com/
> http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."

--
http://www.freelists.org/webpage/oracle-l