Operating System - HP-UX
1748150 Members
3813 Online
108758 Solutions
New Discussion юеВ

Re: 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 6
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.