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 clonedb.pl 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: clonedb.pl

Note, this copy of the script is suitable for clonedb usage with production 11.2.0.2 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 libodm.so. 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.

Summary
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.

About these ads

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

    Kevin,

    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

    11.2.0.1 does not have this package.. Is there anyway i can create using 11.2.0.2 code tree file and use it in 11.2.0.1?

  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 11.1.0.6 to 11.2.0.1 [Release 11.1 to 11.2]. The example in document is based on 11.2.0.2. Does Direct NFS Clonedb feature work with 11.2.0.1 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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

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

Join 2,052 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. 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.

Follow

Get every new post delivered to your Inbox.

Join 2,052 other followers

%d bloggers like this: