Set newname for datafiles
007Nov 11 2012 — edited Nov 12 2012Hi,
I am using oracle 10g (10.2.0.1) in RHEL 5 server. I am trying to restore a RMAN full backup in another server with different directory structure. I have cataloged the backup using the below command
RMAN> catalog start with '/u01/backupset/o1_mf_nnndf_FULLBKP_88zqky0p_.bkp';
using target database control file instead of recovery catalog
searching for all files that match the pattern /u01/backupset/o1_mf_nnndf_FULLBKP_88zqky0p_.bkp
no files found to be unknown to the database
Then issued the set new name command
run{
2> set newname for datafile 1 to '/u01/app/oracle/oradata/DEVDB/datafile/system1.dbf';}
executing command: SET NEWNAME
RMAN>
Now when i issue the restore datafile 1 command i get restored in different location
restore datafile 1;
Starting restore at 11-NOV-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to */u01/app/oracle/oradata/ORADB/datafile/o1_mf_system_89zlhw35_.dbf*
channel ORA_DISK_1: reading from backup piece /u01/backupset/o1_mf_nnndf_FULLBKP_88zqky0p_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/backupset/o1_mf_nnndf_FULLBKP_88zqky0p_.bkp tag=FULLBKP
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 11-NOV-12
But i have issued the */u01/app/oracle/oradata/DEVDB/datafile/system1.dbf* in set newname command.
My datafile locations in the source database server is */data/u01/app/oracle/oradata/ORADB/datafile*
Is this a bug in 10.2.0.1 ?? or am i missing out anything??
Thanks in advance
Regards,
007