Home » RDBMS Server » Backup & Recovery » Disaster recovery!! Please help me !!!
Disaster recovery!! Please help me !!! [message #186982] Thu, 10 August 2006 07:38 Go to next message
benciolini
Messages: 4
Registered: August 2006
Junior Member
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 !!
Re: Disaster recovery!! Please help me !!! [message #186985 is a reply to message #186982] Thu, 10 August 2006 07:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Is the E: drive a mapped drive?
Re: Disaster recovery!! Please help me !!! [message #186990 is a reply to message #186985] Thu, 10 August 2006 08:00 Go to previous messageGo to next message
benciolini
Messages: 4
Registered: August 2006
Junior Member
Yes. Why are you asking this ?
Re: Disaster recovery!! Please help me !!! [message #187000 is a reply to message #186990] Thu, 10 August 2006 08:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Well you mentioned that you already restored the spfile & controlfiles. What command did you issue to successfully restore those?
Re: Disaster recovery!! Please help me !!! [message #187007 is a reply to message #186982] Thu, 10 August 2006 08:57 Go to previous messageGo to next message
benciolini
Messages: 4
Registered: August 2006
Junior Member
i copied by operating system the control files, the init.ora files, the PWDepeweb.ora file and the SPFILEepeweb.ora.

So the database can be mount and it find the backupsets;
Re: Disaster recovery!! Please help me !!! [message #187011 is a reply to message #187007] Thu, 10 August 2006 09:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What control file are you restoring? Does it coincide with the backupset? You shouldn't have to do any manual copying for restore/recovery. You should be able to STARTUP NOUMOUNT and then let RMAN restore the spfile & control file from backup (that's assuming you backed up the control file & spfile with RMAN).

You should read over Performing Disaster Recovery.
Re: Disaster recovery!! Please help me !!! [message #187031 is a reply to message #187011] Thu, 10 August 2006 10:31 Go to previous messageGo to next message
benciolini
Messages: 4
Registered: August 2006
Junior Member
yes thanks!!

i restor controlo file and spfile from autobackup and it works very well.

The problem is that it's impossible to use a mapped drive!! It needs to use different fisical drive if my backup is stored in a different disk from the oracle's disk !!

Thanks a lot !!!
Re: Disaster recovery!! Please help me !!! [message #187034 is a reply to message #187031] Thu, 10 August 2006 10:37 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In order to utilize the mapped drive, you need to ensure that the Windows services for the database and the listener are started with the same account/password as you have configured for the mapped drive.

Were you able to recover successfully? If so, how did you deal with the mapped drive issue?

[Updated on: Thu, 10 August 2006 10:38]

Report message to a moderator

Previous Topic: rman error
Next Topic: Oracle 8i
Goto Forum:
  


Current Time: Mon Dec 05 02:56:43 CST 2016

Total time taken to generate the page: 0.26586 seconds