I restored the controlfile from autobackup taken right after the backup (much before creating the new tablespace). If I use newer controlfile, I have other troubles, with RESTORE - there is no backup of the new datafile :) -- Regards, Yavor Ivanov Senior Database Expert Stemo Ltd On Tue, 13 Feb 2007 16:26:49 +0200, Naqi Mirza <naqimirza@xxxxxxxxx> wrote: > Are you not performing this procedure with the latest control file ? > > ----- Original Message ---- > From: Yavor Ivanov <Yavor_Ivanov@xxxxxxxx> > To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> > Sent: Tuesday, 13 February, 2007 5:44:34 PM > Subject: Restore imposible > > Hello, gurus > > I am practicing some hard restore scenarios. I got to the following > unsolvable (for me) case: > This is 10.3.0.3 on Windows. Backup is made on RAC database stored on > ASM. Restore has to be done on simple database on simple file system. The > database is in archivelog. No catalog database is used. > The catch is, that AFTER the last backup, a new tablespace is created > (undo3). I cannot use SET NEWNAME for it's file because it does not exist > before I reach it with RECOVER. The RECOVER command cannot create it because > it tries for ASM. Here's the script so far: > > RMAN> run { > set newname for datafile '+DGINKASO/inkaso/datafile/system.259.614014161' to > 'c:\oracle\oradata\inkaso\system.dbf'; > set newname ... > ... > restore database; > switch datafile all; > } > -- No problems so far > RMAN> recover database until sequence 50 thread 1; > > starting media recovery > ... > archive log filename=C:\ARCHIVE\ARC00019_0614014506.002 thread=2 sequence=19 > archive log filename=C:\ARCHIVE\ARC00016_0614014506.001 thread=1 sequence=16 > archive log filename=C:\ARCHIVE\ARC00017_0614014506.001 thread=1 sequence=17 > creating datafile fno=6 name=+DGINKASO/inkaso/datafile/undo3.272.614107635 > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of recover command at 02/13/2007 14:31:22 > ORA-01119: error in creating database file '+DGINKASO' > ORA-17502: ksfdcre:4 Failed to create file +DGINKASO > ORA-15001: diskgroup "DGINKASO" does not exist or is not mounted > ORA-15077: could not locate ASM instance serving a required diskgroup > ORA-29701: unable to connect to Cluster Manager > > The question is: is there any way to change datafile name/location during > RECOVER? > -- //www.freelists.org/webpage/oracle-l