Re: ASM of any significant value when switching to Direct NFS / NetApp / non-RAC?
From: Robert Hanuschke <robert.hanuschke_at_gmail.com>
Date: Fri, 10 Aug 2012 19:11:16 +0200
Message-ID: <CAL6WDh2waXQCeSWbraZfZ4EXVW7T2Bncw2Ao2az1Suxd_woe2w_at_mail.gmail.com>
Hi Dana,
about "With ASM, it's a breeze to use "+DATAFILE" and have Oracle deal with pathing details. Is there a similar shorthand I can use without ASM that offers the same convenience?"
Date: Fri, 10 Aug 2012 19:11:16 +0200
Message-ID: <CAL6WDh2waXQCeSWbraZfZ4EXVW7T2Bncw2Ao2az1Suxd_woe2w_at_mail.gmail.com>
Hi Dana,
about "With ASM, it's a breeze to use "+DATAFILE" and have Oracle deal with pathing details. Is there a similar shorthand I can use without ASM that offers the same convenience?"
you might want to read about Oracle Managed Files (often just called OMF). http://docs.oracle.com/cd/E11882_01/server.112/e25494/omf003.htm
That practically also works with any file system. Just set the various *_dest parameters, omit the paths from the add or create statements and Oracle will put the needed files in the directories specified before, generating its own unique file names.
Best regards,
Robert
http://robertvsoracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 10 2012 - 12:11:16 CDT