Migration from 8.1.7 on Sun to 9.2 on AIX

Printable View

11-19-2003, 01:30 AM
batavus

Migration from 8.1.7 on Sun to 9.2 on AIX

Here's the need:

- Upgrade a large (near 1TB) database from 8.1.7 to 9i
- Move from 32 bit oracle, to 64 bit oracle
- Move from Solaris to AIX
- Move from Sun to RS6000
- Do it in a small outage window

So, here is my idea:

I would like to minimize the down time when switching production from Sun to RS6000. So my approach is to see if I can run the 8.1.7 production, and use some method to keep a 9i database on the AIX boxes in sync with the data changes occuring on the sun 8.1.7 boxes. This way each will be running in parallel until the time comes to switch the application servers to point to the new AIX boxes. I'm trying to avoid having to, the night of the switch over, perform and ENTIRE extract from 8.1.7 and a full import into 9i. There is just too much data to do this in a relatively small outage window, even if things were flawlessly.

So - what options do I have to take daily (or smaller time span) data changes from an 8.1.7 32 bit database on Sun, and push those changes into a 9i 64 bit database running on AIX?

Oh - and the estimated I/O rates in the database during peak times is two 150MB redo logs per minute.

Thanks!
11-19-2003, 02:02 AM
KenEwald

Have you looked at SharePlex? We did a proof of concept on our crm database (8.1.7 on HP/UX to 9.2 on Linux) a few months ago and the actual downtime was in the seconds.

After an export, it reads the redo from the source and collects dml until the target completes it's import .. then it catches up with the source by applying the cached dml .. you shutdown the source, complete the sync, then point the users to the target. Then you can back-port the dml from the target back to the source, just incase something really goes wrong. It's really cool stuff.

Best of luck on your migration...
11-19-2003, 02:08 AM
KenEwald

Here's another idea...

Upgrade to 10g (which should be available any day, right?) on your source database and use the transportable tablespace feature. The tablespaces will need to be off-line to transport and you'll need to use RMAN to convert the datafiles once they get to the target.

It's not real pretty, but it's an option we don't have in previous versions.

Again, best of luck.
11-19-2003, 02:35 AM
adewri

Quote:

Originally posted by KenEwald
Have you looked at SharePlex? We did a proof of concept on our crm database (8.1.7 on HP/UX to 9.2 on Linux) a few months ago and the actual downtime was in the seconds.

After an export, it reads the redo from the source and collects dml until the target completes it's import .. then it catches up with the source by applying the cached dml .. you shutdown the source, complete the sync, then point the users to the target. Then you can back-port the dml from the target back to the source, just incase something really goes wrong. It's really cool stuff.

Best of luck on your migration...

I don't think buying the costly Shareplex for one time operation (Migration) is a good idea.
11-19-2003, 02:39 AM
adewri

Quote:

Originally posted by KenEwald
Here's another idea...

Upgrade to 10g (which should be available any day, right?) on your source database and use the transportable tablespace feature. The tablespaces will need to be off-line to transport and you'll need to use RMAN to convert the datafiles once they get to the target.

It's not real pretty, but it's an option we don't have in previous versions.

Again, best of luck.

Current limitations for Transportable Tablespace feature:

- The source and target databases must be on the same hardware platform
- The source and target databases must have the same block size
- The source and target databases must have the same character set.
- The transportable set must be self-contained.

And moving to 10g directly without testing ?? Hmmm... that would be one risk that i won't suggest.
11-19-2003, 09:47 AM
marist89

First off, that's too many variables for my taste. I would upgrade to 9i on Sun first, and then worry about swapping OS/Hardware.

If your downtime is really that minimal, I would look at multi-master replication. I would setup both boxes where users could do updates on either box. Then I would move a trial group of users to the new box to verify functionality knowing that I can switch them back to the old box should something go wrong. I would then switch everybody over to the new box and keep the updates going to the old box so I have a fall-back plan.
11-19-2003, 10:44 AM
KenEwald

adewri,

Afraid of 10g? Really, the idea was offered in jest. I'm with you, I wouldn't do it either.

SharePlex can be leased for a migration. It's really not a bad migration option. My opinion is that it's much better than 10g's cross platform transportable tablespaces or setting up then dissembling cross platform replication.

Just a side note.. A feature I really like about 10g is the threading of the export/import process. You can break it, re-adjust the number of workers then resume it. That's a really cool feature. And you can call export/import directly from pl/sql too.
11-19-2003, 11:14 AM
adewri

Quote:

Originally posted by KenEwald
adewri,

Afraid of 10g? Really, the idea was offered in jest. I'm with you, I wouldn't do it either.

SharePlex can be leased for a migration. It's really not a bad migration option. My opinion is that it's much better than 10g's cross platform transportable tablespaces or setting up then dissembling cross platform replication.

Just a side note.. A feature I really like about 10g is the threading of the export/import process. You can break it, re-adjust the number of workers then resume it. That's a really cool feature. And you can call export/import directly from pl/sql too.

Throw me the docs of 10G, have been waiting for them for ages...
11-19-2003, 11:31 AM
batavus

Thanks, everyone, for your input. I'm gathering all ideas I can. I kindof like the idea of upgrade to 9i on the Sun before moving to AIX idea. But - if things are 31 bit on the Sun side, and 64 bit on the AIX side, are there issues from that stand point?
11-19-2003, 12:02 PM
fraze

Yep - you cant run 9i on a 32-bit O/S - must be 64bit!
11-19-2003, 12:07 PM
marist89

Quote:

Originally posted by fraze
Yep - you cant run 9i on a 32-bit O/S - must be 64bit!

Point me to the docs on that one...
11-19-2003, 12:16 PM
adewri

Quote:

Originally posted by fraze
Yep - you cant run 9i on a 32-bit O/S - must be 64bit!

Is your windows OS where you have installed Oracle9i 64 bit ??
11-19-2003, 12:21 PM
fraze

Quote:

Point me to the docs on that one...

I stand corrected - theres a download for 9iR2 for 32 bit Sun SPARC Solaris on OTN.
Is it only Sun SPARC that can be run 32-bit? Sure you need 64-bit for AIX and HP-UX???
11-19-2003, 12:28 PM
KenEwald

I'm running 9.2.0.4 on 32bit SUSE Linux on 32bit IBM blade server.

Oops...
---Sorry, missed your correction.
11-19-2003, 12:31 PM
fraze

Ooops - got hammered for that one!! :p
Can I re-phrase to you need 64-bit if running AIX or HP-UX then?
11-19-2003, 12:33 PM
KenEwald

I know that's true for HP/UX.