}

cptkirkh wrote:
> 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.