Re: DBFS or ACFS for Flat Files and Dump Files

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Andy Rivenes <andy.rivenes@xxxxxxxxxx>
  • Date: Fri, 29 Aug 2014 19:30:08 +0200

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@xxxxxxxxxx>
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@xxxxxxxxx]
> *Sent:* Friday, August 29, 2014 10:18 AM
> *To:* Andy Rivenes
> *Cc:* fuzzy.graybeard@xxxxxxxxx; 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@xxxxxxxxxx>
> 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@xxxxxxxxx]
> *Sent:* Friday, August 29, 2014 5:54 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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
> .
>
>
>
>
>

Other related posts: