Re: Question on RMAN Restore into another server having different file structure
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: anuragdba@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 16 Apr 2007 11:54:33 -0700
run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(NSR_DATA_VOLUME_POOL=poolname, NSR_SERVER=server,
NSR_CLIENT=clientname)';
setlimit channel t1 kbytes 2097150;
SET NEWNAME FOR DATAFILE 12 TO '/opt/oracle/admin/<database>/indxes01.dbf';
SET NEWNAME FOR DATAFILE 16 TO '/opt/oracle/admin/<database>/indxes02.dbf';
RESTORE DATABASE;
release channel t1;
}
run {
allocate channel d1 type disk;
SET NEWNAME FOR DATAFILE '/u009/SID/indxes01.dbf' TO
'/opt/oracle/admin/<database>/indxes01.dbf';
SET NEWNAME FOR DATAFILE '/u009/SID/indxes02.dbf' TO
'/opt/oracle/admin/<database>/indxes02.dbf';
switch datafile all;
release channel d1;
}
HTH
GovindanK
On Sun, 15 Apr 2007 16:54:18 -0500, "Anurag Verma" <anuragdba@xxxxxxxxx> said:
I have an Oracle [1]9.2.0.7 database in Server ABC.
The [2]9.2.0.7 database has to be restored into server XYZ which has same
[3]9.2.0.7 installation except the directory structures are different in this
server.
e.g., Datafiles in the source server are in /u01/ORACLE/ and /u02/ORACLE/ and
the directory in which datafiles will be stored in XYZ Server is
/opt/oracle/admin/<database>/datafile/
So if I am using RMAN, how can I restore the database files into a different
directory structure in XYZ Server?
Anurag
References
1. http://9.2.0.7/
2. http://9.2.0.7/
3. http://9.2.0.7/
Other related posts:
