Re: Disaster recovery

Hi,

First try to check the backup with "List Backup" command then if it shows you backup is available then check that with crosscheck and validate commands
crosscheck backupset <backupset number>; validate backupset <backupset number>;

and whereas I know while restoring database you don't have to give any path.
If in the end your backup status is still available then only give restore and recover command. Don't give the path.
> RMAN> run
> 2> {
> 3> allocate channel Channel1 type disk;
> 4> set until SCN 186529587;
> 5> restore database;
> 6> recover database;
> 7> }

Try this......
Hope it will solve the problem....

Thank you

bencio wrote:
> 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 - 07:36:29 CDT