10gR2 (10g Release 2) RMAN Duplicate database which has tempfiles?

From: Snewber <snew_at_snew.com>
Date: Wed, 02 Nov 2005 14:50:35 +1000
Message-ID: <dk9gir$1k2v$1@bunyip2.cc.uq.edu.au>

I can duplicate the database without error, but the tempfile(s) are not setup correctly. For example, when I run the following query, on the newly duplicated database, I get the following error:

select * from dba_temp_files ;
ORA-01187: cannot read from file 151 because it failed verification tests ORA-01110: data file 151: '/a01/oradata/DUP/temp_01.dbf'

So I need to drop the tempfile and then add it again. Is there a better way of doing this with RMAN in the latest 10gR2 version?

I'm using the following RMAN commnads:

# target and auxilary connections are set up prior to here run {

   set until time = '02-NOV-2005 10:26:36';

   set newname for tempfile 1 to '/a01/o/DUP/temp.dbf';
   set newname for datafile 1 to '/a01/o/DUP/system.dbf';
   set newname for datafile 2 to '/a01/o/DUP/undo.dbf';
   set newname for datafile 3 to '/a01/o/DUP/sysaux.dbf';

   duplicate target database to DUP
   LOGFILE

     GROUP 1 ('/a04/oradata/DUP/redo_01a.log') SIZE 100M,
     GROUP 2 ('/a04/oradata/DUP/redo_02a.log') SIZE 100M;

} Received on Tue Nov 01 2005 - 22:50:35 CST