Hi,
Through rman i restored the datafile to new location using set newname just for testing the original location of datafile was /disk1 i restored /disk2
below are th steps i did
step1
1)RMAN> run
2> {
3> set newname for datafile 1 to '/disk2/system01.dbf';
4> restore datafile 1;
5> }
>
restore was succesful
step 2
RMAN> startup nomount;
Oracle instance started
Total System Global Area 1073741824 bytes
Fixed Size 1265844 bytes
Variable Size 541069132 bytes
Database Buffers 520093696 bytes
Redo Buffers 11313152 bytes
RMAN>alter database mount
RMAN> restore datafile 1;
Starting restore at Nov 23 2010 15:47:55
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: restoring datafile 00001
input datafile copy recid=6 stamp=735837791 filename=/disk2/system01.dbf
destination for restore of datafile 00001: /disk1/system01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00001
output filename=/disk1/system01.dbf recid=7 stamp=735839302
Finished restore at Nov 23 2010 15:48:31
>
my question is when i am restoring it normal why it is looking for the location /disk2/system01.dbf to restore it in original location.it should restore from the database backupiece directly to the location of the original datafiles right.
And when i give restored database then also the above error is comming.When i am restoring using backuppiece tag then it is getting restore properly? why?
what i have to do to restore it in original location and change the rman configuration as if i didnt gave set new name command
Regards
sorry all it was my mistake i have changed the content of step 2 to the current one after reestore but my question is same it is still restoring tom /disk2/system01.dbf where as i want to pick restore from the backuppiece
Edited by: hungry_dba on Nov 23, 2010 3:55 PM