Re: Restore imposible

  • From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
  • To: naqimirza@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 13 Feb 2007 17:29:11 +0200

        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


Other related posts: