Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> duplicate erro

duplicate erro

From: cptkirkh <khill_at_scic.com>
Date: Thu, 02 Aug 2007 14:20:34 -0000
Message-ID: <1186064434.621442.167080@k79g2000hse.googlegroups.com>


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. Received on Thu Aug 02 2007 - 09:20:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US