Re: Restore imposible - solved
- From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Feb 2007 15:53:58 +0200
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?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
