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
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
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.
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...
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 ;-)
Reply With Quote
Bookmarks