Re: Restore imposible - solved

        As usual, the problem is solved just after I ask the gurus. The 
solution is written in metalink Note 29430.1 :)

-- 
Regards,
Yavor Ivanov
Senior Database Expert
Stemo Ltd

On Tue, 13 Feb 2007 14:44:34 +0200, Yavor Ivanov <Yavor_Ivanov@xxxxxxxx> wrote:

>       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?
>


--
http://www.freelists.org/webpage/oracle-l

Other related posts: