Re: move the production database from one machine to another

On Wed, 29 May 2002, Ray Stell wrote:

> It is not supported as an upgrade process. Oracle does not support
> prod at 8.1.7.0 and standby at 8.1.7.2. I think this is a real
> crime, since it would be a great feature to lower downtime.

Why? It takes almost no time to shut down an 8.1.7.0 instance and start it up on an 8.1.7.2 ORACLE_HOME on the same server. The part that takes a long time is re-running catalog, catproc, etc., which I've never understood why you have to do, and which you have to do with the database open and only you logged in. You shouldn't need a standby to perform a fast upgrade even in a supported manner.

Rerunning catalog and catproc takes much too long. Oracle should figure out the small number of objects that need to be recompiled under a new binary and provide a script with just those in it. Rerunning everything is a waste of time, and resources, and is disruptive as well.

Anyway, since the log format of 8.1.7.0 is the same as 8.1.7.2, there should be no real problem running the standby in this mode, which I'll take you word for it is unsupported. The question is, why would someone do it? Disk space for ORACLE_HOME? An extra disk is probably cheaper than a whone second server for a standby.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton





> On Wed, May 29, 2002 at 03:53:32PM -0800, Li Zhang wrote:

> > The company I am working for is planning to move the whole production server

> > to a new faster box. As DBA, I will move the database and planning to use

> > hot backup files in order to minimize the production server down time. Are

> > there any issues or drawbacks I need to be aware of if the hot backup files

> > are used to replicate the database?

> > 

> > This is 8.1.7 on Solaris 2.7


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).