Oracle-L: Using Soft Links for Datafiles

From: <Rajesh.Rao_at_jpmchase.com>
Date: Fri, 07 Feb 2003 09:34:01 -0800
Message-ID: <F001.005474E6.20030207093401@fatcity.com>

Resending. Any takers?

Forwarded by Rajesh Rao/JPMCHASE on 02/07/03 11:51 AM -----

                    Rajesh                                                                                          
                    Rao/JPMCHASE@        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    CHASE                cc:                                                                        
                    Sent by:             Subject:     Using Soft Links for Datafiles                                
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    February 06,                                                                                    
                    2003 04:23 PM                                                                                   
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L

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




-- 
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 Fri Feb 07 2003 - 11:34:01 CST