Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Platform + version migration, no downtime?

Re: Platform + version migration, no downtime?

From: Brian Peasland <>
Date: Tue, 6 Jan 2004 22:54:38 GMT
Message-ID: <>

I don't know if it is exactly what you are looking for, but just today I was reading about some vendor's latest product to migrate with zero downtime. Their web site is below:

Have a look!

Rick Denoire wrote:
> Hello
> I am in the process of migration of two databases. The first one went
> from Oracle 8.1.7 to on the same host (Sun-Solaris). That was
> done successfully via export/import, but it took 3 to 4 days to finish
> (including testing, adapting backup scripts etc.).
> The second one is going from Oracle 8.1.7/Sun:Solaris 7 to
>; it is about ten times larger than the first
> one. In this case, using a similar procedure would take ten days at
> least (don't forget the network bottleneck). That is way too long. I
> am forced to reexamine my transition plan and need some breaking
> ideas.
> I am wondering if it is possible to do the transition in parts, one
> schema at a time, without disturbing normal work. But setting up a DB
> link for moved schemas does not seem to be a solution because too many
> scripts would have to be changed and tested; something would break. I
> am not aware of any other "trick" to implement a distributed DB.
> Another solution would be perhaps to try to upgrade the source DB
> from 8.1.7 to in place on the same host first, using the
> migration procedure to avoid time consuming exp/imp. In a second step,
> a replication between the two platforms (Sun and Linux) would be setup
> and let run smoothly until replication is complete, while work keeps
> going in the source DB; finally, only switching to the new platform by
> a simple tnsname change would be necessary.
> Doing migration in place is a little bit risky, so I think that I
> would need a cold backup first, adding 10 hours to the procedure.
> But the crucial question here is if it is possible to do an online
> replication of databases of the same Oracle version but on different
> platforms... Is there something like a logical replication? I think I
> have heard something similar. Not blocks are transferred, but redolog
> entries (I think). I don't know if "replication" is the right word.
> "Shadow database"? "Stand by database"?
> If you wish to continue my brainstorming session, you are welcome!
> Regards
> Rick Denoire


Brian Peasland

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Tue Jan 06 2004 - 16:54:38 CST

Original text of this message