| Disaster recovery!! Please help me !!! [message #186982] |
Thu, 10 August 2006 07:38  |
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 #187031 is a reply to message #187011] |
Thu, 10 August 2006 10:31  |
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
