Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How best to move oracle9 db and binaries between similiar unix servers?

Re: How best to move oracle9 db and binaries between similiar unix servers?

From: Ian <ianm2_at_shaw.ca>
Date: 10 Jul 2003 23:58:02 -0700
Message-ID: <23b28adc.0307102258.6c3128bd@posting.google.com>


Thanks for all your responses - yes, the 'Server B' destination is a production machine. This production server already contains Oracle7 and we don't feel comfortable firing up the Oracle9 installation outside of a change window. Hence why we are looking at other options such as restoring the $ORACLE_BASE tarball from Server A into an Oracle9 $ORACLE_BASE directory on Server B ( obviously different from Oracle7's $ORACLE_BASE). This procedure could be done almost anytime as we know those tarball files would not interfere with Oracle7's files. The change window to migrate to Oracle9 would then really only involve modifying things like oratab, environmental variables, post-wait kernel extenstions giving us much more time for the data import and resolving any issues and problems that come up.

I forgot to mention that some time ago we performed a similar move (perhaps naively) with Oracle 7.3.4 binaries and datafiles to a different production server without incident...so i guess my question really is if this is an advisable practice on AIX especially with Oracle9?

I have been going through the backup and recovery manuals as well as Oracle9's AIX specific documentation and haven't had luck finding specifics on backup and bare metal recovery of binaries other than using installation media.

We are doing some sandbox testing to see if we can get it to work but by no means decided if we will use it even if it does seem to be ok. Again any information or experience appreciated...thanks.

"Jeff W" <jeffw_at_hiddenemailaddress.com> wrote in message news:<3f0dcfba_at_shknews01>...
> Ian,
>
> You should have ample time to set up your second environment by completing
> an installation via the Oracle CDs before your window of opportunity. What
> is the purpose of the second server? Production? Backup? Based on your
> business need, that should help you pick the best way to move data to
> another machine.
>
> Thanks.
>
> Jeff
>
> "Ian" <ianm2_at_shaw.ca> wrote in message
> news:23b28adc.0307100941.26b310f5_at_posting.google.com...
> > Hi - we need to move a 9.2.0.3 database from one AIX server to
> > another. Both servers have similiar hardware and are at the same O/S
> > level (AIX4.3.3).
> >
> > Our change window is short so ideally we would simply like to tarball
> > $ORACLE_BASE on Server A and untar on server B.
> >
> > Does anyone have experience with this approach? Is this method
> > supported? And is there any documentation available specifically
> > describing the files and directories the rdbms accesses outside of
> > $ORACLE_BASE such as the ones in /etc/ and /usr/local/ .
> >
> > thanks very much
Received on Fri Jul 11 2003 - 01:58:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US