topic Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine in Operating System - HP-UX

Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine

Mcelhannon Walter — Thu, 30 Mar 2000 05:38:35 GMT

Is there a cook book out there about restoring a tape backup of an oracle
database(running SAP) to a different machine yet same platform HP-UX 10.20.

Which directories, and what files need modifing related to hostname changes and
the like...

Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine

Zeng Queyon — Thu, 30 Mar 2000 06:45:27 GMT

Copy the following file into the save directories as the original machine ( if
you copy the datafiles into the different directories, you have to recreate
control file ):
- parameter files
- control files
- all the datafiles
- environment variables
- dump directories
Since the hostname has been changed, you have to modify the following files in
${ORACLE_HOME}/network/admin
directory:
- tnsnames.ora
- sqlnet.ora
- listener.ora

Good luck to you.
Queyon

Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine

Susan Kim — Fri, 11 Aug 2000 21:13:42 GMT

To explain in very plain way, there are 2 ways to do this;
1) configure 2 systems the same way, have binaries for oracle and all the
mount points of the oracle datafile identical..
change alias in TNSNAMES to reflect the new hostname to match the
2nd server...

2)
this is much cleaner way,...
install oracle binaries,
then do quick analysis on system#1 and get the all tablesize sizing right,
then create DB and tablespaces on system#2
then do full export on system#1 followed by full export into system #2.
adjust your TNSNAMES on system#2 accordingly to new hostname.

Remember the "control" files on oracle acts just like /etc/lvmtab on hp-ux,
in that it contains the "full" hard-path to the datafile. That is the reason
you must have identical mount point.

This is the very simplified, HOWTOs.
SK

Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine

R. Allan Hicks — Thu, 31 Aug 2000 16:23:32 GMT

If the machines have the _same_ directory structures and you can shutdown the source machine long enough to do a physical backup, I have:

1. Shutdown the oracle database.

2. Do a backup of the oracle binaries (i.e. $ORACLE_HOME on down.

3. Back up all of the datafiles associated with Oracle. Do a 'select name from V$datafile;' if you are not sure of the datafiles. You must get them all. Plus, be sure to get /etc/oratab, /sbin/init.d/oracle, and all of the directories and files under $ORACLE_BASE.

4. Restore the tape to the target machine and start oracle.

If you can shutdown the source machine long enough for a physical backup,

1. create a starter database via the create database command (This is a good time to change the database name if your plans include replication.)

2. Do a full export (See Oracle Utilities manual) from the source machine.

3. Create any directories for the datafiles on the target machine.

4. Do an import to the target machine. The import will recreate your tablespaces.

5. ftp, rcp or otherwise copy the support files:

/etc/oratab
/sbin/init.d/oracle (if you use it)
/etc/rc.config.d/oracle (if you use it)

There is a note in Metalink that covers creating a new instance. You may want to look over it in case I left something out.

-Good Luck
Allan Hicks

Re: Moving Oracle 8 from one HPUX10.2 to another HPUX10.2 machine

R. Allan Hicks — Thu, 31 Aug 2000 16:26:33 GMT