Re: Creating a database from rman backup

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: kat.axe@xxxxxxxxx
  • Date: Wed, 19 May 2010 14:13:57 -0300

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
>>
>
>

Other related posts: