Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9i RAC and LOG_ARCHIVE_TARGET_n on OCFS

9i RAC and LOG_ARCHIVE_TARGET_n on OCFS

From: Steffen Roegner <sroegner_at_gmx.de>
Date: Wed, 01 Sep 2004 23:50:56 +0200
Message-ID: <41364441_1@news.arcor-ip.de>


Howdy,

here is a little nut we tried to crack these days. We have a 4-node 9.2.0.4 RAC on Red Hat EL 3.0 running, utilizing a SAN with ocfs. Following Wim Coekaerts recommendations found on oss
(http://oss.oracle.com/projects/ocfs/dist/documentation/ocfs_oracleworld.ppt)
we were trying to separate archive directories for the archlog threads from each other - we used to have them in one partition alltogether in the beginning. ("Separate archive log files from datafiles, If possible separate out in separate directories"). This is apparently to prevent ocfs from fragmentation ...

Anyway - the only way I know for doing that is setting the LOG_ARCHIVE_DEST_n instance specific, like so:

node1.thread=1
node1.log_archive_dest_1=/u01/archive/rac/thread1
node2.thread=2
node2.log_archive_dest_1=/u01/archive/rac/thread2

We now use this configuration on a test RAC and it works. On the other hand, ORACLE Doc says explicitly:

"Parameters That Must Be Identical Across All Instances

Certain initialization parameters that are critical at database creation or that affect certain database operations must have the same value for every instance in Real Application Clusters. Specify these parameter values in the common parameter file, or within each init_dbname.ora file on each instance. The following list shows the parameters that must be identical on every instance.

I cannot put this together - is there another (maybe more explicit) way, to assign a certain Archive Log Destination to an Archive thread?

tia,
Steffen

-- 
... Steffen Roegner, Oracle dba
-------------------------------
http://www.sroegner.de, http://www.gagabut.de
Received on Wed Sep 01 2004 - 16:50:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US