Disaster recovery

From: bencio <gbenciolini_at_yahoo.it>
Date: 10 Aug 2006 04:09:07 -0700
Message-ID: <1155208147.635586.131310@b28g2000cwb.googlegroups.com>

Hi all !!!

Excuse me for my bad english !!!

I'm doing a disaster recovery frmo a server that i need to install a new Windows Server 2003 because of corruption.

I have backup with autobackup of the controlfile.

I create a new installation of Oracle Server with the same path tree of the original server.

Now i'm trying to restore database.

I've allready restore spfiles and controlfiles.

Now i'm tring to restore all database but i encounter an error like this (this is my RMAN script and the result):

RMAN> run
2> {
3> allocate channel Channel1 type disk format 'E:\backup\setBCK\b_%u_%p_%c';

4> set until SCN 186529587;
5> restore database;
6> recover database;
7> }

allocated channel: Channel1
channel Channel1: sid=11 devtype=DISK

executing command: SET until clause

Starting restore at 10-AUG-06

channel Channel1: starting datafile backupset restore channel Channel1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to C:\ORACLE\ORADATA\EPEWEB\SYSTEM01.DBF
restoring datafile 00002 to C:\ORACLE\ORADATA\EPEWEB\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORACLE\ORADATA\EPEWEB\CWMLITE01.DBF
restoring datafile 00004 to C:\ORACLE\ORADATA\EPEWEB\DRSYS01.DBF
restoring datafile 00005 to C:\ORACLE\ORADATA\EPEWEB\EXAMPLE01.DBF
restoring datafile 00006 to C:\ORACLE\ORADATA\EPEWEB\INDX01.DBF
restoring datafile 00007 to C:\ORACLE\ORADATA\EPEWEB\ODM01.DBF
restoring datafile 00008 to C:\ORACLE\ORADATA\EPEWEB\TOOLS01.DBF
restoring datafile 00009 to C:\ORACLE\ORADATA\EPEWEB\USERS01.DBF
restoring datafile 00010 to C:\ORACLE\ORADATA\EPEWEB\XDB01.DBF
restoring datafile 00011 to C:\ORACLE\ORADATA\EPEWEB\EPE.ORA
restoring datafile 00012 to C:\ORACLE\ORADATA\EPEWEB\ECY2K.ORA
restoring datafile 00013 to C:\ORACLE\ORADATA\EPEWEB\FIERI.ORA
restoring datafile 00014 to C:\ORACLE\ORADATA\EPEWEB\DCS.ORA
restoring datafile 00016 to C:\ORACLE\ORADATA\EPEWEB\FIERI_NDX.ORA
restoring datafile 00017 to C:\ORACLE\ORADATA\EPEWEB\FIERI_PK.ORA
restoring datafile 00018 to C:\ORACLE\ORADATA\EPEWEB\EPE_NDX.ORA
restoring datafile 00019 to C:\ORACLE\ORADATA\EPEWEB\EPE_PK.ORA
restoring datafile 00020 to C:\ORACLE\ORADATA\EPEWEB\FLT.ORA
restoring datafile 00021 to C:\ORACLE\ORADATA\EPEWEB\FLT_NDX.ORA
restoring datafile 00022 to C:\ORACLE\ORADATA\EPEWEB\FLT_PK.ORA
restoring datafile 00023 to C:\ORACLE\ORADATA\EPEWEB\EVENT_NDX.ORA

released channel: Channel1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 08/10/2006 12:16:51

ORA-19505: failed to identify file "E:\BACKUP\SETBCK\B_44HQCGUN_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

-------------------------------------------------------------------------------------------------------------------------

I verify the presence of the file "E:\BACKUP\SETBCK\B_44HQCGUN_1_1". It exist in the precise path !!
I verify also the permission and that's ok.

I don't know what to do !!!

I have in the directory where i stored the backup, two different backupset.
If i try to restore UNTIL one of them, RMAN indicates that it's unable to open the other file and viceversa !!

Someone can help me ??

Thanks a lot !! Received on Thu Aug 10 2006 - 06:09:07 CDT