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 -> Has anyone duplicated a 10gR2 database (with tempfiles) using RMAN

Has anyone duplicated a 10gR2 database (with tempfiles) using RMAN

From: Snewber <snew_at_snew.com>
Date: Fri, 11 Nov 2005 14:34:15 +1000
Message-ID: <dl1707$hhf$1@bunyip2.cc.uq.edu.au> 





I was wondering if anyone has done this yet as the 10gR2 version of RMAN 
records tempfile information, but I have been unable to duplicate a 
database without having to drop and add the tempfiles manually.



New syntax allows for tempfile renaming, however, I still get errors 
when the tempfile is first used.



set newname for tempfile 1 to '/a01/o/DUP/temp.dbf';



SWITCH TEMPFILE ALL;

Received on Thu Nov 10 2005 - 22:34:15 CST












Original text of this message













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