Oracle Database Discussions

Hi,

We have an Oracle 10g Database (10.2.0.4) on AIX (6.1). We taken backup from another and then moved to the files to the new machine.

First the backup files catalog as follows;

RMAN> run
2> {
3> catalog backuppiece '/u01/backup/TESTENV_06lpi3e4.bkp';
4> catalog backuppiece '/u01/backup/TESTENV_0glpi5jg.bkp';
5> catalog backuppiece '/u01/backup/TESTENV_0elpi55n.bkp';
6> catalog backuppiece '/u01/backup/TESTENV_0flpi58h.bkp';
7> catalog backuppiece '/u01/backup/TESTENV_07lpi3e4.bkp';
8> catalog backuppiece '/u01/backup/TESTENV_08lpi3e4.bkp';
9> catalog backuppiece '/u01/backup/TESTENV_0ilpi5l1.bkp';
10> catalog backuppiece '/u01/backup/TESTENV_09lpi3e4.bkp';
11> catalog backuppiece '/u01/backup/TESTENV_0jlpi626.bkp';
12> catalog backuppiece '/u01/backup/TESTENV_0alpi44r.bkp';
13> catalog backuppiece '/u01/backup/TESTENV_0klpi63f.bkp';
14> catalog backuppiece '/u01/backup/TESTENV_0blpi46c.bkp';
15> catalog backuppiece '/u01/backup/TESTENV_0clpi4m3.bkp';
16> catalog backuppiece '/u01/backup/TESTENV_0dlpi4tr.bkp';
17> }

Now we set newname

RMAN> run
2> {
3> set newname for datafile 11 to '/u011/orccle/proddctc/ckd01.dbf';
4> set newname for datafile 12 to '/u015/orccle/proddctc/ckx01.dbf';
5> set newname for datafile 13 to '/u011/orccle/proddctc/clrd01.dbf';
6> set newname for datafile 14 to '/u015/orccle/proddctc/clrx01.dbf';
7> set newname for datafile 15 to '/u011/orccle/proddctc/cmsd01.dbf';
8> set newname for datafile 16 to '/u015/orccle/proddctc/cmsx01.dbf';
9> set newname for datafile 17 to '/u011/orccle/proddctc/cmvd01.dbf';
10> set newname for datafile 18 to '/u015/orccle/proddctc/cmvx01.dbf';
11> set newname for datafile 19 to '/u011/orccle/proddctc/cpd01.dbf';
12> set newname for datafile 20 to '/u015/orccle/proddctc/cpx01.dbf';
13> set newname for datafile 21 to '/u011/orccle/proddctc/cpplyyyd01.dbf';
14> set newname for datafile 22 to'/u015/orccle/proddctc/cpplyyyx01.dbf';
15> }

It fails as paths/locations on the new system are different. Please advice.

Regards