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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).