- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Move database from 11.0 to 11i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2003 06:57 PM
тАО12-29-2003 06:57 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2003 07:14 PM
тАО12-29-2003 07:14 PM
Re: Move database from 11.0 to 11i
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2003 07:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2003 07:17 PM
тАО12-29-2003 07:17 PM
Re: Move database from 11.0 to 11i
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2003 07:34 PM
тАО12-29-2003 07:34 PM
Re: Move database from 11.0 to 11i
thank you very much.
Hi G. Vrijhoev,
Yes, you're right ,My most concern is downtime.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-31-2003 12:48 AM
тАО12-31-2003 12:48 AM
Re: Move database from 11.0 to 11i
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-06-2004 02:07 AM
тАО01-06-2004 02:07 AM
Re: Move database from 11.0 to 11i
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.