Re: Filesystem for Archive logs in RAC

You can certainly write archived redo log files out to any old locally-mounted file-system as you like while the database is up and running. The problem will occur when you need to use those files in a recovery and the server on which they were mounted is not available, thus neither are the archived redo log files residing there. Upshot: not a good idea. So, to answer your question directly, you'd need either an NFS-mounted file-system (such as NetApp) or a clustered file-system.

Now the more important question: why do you choose to put the archived redo log files in a filesystem? What's wrong with a "flash recovery area" disk group in ASM?

Hope this helps...

-Tim

-----Original Message-----

From: Anurag Verma [mailto:anuragdba_at_gmail.com] Sent: Wednesday, August 31, 2011 02:47 PM To: 'ORACLE-L'
Subject: Filesystem for Archive logs in RAC

I am in the process of configuring 11gR2 RAC on Solaris. We are going to use ASM for shared storage for database files. For Archive log files, we are going to put them in filesystem. So in order to put the files in the filesystem, can you mount the same filesystem (from SAN) on both RAC nodes same time, so that RAC instances can write the archive logs in to the same directory? How you guys have done at your setup?

Did you with filesystem for archive logs ? If yes, how did you do that?

I remember when I worked at one of my previous company, they were using NetApp filers and we were using filesystem for archive logs. Dont remember exactly how the storage admin did that.

--

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas), Texas 76574

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 31 2011 - 16:08:44 CDT