Oracle-L: RE: Using Soft Links for Datafiles

From: Loughmiller, Greg <Greg.Loughmiller_at_cingular.com>
Date: Fri, 07 Feb 2003 11:46:11 -0800
Message-ID: <F001.0054785F.20030207114611@fatcity.com>

Raj-
We used the symbolic links on a regular basis in a previous life.. But we did not have the opportunity to use RMAN, so I am not able to address that right now.

But when we lost sym links; we actually had to "restore and recover". And that's why we treated the sym links with some "special gloves".

Not that I'm putting a plug in, but hat platform are you going to use RAC upon? There is a product by Veritas on the market that will allow you to use "cooked files" with RAC. In some initial testing-it "worked"

Greg

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

Sent: Friday, February 07, 2003 12:34 PM To: Multiple recipients of list ORACLE-L

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

--

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

Author: Loughmiller, Greg
INET: Greg.Loughmiller_at_cingular.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