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 <
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;
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" ????
allocate channel ch00 type disk ..............;
set newname for datafile ........
P.S. I am sorry my bad English.
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.
Last edited by Thomasps; 06-14-2006 at 05:57 AM.
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
Last edited by hrishy; 06-14-2006 at 06:32 AM.
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
Thanks. I know this metod (use NFS ......) but I want recover DB using RMAN's backup files.
Click Here to Expand Forum to Full Width