Oracle-L: RE: archiving redo logs

From: Steve McClure <smcclure_at_usscript.com>
Date: Tue, 10 Dec 2002 16:00:49 -0800
Message-ID: <F001.00517100.20021210160049@fatcity.com>

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_at_fatcity.com [mailto:root_at_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_at_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_at_fatcity.com [mailto:root_at_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_at_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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve McClure
INET: smcclure_at_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_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 Tue Dec 10 2002 - 18:00:49 CST