- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: How to install/create 8.1.7.0 database & migra...
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
тАО03-11-2004 02:42 PM
тАО03-11-2004 02:42 PM
How to install/create 8.1.7.0 database & migrate data
Pls help, quite urgent. Can someone help me or point me to a document on how to do this?
Basically what we want is transfer/migrate an 8.1.7.0 database from HP-UX 11.00 to another server (diff O/S version running on HP-UX 11.11). We want to create a replica as a DR backup for our company. How do I do it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2004 03:17 PM
тАО03-11-2004 03:17 PM
Re: How to install/create 8.1.7.0 database & migrate data
0) Shutdown and take a "cold" backup.
Later version may deal with RMAN or other hotbackups but I would learn to "nail" the cold version before moving to more complex
version. Besides cold backups with vxfs snapshots give you all the advantages of a hotbackup for only a few minutes of downtime.
When used in conjuction with archive/redo logs you can bring the database back to essentially any momont in time.
1) Install Oracle binaries on the new platform as a new Oracle install. The 11.0 version of 8.1.7.0 will run just fine under 11.11 but will link with the newer libraries.
You will need to restore /home directories and setup and/or transfer users/groups.
2) Create LVOL's, mountpoint, and filesystems with the exact same names as were on the 11.0 box. If you are using raw devices, I suggest that you ALWAYS use a level of indirection. e.g. suppose that you are using /dev/vg01/rlvol1 as an Oracle raw device. Instead use something like /oracle/data/file01.raw as the Oracle datafile and then create a symbolic link to /dev/vg01/rlvol1. This little level of indirection adds no real overhead but it means that when you move a database to another machine (or device) the ONLY thing you have to do is change the softlinks. If you are using hard device name now, have the DBA change them.
3) Using fbackup, OB2/DP, whatever, restore the database file to the new host. You will also need the init.ora's, tnsnames, and listeners restored to ${ORACLE_HOME}/xxx. If you have any scripts that set env variables, transfer those as well.
4) Say a small prayer, run svrmgrl, and start the database.
Again, you can build up as elaborate a scheme as you like but I would begin with
cold backup/restore. Until you get that working, there is no point in going further.
I would also upgrade your 8.1.7.0 to 8.1.7.4; a number of bugs were addressed.
By the way, it's far better to start DR with a blank machine (no OS); the other "killer" is to assume the you (the author) are dead and someone else has to follow your precise, clear, well-written instructions. It's okay to be there as a ghost but you will be amazed at how bad your instructions
are ----
I know I was the first time through this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-11-2004 03:28 PM
тАО03-11-2004 03:28 PM
Re: How to install/create 8.1.7.0 database & migrate data
Just make sure both machines are 32 bit or 64 bit. There is a nasty 27 part conversion procedure that you don't want to worry about in a DR situation.
I'd also plan an overall move to at least Oracle 8.1.7.4
There are java issues, there bug fix issues that you don't want hanging over your head in a DR situation.
Long term, you might want to consider a serviceguard cluster to provide instant failover.
Even longer term Oracle 8.1.x is at the end of its support cycle. Support is partially pulled and goes for good 12-31-2006.
These opinions are my own.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2004 12:54 AM
тАО03-15-2004 12:54 AM
Re: How to install/create 8.1.7.0 database & migrate data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-15-2004 01:09 AM
тАО03-15-2004 01:09 AM