Clonedb and DNFS

From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Mon, 18 Jun 2012 12:55:12 -0600
Message-ID: <007801cd4d83$e538eca0$afaac5e0$_at_gmail.com>

I've been asked to evaluate a product that claims to be able to clone an Oracle database by using a backup as a "starting point" and then it logs changes to the datafiles locally to the test or development databases and the clones take less than 10% of the space as the source database. It sounded very similar to the method I learned at RMOUG which is described in MOS 1210656.1. I've found a few blogs around which step through it with varying degrees of detail.  

I've been trying to set up a demo of this method using Virtualbox and two CentOS 5.5 guests. I have an NFS shared and 11.2.0.3.0 on both. I created a source database and followed the steps for the image backup and control file creation. The control files show up in v$dnfs_files when the target database is mounted. But when I try to rename the image data file,  

idle> exec
dbms_dnfs.clonedb_renamefile('/nfsshare/backup/mprod/data_D-MPROD_I-24776316 33_TS-USERS_FNO-4_15ndr0q2' ,
'/nfsshare/oradata/mtest/ora_data_mtest3.dbf');
BEGIN
dbms_dnfs.clonedb_renamefile('/nfsshare/backup/mprod/data_D-MPROD_I-24776316 33_TS-USERS_FNO-4_15ndr0q2' ,
'/nfsshare/oradata/mtest/ora_data_mtest3.dbf'); END;

*
ERROR at line 1:
ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 4 - new file
'/nfsshare/oradata/mtest/ora_data_mtest3.dbf' not found
ORA-01110: data file 4:
'/nfsshare/backup/mprod/data_D-MPROD_I-2477631633_TS-USERS_FNO-4_15ndr0q2'
ORA-17515: Creation of clonedb failed using snapshot file /nfsshare/backup/mprod/data_D-MPROD_I-2477631633_TS-USERS_FNO-4_15ndr0q2 ORA-06512: at "SYS.X$DBMS_DNFS", line 10 ORA-06512: at line 1

idle>  

It actually creates the new file at
/nfsshare/oradata/mtest/ora_data_mtest3.dbf but says it's not found.  

So what I'm wondering is, has anyone gotten this to work in 11.2.0.3.0? I only see references to 11.2.0.2.0 everywhere. If somebody has attempted it, has anyone seen this error stack before? I hate the idea of spending money on a product when we can get the functionality we need with the licensing we already have.  

Thanks in advance,  

Kevin

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 18 2012 - 13:55:12 CDT