How can I move RMAN's backup set to another place ???

Oracle8i, RHEL4. RMAN not use catalog.

I have done backup use RMAN at host_A (path /oracle).

rman target / nocatalog log rman_full_backup.log < run
{
allocate channel ch00 type disk;
set limit channel ch00 kbytes = 100000;
backup database format='/oracle/%d_DB_%u.rman';
sql 'alter system archive log current';
backup current controlfile format='/oracle/control.rman';
release channel ch00;
}
EOF

I have copy this files to another host_B to the another path (/oracle2)

And I want to recover this DB to another place and I do not know how can I indicate to RMAN where it find this file "%d_DB_%u.rman" ????

run
{
allocate channel ch00 type disk ..............;
.................
set newname for datafile ........
............
}
P.S. I am sorry my bad English.

Read about RMAN DUPLICATE

http://download-west.oracle.com/docs...pdb.htm#441628

I have seen this documentation and have not seen there where I can to change path to the RMAN's backup set :((

you dont, you use the duplicate command to do it all for you

Your target database controlfile contains the backup information and that will be used for creating the Aux database. You don't need to copy the RMAN backup sets to the Aux DB server.

I understand, thanks ! But I have next situation. I do backup DB every day.And this backup store at the production server (host_A). But now I need startup this DB on the another host_B where a different directory structure. I want recover this DB on the host_B from RMAN's backup set.
I understand that I can to make link (ln -s ....) or such directory structure or using standart HotBackup but I do not want it. I want recover database on the host_B from old RMAN's backup set which I have copyed to host_B to the another directory :)

Did you read the docs..?

DB_FILE_NAME_CONVERT=(/oracle/prod/db,/oracle/dup_prod/db) to move the datafile to a different FS Structure.

And DON"T copy the backups. if you wanna ause old backup set use "SET UNTIL TIME " so rman use the backup accordingly.

Hi

http://download-uk.oracle.com/docs/c...cmdupdb004.htm

Hi

During restore, RMAN will expect the backup sets to be located in the same directory as written to during the backup.
For disk backups, the DBA can
accomplish this in many ways:

- set up an NFS directory, mounted on both host A and host B
- create the same directory structure on host A and host B
- use of symbolic links on host

You can also explore the backup as backupset option if you dont wnat symbolic links and want to move the backupset to another location and NFS mount that another location

regards
Hrishy

to Thomasps. Thanks ! :)
But DB_FILE_NAME_CONVERT convert name of db_files but not the RMAN's backup files. I backuped to "backup database format='/oracle/%d_DB_%u.rman';"
Then I copy %d_DB_%u.rman to host_B to the another path !!!! /ORACLE2 and then I want to restore use RMAN but it can not find file "%d_DB_%u.rman" because it is /ORACLE2/%d_DB_%u.rman

to hrishy
Thanks. I know this metod (use NFS ......) but I want recover DB using RMAN's backup files.

Hi

When you are using NFS you are ultimately using RMAN's backup only to restore.The target host has to have acesses to the backup files created by RMAN.

If you do not want to do this then you should configure your media manager in such a way that Host B is the client for restoring the backupset.

regards
Hrishy

How I can configure my media manager in such a way that Host B is the client for restoring the backupset. And not use catalog. I do not know :)

What is Media manager ???? Is it tape ????

time to read the docs for you (again) tahiti.oracle.com - it really does answer all your questions

Hi

Media manger is a piece of software that manges your backup to tapes.

Contact your sysadmin for that

regards
Hrishy

Quote:

---

Originally Posted by hrishy

During restore, RMAN will expect the backup sets to be located in the same directory as written to during the backup.

---

That's what I found for 8i - a right pain in the butt. (Has it changed for more recent releases?)

You can change the directory structure completely for the restored DB, but the backup pieces MUST be in the directory where RMAN put them (even when cloning to a different box).

Hi Dapi

I dont think so .But there is something called the backup of backupset from 9i onwards by making use of which we can copy a backupset from one location to another and the restore can pick it from the new location.

regards
Hrishy