CODEWITHSUNDEEP
oracle-databaseblobdata-migration
sammy
sammy

Reputation: 524

Oracle SecureFile

In my current workplace, an existing app is being replaced by a new 3rd party app. The database of the existing app, in Oracle 10g, needs to migrated. The existing app stored various documents as BLOBs. Per the new app's data model, they store the documents in files. I am tasked with conversion of existing BLOBs to files.

There are around 5 million records amounting to a total of 1 TB.

I am wondering if we can leverage the idea of Oracle SecureFile in this process. We do have some Oracle 11g environments available. This is my idea:

1) Import the existing 10g BLOBs into 11g SecureFiles. 2) Convert the Oracle SecureFiles (DBFS) to Windows file system (CIFS?).

The advantage with this idea is that the BLOB to File conversion process would be native and is taken care of by Oracle (in other words, performant, tested and exception-handled process). I have no clue about the file system conversion though.

Experts, is this a feasible idea? Dont know if this helps... but the new app is on Oracle 11gR2.

Upvotes: 2

Views: 1392

Answers (1)

user123664
user123664

Reputation:

You can convert the blobs to docs and drop them in a dbfs. If you define the dbfs to use securefiles - recommended - and during the initial load with filesystem like logging, you have a good performant filesystem, comparable with nfs performance. Problem with the windows environment is that you can not mount a dbfs native on windows (AFAIK). You could however mount it on Linux and pass in through to cifs. Not exactly an ideal solution but maybe useable as a workaround until native dbfs mount becomes available on Windows.

The filesystem like logging is good for performance, not for recovery or feeding to standby databases. This is because only the file metadata is logged, not the contents. You should include this knowledge in your recovery process, or swith to full logging after the initial load/conversion completes. That would be my preference.

dbfs is great, combined with advanced compression it can save quite a lot of space.

Upvotes: 0

Related Questions