Migration of two database to a new database

[fatchoy]

Hi all

I'm running two database :

1)oracle 7.3.4 on hp ux 10.2(128mb , p166 processor)
2)oracle 8.0.5 on win nt4 (4GB ram ,4x400MZ processor)

We are purchasing a new oracle 9i on hp ux11i(2GB, 2x700 risc processor) and would like to migrated both existing database to the new oracle9i.

The question -Is it advisable to create only one instance in the new database for this migration or it better to create two instance in the new database?

I wondering whether my new hardware configuratiob is sufficient for the workload?

On top of that ,any recommendation of replication software for incemental replicating from one database(oracle 8.0.5) to another database(oracle 9i) which need to be run daily.How long it take if
incremental increase of 500MB per day.

Thanks and Merry Christmas

 

[aurora0x0]

Hi there,

I cant say much about your hardware, but I think your concerns about it being able to handle the workload are very valid.

My take on it:
DB 1 (7.3.4) is obviously a low load system (probably an accounting system or something which has reports run on it monthly).

DB 2 (8.0.5) is probably your high load system.

My question:
What is the load like on DB 2?

If it is close to maxxing out most of the time, then your hardware probably will not do the job if you run both on it.


If this is the case then I would create two DB instances and only one 9iAS instance (if you are going to be using it).

The overhead that you incur from running an extra instance is minimal compared to the flexibility that you might gain for later upgrades. This is assuming that your two DB's are laden with Public Synonyms (which older programs usually are).

Also, I assume that you are probably swtiching to the new machine to save on licensing costs.

Again, depending on how much load your systems are under right now, you might end up springing for another processor license and a new, single cpu computer to run DB 1.

I haven't done an indepth study of your needs or your capabilities at all, so please take this post with a grain of salt.

Do some testing before you buy/lease that new HP, just to see how much of a computer you need. How many users run the system? How many real-time processes are there? Your replication system at 500MB per day - is it okay to grind your poor system down to a halt for 2-5 hrs a night?

As for your replication strategy, I can't speak to that as I have never had to do it personally (with the exception of using snapshots), sorry...

Hope that helped...
Dave.