RE: Restore imposible - solved
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <Yavor_Ivanov@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Feb 2007 10:40:10 -0500
One of the commands I have been fortunate enough never to have used.
Thanks for a practical application thereof.
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
Tel.: 508.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yavor Ivanov
Sent: Tuesday, February 13, 2007 8:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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?
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
