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.D BF";
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.D BF";
set newname for datafile 4 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS01.DB F";
set newname for datafile 5 to
"F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS02.DB F";
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.

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.D BF";
> 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.D BF";
> set newname for datafile 4 to
> "F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS01.DB F";
> set newname for datafile 5 to
> "F:\ORACLE\PRODUCT\10.1.0\ORADATA\PORKY\USERS02.DB F";
> 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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org