Home » RDBMS Server » Backup & Recovery » RMAN restore
RMAN restore [message #222702] Tue, 06 March 2007 01:09 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi friends,

OS : Windows , oracle version : 9.2
I have copied backup taken by RMAN on another server to test restoration.
Only difference is of drive.
Server on which I have copied RMAN backup is having D: drive,while the RMAN bcakup created on E: drive on server from where I have copied backup.
On another server,

RMAN> restore controlfile from 'path';

rman> alter database mount;
database mounted

RMAN> run
2> {
3> set newname for datafile 'E:\ORACLE\ORADATA\AHD\SYSTEM01.DBF' to 'd:\ORACLE\ORADATA\AHD\SYSTEM01.DBF';
4> set newname for datafile 'E:\ORACLE\ORADATA\AHD\UNDOTBS01.DBF' to 'd:\ORACLE\ORADATA\AHD\UNDOTBS01.DBF' ;
5> set newname for datafile 'E:\ORACLE\ORADATA\AHD\CWMLITE01.DBF' to 'd:\ORACLE\ORADATA\AHD\CWMLITE01.DBF' ;
6> set newname for datafile 'E:\ORACLE\ORADATA\AHD\DRSYS01.DBF' to 'd:\ORACLE\ORADATA\AHD\DRSYS01.DBF';
7> set newname for datafile 'E:\ORACLE\ORADATA\AHD\EXAMPLE01.DBF' to 'd:\ORACLE\ORADATA\AHD\EXAMPLE01.DBF';
8> set newname for datafile 'E:\ORACLE\ORADATA\AHD\INDX01.DBF' to 'd:\ORACLE\ORADATA\AHD\INDX01.DBF';
9> set newname for datafile 'E:\ORACLE\ORADATA\AHD\ODM01.DBF' to 'd:\ORACLE\ORADATA\AHD\ODM01.DBF';
10> set newname for datafile 'E:\ORACLE\ORADATA\AHD\TOOLS01.DBF' to 'd:\ORACLE\ORADATA\AHD\TOOLS01.DBF' ;
11> set newname for datafile 'E:\ORACLE\ORADATA\AHD\USERS01.DBF' to 'd:\ORACLE\ORADATA\AHD\USERS01.DBF';
12> set newname for datafile 'E:\ORACLE\ORADATA\AHD\XDB01.DBF' to 'd:\ORACLE\ORADATA\AHD\XDB01.DBF';
13> set newname for datafile 'E:\ORACLE\ORADATA\AHD\AHD1_DATA.ORA' to 'd:\ORACLE\ORADATA\AHD\AHD1_DATA.ORA';
14> set newname for datafile 'E:\ORACLE\ORADATA\AHD\AHD1_IDX.ORA' to 'd:\ORACLE\ORADATA\AHD\AHD1_IDX.ORA';
15> set newname for datafile 'E:\ORACLE\ORADATA\AHD\AHD2_DATA.ORA' to 'd:\ORACLE\ORADATA\AHD\AHD2_DATA.ORA';
16> set newname for datafile 'E:\ORACLE\ORADATA\AHD\PERFSTAT.ORA' to 'd:\ORACLE\ORADATA\AHD\PERFSTAT.ORA';
17> }

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

2> RMAN> run
2> {
3> switch datafile all;
4> }


RMAN> restore database;

Starting restore at 06-MAR-07

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\ORADATA\AHD\SYSTEM01.DBF
restoring datafile 00002 to E:\ORACLE\ORADATA\AHD\UNDOTBS01.DBF
restoring datafile 00003 to E:\ORACLE\ORADATA\AHD\CWMLITE01.DBF
restoring datafile 00004 to E:\ORACLE\ORADATA\AHD\DRSYS01.DBF
restoring datafile 00005 to E:\ORACLE\ORADATA\AHD\EXAMPLE01.DBF
restoring datafile 00006 to E:\ORACLE\ORADATA\AHD\INDX01.DBF
restoring datafile 00007 to E:\ORACLE\ORADATA\AHD\ODM01.DBF
restoring datafile 00008 to E:\ORACLE\ORADATA\AHD\TOOLS01.DBF
restoring datafile 00009 to E:\ORACLE\ORADATA\AHD\USERS01.DBF
restoring datafile 00010 to E:\ORACLE\ORADATA\AHD\XDB01.DBF
restoring datafile 00011 to E:\ORACLE\ORADATA\AHD\AHD1_DATA.ORA
restoring datafile 00012 to E:\ORACLE\ORADATA\AHD\AHD1_IDX.ORA
restoring datafile 00013 to E:\ORACLE\ORADATA\AHD\AHD2_DATA.ORA
restoring datafile 00014 to E:\ORACLE\ORADATA\AHD\PERFSTAT.ORA
restoring datafile 00015 to E:\ORACLE\ORADATA\AHD\QUEST.ORA
RMAN-00571: ======================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS RMAN-00571: =============================================
RMAN-03002: failure of restore command at 03/06/2007 11:35:05
ORA-19505: failed to identify file "E:\RMAN_BCKP\ORA_DF616429325_S1_S1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


Why it is restoring to old location, though I have set new location for all datafiles?
& it is searching backup in E: drive, but it is present in D: drive on new host.
I have mapped location of original server as E: , but it is not accepting that location.
Re: RMAN restore [message #222706 is a reply to message #222702] Tue, 06 March 2007 01:25 Go to previous messageGo to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Hi,

Have you taken all the files on offline with proper shutdown?

If not do it properly, becuase it will becuase of the controlfile have the old path info.
Re: RMAN restore [message #224874 is a reply to message #222702] Thu, 15 March 2007 16:37 Go to previous message
clintonf
Messages: 82
Registered: May 2006
Member
The backup piece file "E:\RMAN_BCKP\ORA_DF616429325_S1_S1" also needs to be on the auxiliary machine in exactly the same path.

You can use networking to make the file available if possible or just have it locally on the auxiliary machine.
Previous Topic: Recovery Ways
Next Topic: rman: cannot open target
Goto Forum:
  


Current Time: Mon Dec 05 09:09:01 CST 2016

Total time taken to generate the page: 0.12167 seconds