Oracle database migration

The datapump won't work for 9i but the old exp/imp will.

I would stick with the export/import method.

But exp or expdp is the slow process for migration. How can I migrate database using rman

Another possibility will be DB Upgrade assistant (DBUA) of 11g.
It can upgrade from 9.2, 10.x to 11g.
It is used when the DB is large.
If the DB is small export/import will do the job.

DBUA would require installing the old versions of Oracle on the new server and moving the databases over as well.

DBUA doesn't help with going cross platform as needed here or moving it.

It would work for an in-place upgrade, but only after restore, or exp/imp had already occured to move the db from one system to the other

I think DBUA required database downtime also. If I am wrong please correct me. How can I migrate using RMAN also please let me know about it

I don't believe you can do this with RMAN.

You are crossing versions and platforms.

Also, if downtime is an issue how are you planning on using exp/imp unless the databases are read-only?

so do we need downtime if we do exp or dbua?
suppose if we use expdp for oracle 10g then can we use impdp for oracle 11g?
suppose if we use exp as its oracle 9i then can we use impdp for oracle 11g or we can just use imp only for oracle 11g as we exported with exp?
lastly RMAN is not at all possible for cross version and cross platform, am I correct?

How much downtime do we need in migration. I also need to migrate oracle 10g database also. So please let me know rman process for migration. I really appreciate everyone advice

>>> How much downtime

hard to say,  it'll depend on the size of your database, the speed of your disks, speed of network, how fast you work, etc.

easiest way to tell:  do it once, but keep the old system running.

the only difference between that run and the real one is you'll shutdown the old one and start the new one.  So time will be approximately however long you spent trying it plus about 1 minute.

If I need to migrate oracle 10g database to 11g. Can I do with rman or just expdp and impdp only. Lastle regarding exp I need to install oracle  11g binaries and dummy database then imp the database. Just importing will it create the same source users with privileges and indexes constraints or do I need to create after imp.

Really the only way to guess how much downtime you need is to do it and time it.  I assume you would be doing this on some sort of test platform first.  Time it.

Here is the link for transporting across platforms with rman (SURPRISE, it is in the documentation):

file:///C:/Eric/odoc/11g%20doc/backup.112/e10642/rcmxplat.htm#CHDFHBFI

Again, rman will only get you across the platforms.  You would still have to do the upgrade once the cross platform issues are resolved.

last question regarding exp. do we neeed to EXP/IMP while the database is up and running or need to shutdown to take exp. If we do EXP/IMP while the database is up and running then why do we need to shutdown the database, at what stage do we need to shutdown the database.

I think if it's same OS then we can backup oracle 10g with RMAN and then restore on new server with RMAN then apply DBUA to get oracle 11g . If I am wrong please let me know.

We have covered this as well:  you would need to install 10g on the destination server, recover, then upgrade.

Not very 'clean' in my book.

ok lastly when we use DBUA. Do we need to shutdown the database manually or does DBUA only automatically shutdown the database

I believe dbua does what it needs to do.  It has been a while since I ran it.

The online docs have everything you need.

Again, I believe it was covered a few times and a doc reference was posted as well.  RMAN across platforms requires an additional conversion step covered in the doc.

I believe that DBUA handles the shutdowns when it needs to.  I believe it does multiple up and downs in the course of an upgrade.