RE: OFA and RAC on raw devices

Gilles,

What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ?

   Each node will have its own ADMIN subtree (/u01/app/oracle/admin/prod/). Make sure the following parameters are configured in INIT.ORA file: # First instance specific parameters

db1.local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx)(PORT=1521))"
db1.thread=1
db1.instance_name=db1
db1.instance_number=1
db1.remote_listener = listener_db2
db1.undo_tablespace = UNDOTBS1
db1.log_archive_dest_1 = 'location=/archdb1/prod mandatory'

# Second instance specific parameters

db2.local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxxx)(PORT=1521))"
db2.thread=2
db2.instance_name = db2
db2.instance_number = 2
db2.remote_listener = listener_db1
db2.undo_tablespace = UNDOTBS2
db2.log_archive_dest_1 = 'location=/archdb2/prod mandatory'

What are the steps in Service Guard to configure failover File system ?

   System Administrator created the Failover File system at OS level.

Do you use RMAN for backups? if yes with autolocate 9i feature ?

   Yes I am using RMAN......it is a complicated setup.

If you used soft links for datafiles, it means you have some sort of /oradata/<db_name>/ structure on each node. Right?

   Yes. For example if I am using /u01/oradata/prod/ then make sure you have exactly same file system on both nodes so that database will recognize the datafiles on each node otherwise it will fail.

Does this prove helpful?

   Yes.

Muqthar Ahmed
DBA -----Original Message-----
Sent: Wednesday, November 19, 2003 5:20 PM To: Multiple recipients of list ORACLE-L

Hi Muqthar ,

thanks for you reply.
Some more precisions :

What about the OFA admin subtree (create, pfile, udump,bdump..) ? Did you duplicate it on each node ?

What are the steps in Service Guard to configure failover File system ?

Do you use RMAN for backups ? if yes with autolocate 9i feature ?

If you used soft links for datafiles, it means you have some sort of /oradata/<db_name>/ structure on each node. Right ? Does this prove helpful ?

Regards

At 06:05 19/11/2003 -0800, you wrote:
>Gilles,
>
>RAC Configuration:
>
> 1. ALL DATAFILES SHARED (RAW FILES) - both nodes should have access
> 2. ARCHIVE LOGS are not shared - Each node will have its own ARCHIVE
LOGS (File System)
> I have configured ARCHIVE LOG as FAILOVER FILE SYSTEM.
> 3. UNDO (RAW FILES) - Each node will have its own UNDO.
>
>We have STRIPED RAID1+0 to have good performance. Database is not
pointing to RAW FILES directly. I have created SOFT LINKS to point to RAW FILES. I have created TABLESPACE using SOFT LINKS.
>
>Muqthar Ahmed
>
>-----Original Message-----
>Sent: Wednesday, November 19, 2003 1:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi listers,
>
> Configuration :
> Hp-ux 11i
> Oracle 9iR2 with RAC (2 nodes)
> OSD clusterware : MC/Service Guard 11.15
>
>Oracle software is installed on each node and
>the database is on shared raw devices.
>
> Any experience/gotchas implementing OFA on RAC without cluster file
systems?
> In particular, do you share the admin subtree between nodes ? and how (NFS
>mount ?)
>Also do you cross-mount archive log file systems ?
>
> Thanks in advance for any info or pointers
>
> Regards
>
>

Gilles Parc

carpe diem !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gilles PARC
  INET: gparc_at_online.fr

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).
		*	*	*	*	*	*	*	*	*

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, 
disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please 
reply to the sender and delete it from your computer. Thank you. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Muqthar Ahmed
  INET: Muqthar.Ahmed_at_decoratetoday.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).