Re: Question on RMAN Restore into another server having different file structure

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_at_gmail.com> 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/

--
http://www.freelists.org/webpage/oracle-l