duplicate erro

[cptkirkh]

I am trying to learn how to duplicate a database using RMAN. I am
running oracle 10.0.1.0.3. Here is what i did so far. I installed
Oracle on my Aux server. This server has the same directory structure
as the target server and both are windows server 2003 sp2. I then
installed my database on the aux server through the database c. I
then connected via Database Configuration Tool. In then do a full
backup on my target server. I then startup the aux db using startup
nomount command. I then logon to the target server and connect via
sqlplus suing the following command.
rman target sys/password for sys @ target db name auxiliary sys/
password for sys@aux db name. Then I issue the command duplicate
target database to "aux db name" nofilenamecheck. I get the following
error, "Starting Duplicate Db at 02-AUG-07
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
set until scn 1114742811;
set newname for datafile 1 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\UNDOTBS01.DBF";
set newname for datafile 3 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\SYSAUX01.DBF";
set newname for datafile 4 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS01.DBF";
set newname for datafile 5 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS02.DBF";
restore
check readonly
clone database
;
}
executing 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

Starting restore at 02-AUG-07
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 F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\SYSTEM01.DBF
restoring datafile 00002 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\UNDOTBS01.DBF
restoring datafile 00003 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\SYSAUX01.DBF
restoring datafile 00004 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\USERS01.DBF
restoring datafile 00005 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\USERS02.DBF
ORA-19624: operation failed, retry possible
ORA-19505: failed to identify file "F:\ORACLE\PRODUCT
\10.1.0\FLASH_RECOVERY_AREA\IAIO877A_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
failover to previous backup

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 F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\SYSTEM01.DBF
restoring datafile 00002 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\UNDOTBS01.DBF
restoring datafile 00003 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\SYSAUX01.DBF
restoring datafile 00004 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\USERS01.DBF
restoring datafile 00005 to F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY
\USERS02.DBF
ORA-19624: operation failed, retry possible
ORA-19587: error occurred reading 0 bytes at block number 1
ORA-27091: unable to queue I/O
ORA-27067: size of I/O buffer is invalid
OSD-04026: Invalid parameter passed.
failover to previous backup

RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of Duplicate Db command at 08/02/2007 09:11:47
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "off": expecting one of: "log, msglog,
trace"
RMAN-01007: at line 1 column 7 file: standard input

What could have done wrong? I looked in the folder on the target
server and that file is located there. Is it possible it is looking
for the backup file in the flash recovery area on the auviliary
server? Thanks for your help.

[DA Morgan]

Did you copy the backup files to the auxiliary server?
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org