Re: duplicate erro

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_at_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.

Did you copy the backup files to the auxiliary server?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org