Re: DBFS or ACFS for Flat Files and Dump Files

From: Ls Cheng <exriscer_at_gmail.com>
Date: Fri, 29 Aug 2014 19:30:08 +0200
Message-ID: <CAJ2-Qb8nCGpQf+Npc-mB4t6qvXXRznBcYuupyw7ZTcb4_-ai8A_at_mail.gmail.com>



Hi

I was trying to use DBFS for GoldenGate because the source site runs Data Guard, it is not useable as you imagine.

On Fri, Aug 29, 2014 at 7:23 PM, Andy Rivenes <andy.rivenes_at_oracle.com> wrote:

> Just curious, by not practical do you mean having to call dbfs_client and
> not being able to use a mounted file system?
>
>
>
> Andy Rivenes
>
>
>
>
>
> *From:* Ls Cheng [mailto:exriscer_at_gmail.com]
> *Sent:* Friday, August 29, 2014 10:18 AM
> *To:* Andy Rivenes
> *Cc:* fuzzy.graybeard_at_gmail.com; Oracle Mailinglist
>
> *Subject:* Re: DBFS or ACFS for Flat Files and Dump Files
>
>
>
> Yes fuse is only available for linux and solaris.
>
> I have tried to use DBFS in AIX and it is simply not practical :-)
>
>
>
> On Fri, Aug 29, 2014 at 5:46 PM, Andy Rivenes <andy.rivenes_at_oracle.com>
> wrote:
>
> Actually mounting DBFS is restricted to Linux and Solaris because FUSE is
> used, but dbfs_client itself can access DBFS on any platform that the
> database is supported on.
>
>
>
> Andy Rivenes
>
>
>
>
>
> *From:* Hans Forbrich [mailto:fuzzy.graybeard_at_gmail.com]
> *Sent:* Friday, August 29, 2014 5:54 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: DBFS or ACFS for Flat Files and Dump Files
>
>
>
> I find it interesting that, on Exadata, Oracle says yes to DBFS and (until
> GI 12.1.0.2) said no to ACFS.
> https://blogs.oracle.com/RobertGFreeman/entry/exadata_support_for_acfs_and
>
>
> And for Exadata, it is the only real way to hold these staging files.
> Works like a charm and is the best practice.
>
> See also
> http://kevinclosson.net/2009/12/17/oracle-database-file-system-dbfs-its-not-an-exadata-feature-part-i/
>
> As far as I'm concerned, the DBFS is simply the latest evolution to the
> oradav capability that has allowed us to 'mount the database table as a
> file system' since Oracle8i. It has had many years to mature and become
> robust, but the concept is from the late 90s.
>
> However, dbfs_client is only available on Linux.
>
> /Hans
>
> On 29/08/2014 3:12 AM, Chitale, Hemant K wrote:
>
> Are there organisations that have the courage to use DBFS or ACFS to hold
>
> (a) Flat Files to be interpreted as External Tables
>
> (b) Dump Files to be transferred to other databases
>
> What would be the objections to using storage on the Database Server (as opposed
> to NFS) ?
>
> Hemant K Chitale
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 29 2014 - 19:30:08 CEST

Original text of this message