RMAN 数据库克隆文件位置转换方法 - 数据库编程

configure auxname是在Oracle 11g开始提供的新命令，该配置命令会将其值存储在目标数据库的控制文件中
用法如下:
configure auxname for datafile n to '/file_name';
configure auxname for datafile n clear;

如下面是设置之后的结果:
RMAN> show auxname;

RMAN configuration parameters for database with db_unique_name SYBO3 are:
CONFIGURE AUXNAME FOR DATAFILE '/u01/database/sybo3/oradata/system01.dbf' TO '/u01/database/sybo5/oradata/system01.dbf';
CONFIGURE AUXNAME FOR DATAFILE '/u01/database/sybo3/oradata/sysaux01.dbf' TO '/u01/database/sybo5/oradata/sysaux01.dbf';
CONFIGURE AUXNAME FOR DATAFILE '/u01/database/sybo3/oradata/undotbs01.dbf' TO '/u01/database/sybo5/oradata/undotbs01.dbf';
CONFIGURE AUXNAME FOR DATAFILE '/u01/database/sybo3/oradata/users01.dbf' TO '/u01/database/sybo5/oradata/users01.dbf';
CONFIGURE AUXNAME FOR DATAFILE '/u01/database/sybo3/oradata/example01.dbf' TO '/u01/database/sybo5/oradata/example01.dbf';

RMAN>run
{
set until time = "to_date('20130725 10:09:53','yyyymmdd hh24:mi:ss')"; -->可以指定time,scn,sequence
set newname for tempfile 1 TO '/u01/database/sybo5/oradata/temp01.dbf'; -->注意，configure auxname不支持tempfile,此处需要使用set newname
duplicate target database to clone_db pfile=/u01/oracle/db_1/dbs/initsybo5.ora
logfile
'/u01/database/sybo5/redo/redo01a.log' SIZE 5M,
'/u01/database/sybo5/redo/redo02a.log' SIZE 5M,
'/u01/database/sybo5/redo/redo03a.log' SIZE 5M;
}

相关阅读：

RMAN 数据库克隆文件位置转换方法(二)