Duplicate database on different host

[anandakl]

Hi,
What you say would work if /u01(backup file system) is also mounted on the new host.
But, i can't do that, the backup has been copied over to /u02.
How will rman know that the backup is on /u02 and perfrom resoter and recovery into the new host.

regards
anandkl

[philthee]

Hi,
What you say would work if /u01(backup file system) is also mounted on the new host.
But, i can't do that, the backup has been copied over to /u02.
How will rman know that the backup is on /u02 and perfrom resoter and recovery into the new host.

regards
anandkl

Will rman not copy the backup from serverA (backup location /u01) and restore to serverB (where you want the duplicate)?
We use netbackup and so our rman backups are stored on tape.
All we need to do on the auxiliary server is
rman target sys/password@live auxiliary / catalog rman/rman@rman-live
then
run {
allocate auxiliary channel ch00 type ‘SBT_TAPE’;
set until time ‘2010-03-25 08:00:00’;
duplicate target database to PHILBASE nofilenamecheck;
release channel ch00;
}
(or something like that)

rman will take the backup from tape and put on serverB whereever we have specified in pfile/spfile
db_file_name_convert=(/${SOURCE_SID}/,/${TARGET_SID}/)
log_file_name_convert=(/${SOURCE_SID}/,/${TARGET_SID}/)

not sure how this worls server-server rather than tape-server.

[anandakl]

If /u01(containing rman backup) is also accessable from new host, then rman will restored the database on the new host.

But i cannot get to mount /u01 on the new host, hence i have copied the backup to /u02 and this information needs to be there in rman repository.
I wanted to know on, if i need in which rman repository should i register this. Is it on the target host or auxillary host.

regards
anandkl

[gandolf989]

You don't need to connect to the repository to do this,
you can do it manually by pointing to the back up you want.

RUN {
  ALLOCATE CHANNEL C1 DEVICE TYPE 
    DISK format '/u02/rman/mydb/bck_20100323';
  RESTORE DATABASE;
  RECOVER DATABASE;
}