Oracle-L: Using Soft Links for Datafiles

From: <Rajesh.Rao_at_jpmchase.com>
Date: Thu, 06 Feb 2003 13:23:39 -0800
Message-ID: <F001.00546606.20030206132339@fatcity.com>

We are in the process of creating a 9.2 RAC database. And we are being forced to follow a standard whereby, all files are to be in a directory structure, say /local. No standards have yet been defined, if one were using raw volumes. And since we will be using raw volumes for the datafiles, to enforce the standards, we are being asked to create symbolic links from /local datafiles to the raw volumes. To convince them otherwise, I have seemed to dug up two issues.

For some reason, if the link breaks or is removed while the databases are up and running, its akin to taking a datafile offline, which would neccesitate a recovery.
While doing a restore, RMAN would restore the files to the link directory and not to the actual raw volume.

Does this hold water? Anyone has other ideas or gotchas with using symbolic links for datafiles? Or Am I just being paranoid?

"I commonly use links for raw datafiles. Doing so aids the adoption of meaningful naming conventions" - Steve Adams

Thanks
Raj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Rajesh.Rao_at_jpmchase.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). Received on Thu Feb 06 2003 - 15:23:39 CST