Re: Oracle RAC and external tables
- From: Harel Safra <harel.safra@xxxxxxxxx>
- To: Steven.Rebello@xxxxxxxxxx
- Date: Fri, 18 Dec 2009 13:25:43 +0200
"The first version of OCFS was developed with the main focus to accommodate oracle database files for clustered databases. Because of that it was not an POSIX compliant file system. With version 2 the POSIX features were included."
You can store general files in OCFS2, not just database files. You can find more details here:
What we use at our site for this kind of purpose is an NFS export from a netapp filer (the DB files are stored in ASM on a different SAN). The NFS export gives all the RAC servers access to the same directory and no single node is a SPOF. Of course the netapp filer is a SPOF, but so is the SAN that you put your DB files onto.
Steven Rebello wrote:
-- http://www.freelists.org/webpage/oracle-lHi list members, Need your inputs to help understand how RAC and external tables work. We are planning to use external tables to upload large volumes of data from a flat file, which is FTP'ed into the database server. Currently, in the DEV environment we have a single-node Oracle instance (non-RAC) which reads the files from the local disk and uploads the data. The upload process is triggered from a web application which calls a PLSQL proc doing the external table creation and loading. Everything works fine. But now, in the planned production Oracle RAC, since there 2 nodes having separate disks, it is possible that the file is FTP'ed into node 1 but the web application invokes the proc on node 2 due to load balancing. As node2 doesn't have the file on its local disk, the processing fails. With this background, can you help with the queries below : - First thought was to place the directory containing the files on the shared SAN, but had been advised against it with the reason that OCFS does not support non-DBF files. Is this a valid point? Couldn't find any reference document for this. - Planned to use NFS share and point the directory object to that, but then NFS server becomes the single point of failure L Any workarounds for this? - If we cannot share flat files on RAC, does that mean that RAC and external tables don't gel together? I've read the documentation and googled this out, but have not been able to get a clear idea of what's the best practice for this situation. Your inputs/experience/pointers to documentation would be much appreciated. Oracle 10g Enterprise Edition Release 10.2.0.1.0 - 64bit - 2 node cluster RAC - AIX 5.3 Regards Steven Rebello MASTEK LTD. Mastek is in NASSCOM's 'India Top 20' Software Service Exporters List. In the US, we're called MAJESCOMASTEK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions expressed in this e-mail are those of the individual and not that of Mastek Limited, unless specifically indicated to that effect. Mastek Limited does not accept any responsibility or liability for it. This e-mail and attachments (if any) transmitted with it are confidential and/or privileged and solely for the use of the intended person or entity to which it is addressed. Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. This e-mail and its attachments have been scanned for the presence of computer viruses. It is the responsibility of the recipient to run the virus check on e-mails and attachments before opening them. If you have received this e-mail in error, kindly delete this e-mail from desktop and server. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- http://www.freelists.org/webpage/oracle-l
- Oracle RAC and external tables
- From: Steven Rebello
- Oracle RAC and external tables