RE: Migrate database without downtime

>without having a downtime.
 

If
a) you measure downtime by minutes
b) no clever Oracle cross version archive log applyers are available  

then one strategy that works for me (downtime requirement is measured in seconds) is a custom built replication strategy. I my case it's usually a combination of a trigger based synch replication and/or log based async replication. Both sync and async approaches are doable. Sync has lesser downtime but a possible performance penalty as original db can not commit untill data is applied at new database, async requires to stop original db, move the delta of changes and start using a new database.      

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luc Demanche Sent: 10. nóvember 2005 18:55
To: oracle-l_at_freelists.org
Subject: Migrate database without downtime

        Hi,          

	We are running Oracle 9.2.0.1 on Linux with a standby database on another server.
	I looking for a strategy for the migration of my Oracle database to 10g, without having a downtime.
	 
	Can someone give a way to use my standby and migrate my database in 10G ?
	 
	Thanks
	Luc
	
	-- 
	Luc Demanche
	Oracle DBA
	(514) 867-9977 

--
http://www.freelists.org/webpage/oracle-l