ADSM-L

TDP for Oracle : Duplicate database on different machines gives error ORA-19507

2003-10-28 03:27:44
Subject: TDP for Oracle : Duplicate database on different machines gives error ORA-19507
From: "Wijnbergen, AMv" <arnold.van.wijnbergen AT METRO-MCC DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 28 Oct 2003 09:12:14 +0100
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

<Prev in Thread] Current Thread [Next in Thread>
  • TDP for Oracle : Duplicate database on different machines gives error ORA-19507, Wijnbergen, AMv <=