Another option is (i'm guessing the backup is to disk):
copy the rman backup sets
start the new instance in NOMOUNT;
restore controlfile from 'backupset_name'
set newname for datafile # to '';
restore and recover database using backup controlfile
create redo log files
create tempfiles
open database using retelogs;
if you need to set a new name, use the nid tool to rename it after the
resetlogs operation.
hth
Alan.-
On Wed, May 19, 2010 at 2:13 PM, Guillermo Alan Bort
wrote:
you can also use the 'set newname for datafile 1 to '';
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.-
--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 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_at_gmail.com> 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_at_gmail.com> 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
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
http://www.freelists.org/webpage/oracle-l