Oracle Database Discussions

Hello Guru's

I am working on Cloning of the DATABASE every step worked properly but while actual cloning i.e. the final step i got the following error....

C:\Documents and Settings\Administrator>rman target=sys/qwerty@lion catalog=rman
1/rman@lion AUXILIARY /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: LION (DBID=423761461)
connected to recovery catalog database
connected to auxiliary database (not started)

RMAN> duplicate target database to clonedb nofilenamecheck;

Starting Duplicate Db at 10-DEC-09
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=12 devtype=DISK

printing stored script: Memory Script
{
set until scn 2468579;
set newname for datafile 1 to
"D:\ORACLE\ORADATA\LION\SYSTEM01.DBF";
set newname for datafile 2 to
"D:\ORACLE\ORADATA\LION\UNDOTBS01.DBF";
set newname for datafile 3 to
"D:\ORACLE\ORADATA\LION\CWMLITE01.DBF";
set newname for datafile 4 to
"D:\ORACLE\ORADATA\LION\DRSYS01.DBF";
set newname for datafile 5 to
"D:\ORACLE\ORADATA\LION\EXAMPLE01.DBF";
set newname for datafile 6 to
"D:\ORACLE\ORADATA\LION\INDX01.DBF";
set newname for datafile 7 to
"D:\ORACLE\ORADATA\LION\ODM01.DBF";
set newname for datafile 8 to
"D:\ORACLE\ORADATA\LION\TOOLS01.DBF";
set newname for datafile 9 to
"D:\ORACLE\ORADATA\LION\USERS01.DBF";
set newname for datafile 10 to
"D:\ORACLE\ORADATA\LION\XDB01.DBF";
set newname for datafile 12 to
"D:\ORACLE\ORADATA\LION\RMAN01.DBF";
restore
check readonly
clone database
;
}
executing script: Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 10-DEC-09

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\LION\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\ORADATA\LION\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\LION\CWMLITE01.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\LION\DRSYS01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\LION\EXAMPLE01.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\LION\INDX01.DBF
restoring datafile 00007 to D:\ORACLE\ORADATA\LION\ODM01.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\LION\TOOLS01.DBF
restoring datafile 00009 to D:\ORACLE\ORADATA\LION\USERS01.DBF
restoring datafile 00010 to D:\ORACLE\ORADATA\LION\XDB01.DBF
restoring datafile 00012 to D:\ORACLE\ORADATA\LION\RMAN01.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/10/2009 17:25:01
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file "D:\ORACLE\ORADATA\LION\SYSTEM01.DBF"
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Can any one suggest me the problem ...

Thanks & Regards
Pratik Lakhpatwala
Jr Oracle DBA
pratik.lakhpatwala@gmail.com