Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBB4UdQ17600 for ; Tue, 10 Dec 2002 22:30:39 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBB4Uc317594 for ; Tue, 10 Dec 2002 22:30:38 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id RAA48943; Tue, 10 Dec 2002 17:13:20 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00517100; Tue, 10 Dec 2002 16:00:49 -0800 Message-ID: Date: Tue, 10 Dec 2002 16:00:49 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Steve McClure" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Steve McClure" Subject: RE: archiving redo logs Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0301_01C2A064.EA7F9A00" ------=_NextPart_000_0301_01C2A064.EA7F9A00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: Oracle 9i installation - Basic Qs - HELP!One of the requirements stated in the Standby Database Concepts and Administration Manual is that... "You must use the same version and release of an operating system on the primary and standby hosts. The standby host can, however use a different directory structure." Also "You should use the same version, release and patch of the Oracle RDBMS for the primary and standby databases so that failover operations are not compromised." I am about to test this theory by upgrading my Standby Database to Solaris 9, while my production system is not scheduled for upgrade till the new year. I will of course backup the database and do a complete failover/activation test before deciding whether to maintain the OS difference for even a month or so. Steve McClure -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Kevin Lange Sent: Tuesday, December 10, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: archiving redo logs Well, one of us is probably wrong.... not sure which. But, I thought that , as long as the file structures are the same that there should not be any difference in an archive log for one OS over another. Since you are coming from Solaris, a unix environment, and going to a DEC Alpha, another unix environment, I figured that they would be compatible. Tell you what, do yourself a favor and create a small database on one system, clone it over to the other system and try it out yourself. You could have your question answered unequivicably in a days time. -----Original Message----- From: Bala Regupathy [mailto:bala.regupathy@wcom.com] Sent: Tuesday, December 10, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: archiving redo logs Kevin, I thought the pre-requisite to create a standby database is it should have the same OS level and Oracle version as primary. Am I wrong ? Bala. -----Original Message----- From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Kevin Lange Sent: Tuesday, December 10, 2002 2:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: archiving redo logs And what is the problem with having a standby DB on a different OS than the primary ??? -----Original Message----- From: Bala Regupathy [mailto:bala.regupathy@wcom.com] Sent: Tuesday, December 10, 2002 2:06 PM To: Multiple recipients of list ORACLE-L Subject: archiving redo logs Hi, How can I archive redo logs automatically to a different machine ?. Standby database is not an option because the target machine's OS is different from the primary. Primary db is 8.1.7.2 resides on SUN E10k with SunOS 5.8. Target server is DEC Alpha 4.0 If UNIX script is the only option, I appreciate if you can share it here. Thanks, Bala. ------=_NextPart_000_0301_01C2A064.EA7F9A00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Oracle 9i installation - Basic Qs - HELP!
One of=20 the requirements stated in the Standby Database Concepts and = Administration=20 Manual is that... "You must use the same version and release of an = operating=20 system on the primary and standby hosts.  The standby host can, = however use=20 a different directory structure."  Also "You should use the same = version,=20 release and patch of the Oracle RDBMS for the primary and standby = databases so=20 that failover operations are not compromised."
 
I am=20 about to test this theory by upgrading my Standby Database to Solaris 9, = while=20 my production system is not scheduled for upgrade till the new = year.  I=20 will of course backup the database and do a complete failover/activation = test=20 before deciding whether to maintain the OS difference for even a month = or=20 so.
 
Steve=20 McClure
-----Original Message-----
From: root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Kevin = Lange
Sent:=20 Tuesday, December 10, 2002 2:09 PM
To: Multiple recipients = of list=20 ORACLE-L
Subject: RE: archiving redo = logs

Well, one of us is probably wrong.... not sure which.  = But, I=20 thought that , as long as the file structures are the same that there = should=20 not be any difference in an archive log for one OS over=20 another.
 
Since you are coming from Solaris, a unix environment, and = going to a=20 DEC Alpha, another unix environment, I figured that they would be=20 compatible.
 
Tell=20 you what, do yourself a favor and create a small database on one = system, clone=20 it over to the other system and try it out yourself.   You = could=20 have your question answered unequivicably in a days = time.
-----Original Message-----
From: Bala Regupathy=20 [mailto:bala.regupathy@wcom.com]
Sent: Tuesday, December = 10, 2002=20 3:20 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: RE: archiving redo = logs

Kevin,
 
I=20 thought the pre-requisite to create a standby database is it = should=20 have the same OS level and Oracle version as primary.  Am I = wrong=20 ?
 
Bala.
-----Original Message-----
From: = root@fatcity.com=20 [mailto:root@fatcity.com]On Behalf Of Kevin = Lange
Sent:=20 Tuesday, December 10, 2002 2:43 PM
To: Multiple = recipients of=20 list ORACLE-L
Subject: RE: archiving redo=20 logs

And what is the problem with having a standby DB on a = different OS=20 than the primary ???  
-----Original Message-----
From: Bala = Regupathy=20 [mailto:bala.regupathy@wcom.com]
Sent: Tuesday, = December 10,=20 2002 2:06 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: archiving redo = logs

Hi,
 
How can I archive redo logs automatically to a = different machine=20 ?.  Standby database is not an option because the target = machine's=20 OS is different from the primary. 
 
Primary db is 8.1.7.2 resides on SUN E10k with SunOS=20 5.8.
Target server is DEC Alpha 4.0
 
If UNIX script is the only option, I appreciate if you = can share=20 it here.
 
Thanks,
 
Bala.
 
------=_NextPart_000_0301_01C2A064.EA7F9A00-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: smcclure@usscript.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).