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

Anno Domini 2-11-2005 5:50, Snewber sprak aldus:

> 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;
> }

You need to ad a tempfile to the temporary tablespace manually. This has always been the case. Received on Wed Nov 02 2005 - 00:11:42 CST