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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
