Upgrade/migration from 9i to 11gr1

Hi can anybody tell me what is the best approach to upgrade and migrate DB from 9i to 11gr1 that too on cross platform SOLARIS to UNIX and in RAC environment.
iabhinay_dbaAsked:
Who is Participating?
 
jocaveConnect With a Mentor Commented:
OK.  Then you can do a direct upgrade to 11.1.0.7 on the Solaris 10 machine using the Database Upgrade Assistant (DBUA).

Once you have done that, you can use RMAN to transport the tablespaces between the two systems.  The Oracle Backup and Recovery User's Guide walks through a couple of ways to perform the Solaris to Linux migration in the chapter on Transporting Data Across Platforms.
0
 
jocaveConnect With a Mentor Commented:
What are you trying to optimize when you think of "best"?  The easiest option?  The option with the least downtime?  Something else?

If you have the downtime window for it, the simplest approach would be to do a full export from the 9i system and import the data into the 11.1 system.  But that requires that the system is down while you do the export and the import so the downtime is directly proportional to how much data you have in the database.  And you need enough spare disk to store the dump file(s) that are created in addition to the data in the source and target databases.  Is your downtime window large enough for this?
0
 
iabhinay_dbaAuthor Commented:
I was first given test databse and the DB size is 3TB, and the downtime is limited so can you help me with any document with how we can proceed
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
madunixChief Information Security Officer Commented:
If you have Metalink/Oracle Support I would check it first, the upgarde can be 9->10 then 10->11, eventualy you can migrate 9r2 to 11, but is very dangerous. Better export database install 11 and import back. Of course if it is not huge!
0
 
jocaveCommented:
OK, exporting a 3 TB database is almost certainly not going to fit within your downtime window.

Exactly what version of Oracle is the source database running?  9i could mean anything from 9.0.1.x to 9.2.0.y.

You say that you are also going across platforms.  Can you be more specific about the destination platform?  Solaris is a type of Unix, so "Solaris to Unix" could be interpreted as "Solaris to Solaris" or it could mean that you are going to a different Unix variant.  If so, which variant (linux, AIX, etc)?
0
 
iabhinay_dbaAuthor Commented:
ok i am doing it from 9.2.0.y. to 11gr1 and from Sun Solaris to RHEL
0
 
jocaveCommented:
What is the "y" in your source database version?

What versions of Solaris and Red Hat are you using?
0
 
iabhinay_dbaAuthor Commented:
9.2.0.7 to 11gr1(latest version). Sun solaris 10 to RHEL  6
0
 
iabhinay_dbaAuthor Commented:
But we dont have RMAN configured in our database.
0
 
jocaveCommented:
You'll want to set that up-- there is no real configuration needed.  Since the source and target use different endian formats, RMAN's cross-platform transportable database functionality will be by far the fastest way to transport the data.
0
 
khadermoinuddinCommented:
it is typical task u must perform carefully we rman backup..
0
 
gvsbnarayanaCommented:
An excellent presentation with all options available is available in the below location. I have attended an Oracle seminar on the same and it was very useful.
http://blogs.oracle.com/UPGRADE/
it also looks like Oracle is offering some consultation services just for a customer reference. Please go through the options.
HTH
Regards,
Badri.
0
All Courses

From novice to tech pro — start learning today.