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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: move the production database from one machine to another

RE: move the production database from one machine to another

From: Li Zhang <lzhang_at_salu.com>
Date: Thu, 30 May 2002 09:43:35 -0800
Message-ID: <F001.0046FDE2.20020530094335@fatcity.com>

We decided not to upgrade Oracle in order to reduce the variables at this time. We are only licensed to Standard Edition so standby is not an option.

-Li
-----Original Message-----
Sent: Thursday, May 30, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L

On Wed, May 29, 2002 at 09:13:25PM -0800, Jeremiah Wilton wrote:
> 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?

Because of some local operational issues.

I am required to have multiple servers for redundancy and I can schedule "query only" time which is not equal to sla downtime. This window could be used to rebuild the dictionary on an activated standby. The fact that it works fine and Oracle doesn't support it makes me whine, sometimes in plubic.

I guess I wouldn't suggest that Li Zhang upgrade both server and oracle at the same time, anyway.

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

--
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Li Zhang
  INET: lzhang_at_salu.com

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).
Received on Thu May 30 2002 - 12:43:35 CDT

Original text of this message

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