RE: Archiving in OPS

[Muqthar Ahmed]

Hi,   Yes you are correct.....I am using Oracle9i RAC (Real Application Cluster).   Muqthar Ahmed DBA -----Original Message----- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: Archiving in OPS 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:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] 809-565-3121