Oracle-L: Re: Archiving in OPS

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Thu, 06 Jun 2002 12:44:19 -0800
Message-ID: <F001.00476B7D.20020606124419@fatcity.com>

If I understand you correctly, you are referring to "RAW" EMC storage as the shared storage array accessible from all nodes in the cluster, while "local" is local storage that is only accessible from the node to which it is directly attached?

If so, then putting the tablespaces on that "local" storage will never work. Likewise, if the rollback tablespaces were also not in "raw" devices; it would never work (unless you are using a clustered file-system such as available on Tru64). In both cases, OPS/RAC would fail to startup...

Original Message ----- From: Muqthar Ahmed To: Multiple recipients of list ORACLE-L Sent: Thursday, June 06, 2002 1:48 PM Subject: RE: Archiving in OPS

Hi,

You can not setup your archive logs in EMC storage (RAW). Currently I am working on this project. Oracle recommends that the following setup:

            SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / REDOLOGS     -----     RAW (EMC storage)
             ARCHIVE LOGS / ROLLBACK (UNDO)                                         -----     LOCAL (on each instance)

You can use FAILOVER to move archive location. For example:

       Instance1            Instance2
       PROD1               PROD2
       /d01/arch1           /d02/arch2

If Instance1 goes down, using FAILOVER method, /d01/arch1 will be automatically mounted on Instance2. Check with your UNIX Administrator about FAILOVER mechanism.

  Muqthar Ahmed
  DBA
    -----Original Message-----
    From: Ramon E. Estevez [mailto:com.banilejas_at_codetel.net.do]     Sent: Thursday, June 06, 2002 12:59 PM     To: Multiple recipients of list ORACLE-L     Subject: Archiving in OPS

Hi list,

Scenario OPS, 2 nodes, 8.1.7, AIX using raw devices, EMC box.

I am new in OPS and have to implement archiving in an OPS environment and configure RMAN to use with LEGATO.

My question is how to organize the archives. What will happen if one of the nodes goes down ?

I think that the 2 nodes have to see each other and write archive files to the same place, for instance I assume that the archive files have to be in the EMC box .

I have been gathering very helpful information from the list in the past week about RMAN, but if you have some scripts, some documentation, links about it will be very appreciated.

    TIA     Ramon E. Estevez
    com.banilejas_at_codetel.net.do
    809-565-3121

--

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

Author: Tim Gorman
INET: Tim_at_SageLogix.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 Jun 06 2002 - 15:44:19 CDT