Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Move database from 11.0 to 11i

SOLVED
Go to solution
Printaporn_1
Esteemed Contributor

Move database from 11.0 to 11i

Hi,

I've plan to move database from
HostA: HP-UX 11.0 + oracle8.1.6
to
HostB: HP-UX 11i + oracle9iR2
---------
I have plan to
0. take backup.
1. install Oracle 8.1.6 + Oracle 8.1.7 + Oracle9i on diffrent home at HostB.
2.copy datafile from HostA to HostB , start DB at hostB with Oracle 8.1.6.
3. At HostB upgrade to 8.1.7 then to 9i.
4. Install Oracle9i patch.
----------
Any advise / recommended on above steps is much appreciate.
I never have experience on upgrade.
one more question ,I understand that what Oracle HOME we use is just depend only on ORACLE_HOME environment variable does that right.

Thanks in advance & Happy New Year.
Printaporn



enjoy any little thing in my life
6 REPLIES
Yogeeraj_1
Honored Contributor

Re: Move database from 11.0 to 11i

hi,

the above are the required steps but you already have a detailed note on metalink (159657.1).

See attachment.

ORACLE_HOME and ORACLE_SID are both important.

regards and best wishes
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor
Solution

Re: Move database from 11.0 to 11i

attachment
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
G. Vrijhoeven
Honored Contributor

Re: Move database from 11.0 to 11i

Hi,

This could work, but why not make an export on 8.1.6 and import it in 9i? Downtime? I think that option is a more secure option sinse you can always fall back on 8.1.6 database if anything goes wrong.

Gideon
Printaporn_1
Esteemed Contributor

Re: Move database from 11.0 to 11i

Hi Yogeeraj ,
thank you very much.

Hi G. Vrijhoev,

Yes, you're right ,My most concern is downtime.
enjoy any little thing in my life
Jim Butler
Valued Contributor

Re: Move database from 11.0 to 11i

we did it from hp 11 (8.1.5) to Solaris 9 (9i) -

we did the export - then import -

fairly painless -

I would recommend a test sid (create a sid, and populate it..., export it for test)

We use the automount tables for /home/oracle8
and /home/oracle9 to differentiate the data - exporting them from different disks.

No problems.
Man The Bilge Pumps!
Rick Meijer
Occasional Advisor

Re: Move database from 11.0 to 11i

Hello,

I agree with the export/import strategy but this of course is slow. But safe and reliable is very important too! To help the import along, I would create a very large, fast instance before doing the import. Possibly even drop the indexes in the old instance and recreate in the new instance but only if you can justify an advantage.

Remember to export the database owner only. i.e. don't do a full export.

Also, I would write a script to dump "Create User" statements from the old instance and run them in the new instance. Also make note of objects (like sequences) that may be used by the database owner but stored under sys.

Don't forget to make sure the new database is ANALYZED (w/compute statistics) if using COST!

OH yeah, The ORACLE_SID and ORACLE_HOME environment variables are very important when doing DBA work so put the ORACLE_SID in your prompt and the ORACLE_HOME in the login message so you don't make a mistake and forget what environment you are in.

Best Wishes.