Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set newname for datafiles

007Nov 11 2012 — edited Nov 12 2012
Hi,

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
This post has been answered by Shivananda Rao on Nov 11 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2012
Added on Nov 11 2012
7 comments
24,219 views