Errors with RMAN duplicate database

From: Steven Alfisi <steven_at_alfisi.com>
Date: 6 Jan 2003 18:11:17 -0800
Message-ID: <a05aabfc.0301061811.74dcdcd3@posting.google.com>

I am running Oracle 9i (9.0.1.0.0) on SuSE linux 7.3 pro. I am trying to use RMAN to create a duplicate database (different name on the same server). I have created the necessary folders, init.ora, password file, etc. I am using the DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters in the init.ora file for the clone database (listed below). My problem is I am getting the RMAN-05001 error saying there is already a file with that name. If I use the set newname command in the RMAN run block it works fine. Why does this not work with the NAME_CONVERT init.ora parameters?

• INIT.ORA NAME_CONVERT parameters. These also show up when doing SHOW PARAMETER CONVERT when connected to the clone database when it's in nomount mode.

db_file_name_convert = ('/DATA/ORACLE/ORADATA/HOMEBD',
'/DATA/ORACLE/ORADATA/CLNE')

log_file_name_convert = ('/DATA/ORACLE/ORADATA/HOMEDB',
'/DATA/ORACLE/ORADATA/CLNE')

• RMAN script without SET NEWNAME

run {
 set until logseq 18 thread 1;
 allocate auxiliary channel d1 type disk;  duplicate target database to CLNE

  logfile '/data/oracle/oradata/clne/redo01.log' size 100M,
  '/data/oracle/oradata/clne/redo02.log' size 100M,
  '/data/oracle/oradata/clne/redo03.log' size 100M;

}

• RMAN script with SET NEWNAME

run {
 set newname for datafile 1 to
'/data/oracle/oradata/clne/system01.dbf';
 set newname for datafile 2 to
'/data/oracle/oradata/clne/undotbs01.dbf';
 set newname for datafile 3 to
'/data/oracle/oradata/clne/cwmlite01.dbf';
 set newname for datafile 4 to
'/data/oracle/oradata/clne/drsys01.dbf';
 set newname for datafile 5 to
'/data/oracle/oradata/clne/example01.dbf';
 set newname for datafile 6 to '/data/oracle/oradata/clne/indx01.dbf';  set newname for datafile 7 to
'/data/oracle/oradata/clne/tools01.dbf';
 set newname for datafile 8 to
'/data/oracle/oradata/clne/users01.dbf';
 set until logseq 18 thread 1;
 allocate auxiliary channel d1 type disk;  duplicate target database to CLNE

  logfile '/data/oracle/oradata/clne/redo01.log' size 100M,
  '/data/oracle/oradata/clne/redo02.log' size 100M,
  '/data/oracle/oradata/clne/redo03.log' size 100M;

} Received on Mon Jan 06 2003 - 20:11:17 CST