How if you try this run{ ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '…\BACKUP_%U'; SET NEWNAME FOR DATAFILE 1 TO '….\SYSTEM01.DBF'; SWITCH DATAFILE 1; } On Fri, Feb 8, 2008 at 11:20 AM, Wolfson Larry - lwolfs < lawrence.wolfson@xxxxxxxxxx> wrote: > Hi guys, > > > > I'm migrating a number of 9.2.0.1.0 32 &64 bit DBs to new > servers with "rman" > > At some point we'll be upgrading them there. > > > > > > They asked me to rename all files to new naming (directory) > standards. > > I'm not big "rman" user, but everything has gone well so far until I hit > the largest DB. > > > > It's about 800G and at first only 500 was allocated. > > When it was pointed out we needed another 500 it was allocated but to > another 500G directory. > > > > When doing the restore how can I get some files to go to the new FS? > > Or do I have to have them increase old FS? > > > > I've tried the SET NEWNAME command and when I run it it says it worked > but the files always want to go to original place. > > > > > > RUN > > { > > SET NEWNAME FOR DATAFILE '/x/system01.dbf' TO '/y/system01.dbf' ; > > SWITCH DATAFILE ALL; > > } > > > > The others were easy. Just changed initora and moved controlfiles to new > directory. > > Then ran > > ALTER DB RENAME (had linked old directories to new ones) > > > > Again this is 9.2.0.1.0. > > > > THX > > Larry > > ************************************************************************* > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank you. > ************************************************************************* > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.19.18/1254 - Release Date: > 1/31/2008 8:30 PM >