Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5741NI13283 for ; Fri, 7 Jun 2002 00:01:23 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id MAA71032; Thu, 6 Jun 2002 12:56:17 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 00476B7D; Thu, 06 Jun 2002 12:44:19 -0800 Message-ID: Date: Thu, 06 Jun 2002 12:44:19 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tim Gorman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tim Gorman" Subject: Re: Archiving in OPS Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0E2D_01C20D5F.3955BE50" ------=_NextPart_000_0E2D_01C20D5F.3955BE50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Muqthar Ahmed=20 To: Multiple recipients of list ORACLE-L=20 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@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@codetel.net.do 809-565-3121 ------=_NextPart_000_0E2D_01C20D5F.3955BE50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

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

----- Original Message -----
From:=20 Muqthar Ahmed =
To: Multiple recipients of list = ORACLE-L=20

Sent: Thursday, June 06, 2002 = 1:48=20 PM

Subject: RE: Archiving in = OPS

Hi,

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

       &nbs= p; =20 SYSTEM / DATA / INDEX / TEMP / OTHER TBLS / = REDOLOGS    =20 -----     RAW (EMC storage)

       &nbs= p;  =20 ARCHIVE LOGS / ROLLBACK=20 = (UNDO)           &= nbsp;           &n= bsp;           &nb= sp;    =20 -----     LOCAL (on each = instance)

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

    =20 = Instance1          &nbs= p;=20 Instance2

    =20 = PROD1           &n= bsp;   PROD2

    =20 /d01/arch1           = /d02/arch2

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

Muqthar Ahmed

DBA

-----Original Message-----
From: Ramon E. Estevez = [mailto:com.banilejas@codetel.net.do]
Sent: Thursday, June = 06,=20 2002 12:59 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Archiving in OPS

Hi list,

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

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

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

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

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

TIA

Ramon E. Estevez
com.banilejas@codetel.net.do=
809-565-3121

= ------=_NextPart_000_0E2D_01C20D5F.3955BE50-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: Tim@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@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).