you can also use the 'set newname for datafile 1 to '<new_path>'; This is a fun excercise, I'd suggest you try it a few times before doing it in production, though. pointers: current DB: target, new db (must be STARTED): auxiliary commando: duplicate database to auxiliary; hth Alan.- On Wed, May 19, 2010 at 1:03 PM, kathryn axelrod <kat.axe@xxxxxxxxx> wrote: > Use RMAN's 'duplicate'. > Since the directory paths are different, you will either use 'set newname' > or 'db_file_name_convert' & 'log_file_name_convert' > > > http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BGBHBIFE > > > On Wed, May 19, 2010 at 8:45 AM, KRISHNA MOORTHY <krish33moorthy@xxxxxxxxx > > wrote: > >> Hi All, >> >> How can I create a database from the RMAN backup >> >> 1. I have a RMAN complete database backup (includes control file, >> datafiles, archived log file )at server A >> 2. I have to create a NEW database using the backup at server B >> 3. Server A and B does not have connection. >> 4. Mount Points of server A and server B is different... >> >> Can you please provide the steps. >> >> Regards >> Krishna >> > >