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

On Fri, 18 Jul 2003, Sybrand Bakker wrote:

> >2. Using sqlplus, do an O7-style hotbackup; i.e. "alter tablespace x
> > begin backup;" Copy all the datafiles in this way. You might do an
> > 'alter database backup controlfile to trace;' so you are sure that you
> > know where everything is.

> Just for your info: Oracle does support such a move only when you have
> exactly the same Oracle version, to the patch level, and exactly the
> same Unix, to the patchlevel.

Moving the exact same Oracle release to the exact same OS relase on the exact same platform is precisely what the original poster was trying to do:

> 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).

> Your advice is unprofessional.

As you have obviously not read the original post, I will overlook this lapse in your normally lucid discussions. Please endeavor to be less cantankerous; it reflects badly upon our community.

   / Charles J. Fisher                   | "Waste no more time arguing what  /
  /  cfisher_at_rhadmin.org                 |  a good man should be. Be one."  /
 /   http://rhadmin.org                  |   -Marcus Aurelius              /
---------------------------------------------------------------------------