Migrate from Sun to Linux Oracle 9i

Printable View

12-08-2004, 04:00 PM
st2003

Migrate from Sun to Linux Oracle 9i

DBAs:

Can anyone of you share info about how to convert from Sun Oracle to Linux Oracle on 9i database. We have a DWH system about 200 GB that needs to be converted. We have all our oracle on SUN or creating new environments on Linux, but we want to convert now.

Export Import does not work for us since the database is used in the morning and nights we populate with feeds

RMAN does not work (Sun to Linux)

Cold Bkup does not work (Sun to Linux)

So, what are other solutions?
Any experiences or documentation or links

Thanks, ST2003
12-08-2004, 04:04 PM
davey23uk

Re: Migrate from Sun to Linux Oracle 9i

Quote:

Originally posted by st2003
DBAs:

Can anyone of you share info about how to convert from Sun Oracle to Linux Oracle on 9i database. We have a DWH system about 200 GB that needs to be converted. We have all our oracle on SUN or creating new environments on Linux, but we want to convert now.

Export Import does not work for us since the database is used in the morning and nights we populate with feeds

RMAN does not work (Sun to Linux)

Cold Bkup does not work (Sun to Linux)

So, what are other solutions?
Any experiences or documentation or links

Thanks, ST2003

sqlplus copy

insert over a db link

exp / imp

dump to flat files and sql*loader

you rule out exp / imp so you are stuck with one of the others
12-08-2004, 04:05 PM
marist89

yup, thems your only options.
12-08-2004, 04:15 PM
st2003

All these take a lot of time.

DB link and 200GB ?

Thanks, ST2003
12-08-2004, 04:21 PM
gandolf989

Quote:

Originally posted by st2003
All these take a lot of time.

DB link and 200GB ?

Thanks, ST2003

You could do multiple exports and import them in parallel with importing indexes. Then create all of you indexes in parallel.

It seems that you want the databases to be insync before you do your daily load, then do the daily load on the new system. Because, why would you load the current day and then migrate it. In any event you may need some downtime.
12-08-2004, 04:25 PM
marist89

Yes, it takes time to move 200G.

There was an interesting solution posted a couple months back. Somebody used Quest Shareplex to setup a standby database on another platform. When the time to switch came, it was a two second switch. You'd have to search for details. Also, seemed like a pretty high price to pay for a one time event, but if you're willing to pay anything for near-zero downtime...
12-08-2004, 06:16 PM
st2003

Can the Quest Shareplex be used for such scenario?

Sun Os to Linux ?

Thanks, ST2003
12-08-2004, 08:03 PM
gandolf989

Quote:

Originally posted by st2003
Can the Quest Shareplex be used for such scenario?

Sun Os to Linux ?

Thanks, ST2003

Have you looked at Quest's website?
12-08-2004, 11:36 PM
stmontgo

Re: Migrate from Sun to Linux Oracle 9i

Quote:

Originally posted by st2003
DBAs:

Can anyone of you share info about how to convert from Sun Oracle to Linux Oracle on 9i database. We have a DWH system about 200 GB that needs to be converted. We have all our oracle on SUN or creating new environments on Linux, but we want to convert now.

Export Import does not work for us since the database is used in the morning and nights we populate with feeds

RMAN does not work (Sun to Linux)

Cold Bkup does not work (Sun to Linux)

So, what are other solutions?
Any experiences or documentation or links

Thanks, ST2003

I saw that 10g has transportable tablespaces across platforms, too bad for you though on 9i ;-)