Hi *sm ers, I have a question regarding TDP for Oracle 2.2.1.0 with Oracle 8.1.7.4. Our dba's want to duplicate a database with RMAN/TDP to a different machine.
Everything goes well when duplication is done to a local instance,but fails to a remote host. Is this a limitation of TDP? We use the following rman script for duplication. replace script db_copy { set until time '26-OCT-2003 01:24:40'; allocate auxiliary channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=D:\progra~1\tivoli\tsm\agentOBA\tdpo.opt)'; set newname for datafile 1 to 'f:\dbfiles\repat\system.dbf'; set newname for datafile 2 to 'f:\dbfiles\repat\rb_disk1.dbf'; set newname for datafile 3 to 'f:\dbfiles\repat\rp_users.dbf'; set newname for datafile 4 to 'f:\dbfiles\repat\temp.dbf'; set newname for datafile 5 to 'f:\dbfiles\repat\tools.dbf'; set newname for datafile 6 to 'f:\dbfiles\repat\rb_disk2.dbf'; set newname for datafile 7 to 'f:\dbfiles\repat\rp_it1.dbf'; set newname for datafile 8 to 'f:\dbfiles\repat\rp_it2.dbf'; set newname for datafile 9 to 'f:\dbfiles\repat\rp_ts1.dbf'; set newname for datafile 10 to 'f:\dbfiles\repat\rp_ts2.dbf'; duplicate target database to repat logfile 'f:\dbfiles\repat\logt01.dbf' size 200K, 'f:\dbfiles\repat\logt02.dbf' size 200K, 'f:\dbfiles\repat\logt03.dbf' size 200K ; release channel t1; } run { execute script db_copy; } When we do a duplicate to the remote host we get the following error RMAN-03022: compiling command: IRESTORE RMAN-03023: executing command: IRESTORE RMAN-08016: channel t1: starting datafile backupset restore RMAN-08502: set_count=83 set_stamp=508382634 creation_time=26-OCT-2003 01:23:54 RMAN-08089: channel t1: specifying datafile(s) to restore from backup set RMAN-08523: restoring datafile 00003 to F:\DBFILES\REPAT\RP_USERS.DBF RMAN-08523: restoring datafile 00007 to F:\DBFILES\REPAT\RP_IT1.DBF RMAN-08523: restoring datafile 00010 to F:\DBFILES\REPAT\RP_TS2.DBF RMAN-03026: error recovery releasing channel resources RMAN-08031: released channel: t1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03015: error occurred in stored script db_copy RMAN-03002: failure during compilation of command RMAN-03013: command type: Duplicate Db RMAN-03015: error occurred in stored script Memory Script RMAN-03002: failure during compilation of command RMAN-03013: command type: restore RMAN-03007: retryable error occurred during execution of command: IRESTORE RMAN-07004: unhandled exception during command execution on channel t1 RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file, handle="f:\arcfiles\repa\dfoffline_REPA_83_1", parms="" ORA-27029: skgfrtrv: sbtrestore returned error RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE Recovery Manager complete. Has anyone experience with database duplication to different Oracle TDP host ? Kind Regards, Arnold METRO Cash & Carry Netherlands