Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Disaster recovery

Re: Disaster recovery

From: bencio <gbenciolini_at_yahoo.it>
Date: 10 Aug 2006 05:58:32 -0700
Message-ID: <1155214711.525434.90770@h48g2000cwc.googlegroups.com>


Thanks Peter,

i tried like you wrote !!!
But this is the result:

crosscheck answare me that all the bacupsets are 'EXPIRED'

validate don't work

What can i do to restore the backupsets to a valid status ?

Thanks !!!!

peter ha scritto:

> 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:58:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US