Clonedb and DNFS

From: "Kevin Lidh" <kevin.lidh@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 18 Jun 2012 12:55:12 -0600
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



--
//www.freelists.org/webpage/oracle-l
Clonedb and DNFS

Other related posts:
