Duplicate database on different host

Hi All,
I have taken rman backup on /u01 from primary database.
Now i want to clone this database on a different host.
I have copied the above backup to /u02 on the new host.
Now, to which rman repository should i catalog the backup copy on /u02 and also, while i create the duplicate database on new host, should i connect to rman catalog having the backup info on /u01.

Please let me know.

Thanks in advance.

regards
anandkl

just look at the documentation for cloning a database, it's all in there

Hi
I looked at the documentation. Most of them explain about backup location being the same on primary and clone db host.

If you dont mind can u please point me any link that has explanation from my request.

Thanks in advance.

regards
anandkl

Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)
Part Number B14191-03
http://download.oracle.com/docs/cd/B...2.htm#i1006532

Hi
I went through the doc in the link you provided, and found the below.

"Also, you must have RMAN backups of all datafiles available and a control file backup that is usable as a standby control file, and those backups must be accessible by the standby instance under the same name".

My issue is, i dont have the same directory structure on new host for storing the backup and restoring the datafiles.

On the source database, my backup is on /u01 and on the new host it is copied to /u02.

regards
anandkl

why are you reading about standby when what you want - as per your post - is to duplicate your database?

sorry, my mistake.
But, it does not mention about backups being copied to different directory on the new host.

When i copy the backup to different directory, i need to catalog that backup, so that i can use them in creating the duplicate database, using RMAN.


regards
anandkl

You should add these parameters to the init file of your target sid and Rman will put the data files in the correct locations.

Code:

---

db_file_name_convert=(/${SOURCE_SID}/,/${TARGET_SID}/)
log_file_name_convert=(/${SOURCE_SID}/,/${TARGET_SID}/)

---

Thanks a lot for the response.
But, my question is not about restoring the the datafiles into a different directory structure. Its about my current backup location.

On the primary database backup is on /u01, but on the new host its copied on /u02. So, if i need to restore this backup from /u02 using RMAN, this has to be cataloged into rman repository. Hence, i wanted to know, if i should catalog this in the rman repository on new host or the primary host.
Also, during restore operation on the new host, should i connect to rman reposritory have backup info on /u01.

regards
anandkl

If you run rman and connect to the catalog and try to clone rman will look for the directory where it thinks the correct backup is. You can also do the restore and recovery without the catalog just run rman and connect to the instance that you are cloning to. You will need to have the control files in place and the database mounted. Then you can restore the database.

Code:

---

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

---

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

Quote:

---

Originally Posted by 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

---

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.

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

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.

Code:

---

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

---