This content has been marked as final. Show 6 replies
What is the expected downtime duration ?1 person found this helpful
What is the database size ?
For a "small" database with no downtime constraint you could use Data Pump to move data.
For a "large" database with minimum downtime you could use Oracle Streams (with Enterprise Edition) or Golden Gate (separate product: needs new licensing).
You can find detailed migration/upgrade recommendations and scenarios on OTN database upgrade page:
Edited by: P. Forstmann on 22 mars 2013 13:03
As noted, DataPump is one option - http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm#i262220
Pl post exact vesions of "10g" and "11g", along with exact OS versions
thanks alot for your time and help !!!
Our Database is too large and no down time , so we decided we will done this process by Replicate machine. Which is in sync through Goldengate.
Yes we can through Goldengate initial load approach. question is will it good approach because our database will be near to 5-6 TB. Might be it will take lot of time
There is any another approach....
check below notes...
Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]
Migration Of An Oracle Database Across OS Platforms [ID 733205.1]
Check the workshop presentation here - http://www.oracle.com/technetwork/products/upgrade/index-088044.html - for various scenarios and options for upgrading large databases with limited downtime.
1 person found this helpful
1. first and best way is covert window oracle 10g to linux oracle 10g and then convert oracle 10g to oracle 11g
2. second way is goldengate initial load.