Oracle Database 11g Direct NFS Clonedb Feature – Part I (and a half).

In Part I of my series on Oracle Database 11g Release 2 Direct NFS Clonedb, I offered short videos with a presentation and a demonstration of the feature. I received a significant amount of email which essentially asked the same few questions. So, instead of answering a bunch of email individually, I’ll address the questions here:

Q. Why is your demonstration modeled around cloning an RMAN backup stored in a file system? All Oracle customers use ASM!
A. I’ve put out Part I as an introduction to the technology. I’ll have more on ASM later. I’m certain that not all customers use ASM. Some might even comment on this post accordingly.

Q. What are the NFS server requirements for the CLONE_FILE_CREATE_DEST?
A. Any NFS mount that supports Oracle Database 11g Direct NFS. Now, this is a bit tricky. Since we are talking about test and development instances I’m not convinced it has to be a commercial-grade filer. After all, the only data that will be stored on NFS with this model is the changed block files (COW) and any new datafiles the test/development instance creates. I have tested on a simple HP Proliant storage server running Linux and exporting NFS shares, but that shouldn’t be misconstrued as a support statement.

Q. What is the My Oracle Support note number mentioned in the Part I?
A. The MOS note is 1210656.1. Keep an eye out for it.

Q. Where can I get the script?
A. Once the MOS note is online the perl script will be available there. It is just a script that automates a few important tasks and generates SQL (very helpful by the way). I’ll offer a copy at the following link:

Note, this copy of the script is suitable for clonedb usage with production Oracle. After the performance patch (10403302) is applied this rendition of the script will not work. With that performance patch, the clonedb instance needs to boot with the new init.ora parameter clonedb set to true. The new script will generate the requisite text into the auto-generated clone init.ora.

Q. Does the RMAN backup need to be stored in an NFS mount?
A. No. The copy-on-write/thin-provisioning aspect of the feature is implemented in For this reason the CLONE_FILE_CREATE_DEST assignment needs to be to an NFS mount. That RMAN backup can be elsewhere. More on that later.

Q. What about hot RMAN backups and incremental backups?
A. As I mentioned in Part I, I’ll be going into more detail about such topics as how the snapshot features of commercial NFS filers can augment the Oracle Database 11g Direct NFS clonedb feature. I’ll go over hot backups in that post.

Folks, thus far the intent was to get introductory materials out so we can all end 2010 thinking about a new way to do something old. I’ve left questions unanswered because, after all, we are only at Part I (and a half) in the series.

18 Responses to “Oracle Database 11g Direct NFS Clonedb Feature – Part I (and a half).”

  1. 1 Alexei December 27, 2010 at 5:19 pm


    Your post is great. ASM is very, very interesting issue, please touch it also.

    Thank you

  2. 2 Freek December 28, 2010 at 12:41 pm

    In your post you refer to performance patch 10403302.
    Any more info on this? MOS and google did not find anything useful on this (only references to this article…)

  3. 3 Noons December 29, 2010 at 12:58 am

    ummm, I guess I’m not an Oracle customer, because I don’t use ASM?

  4. 4 Scott January 4, 2011 at 9:43 pm

    Thanks for the post. Using a standard linux server to host the nfs share was able to clone a database.

  5. 6 Kiran January 10, 2011 at 4:48 pm does not have this package.. Is there anyway i can create using code tree file and use it in

  6. 8 Neil_Li January 30, 2011 at 4:32 am

    I didn’t find the patch 10403302 from metalink, Kevin, is that patch not published yet?

  7. 9 Steve_F February 7, 2011 at 8:48 pm

    Thanks for the informaton Kevin. I checked with Oracle support, they shared a note with me which is still under review, basically using rman to create backups and renaming the cloned datafiles using the dbms_dnfs.clonedb_renamefile(backup_file_name, new_data_filename). I also am testing NetApp SMO (Snap Manager for Oracle) product for use in cloning Oracle databases for test/dev.

  8. 11 Marty October 20, 2011 at 2:24 am

    “After the performance patch (10403302) is applied…”

    Checking MOS and logging an SR found no such patch. Was this ever released?

  9. 12 raghumutyam September 25, 2013 at 10:26 am

    MOS doc 1210656.1 suggest that it applies to Version to [Release 11.1 to 11.2]. The example in document is based on Does Direct NFS Clonedb feature work with version?

  10. 13 sceva p April 16, 2014 at 12:26 am

    Hi kevinclosson,
    Can we use Direct NFS on ASM, i mean my target system is RAC using ASM, so is there a possibility to point CLONE_FILE_CREATE_DEST onto ASM disk ?

  1. 1 Log Buffer #211, A Carnival of the Vanities for DBAs « So Many Oracle Manuals, So Little Time Trackback on December 31, 2010 at 7:44 am
  2. 2 clonedb « Oracle Scratchpad Trackback on January 6, 2011 at 9:07 am
  3. 3 Virtual DB | Oracle Scratchpad Trackback on March 9, 2013 at 2:52 am
  4. 4 Oracle Database 11g Direct NFS Clonedb Feature – Part I. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on March 30, 2013 at 8:57 am
  5. 5 RMAN "DELETE FOR DB_UNIQUE_NAME" avec discernement | ArKZoYd Trackback on August 6, 2013 at 9:13 am

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 744 other subscribers
Oracle ACE Program Status

Click It

website metrics

Fond Memories


All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: