It is trival to do in 11g as follows: duplicate target database to dupbcm from active database spfile parameter_value_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupbcm' set log_file_name_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupbcm' set db_file_name_convert '/home/oracle/oradata/orcl', '/home/oracle/oradata/dupbcm';