建auxiliary数据库时，照《Creating and Updating Duplicate Databases with RMAN》中的例子建立init.ora。

示例文件：
DB_NAME=newdb
CONTROL_FILES=(/dup/oracle/oradata/trgt/control01.ctl,
               /dup/oracle/oradata/trgt/control02.ctl)
# note that the following two initialization parameters have equivalents
# on the DUPLICATE command itself
DB_FILE_NAME_CONVERT=(/oracle/oradata/trgt/,/dup/oracle/oradata/trgt/)
LOG_FILE_NAME_CONVERT=(/oracle/oradata/trgt/redo,/dup/oracle/oradata/trgt/redo)

改为Windows平台适用：
DB_NAME=auxi
CONTROL_FILES=(D:\oracle\product\10.2.0\oradata\auxiliary\control01.ctl,
               D:\oracle\product\10.2.0\oradata\auxiliary\control02.ctl)
# note that the following two initialization parameters have equivalents
# on the DUPLICATE command itself
DB_FILE_NAME_CONVERT=(D:\oracle\product\10.2.0\oradata\test\,D:\oracle\product\10.2.0\oradata\auxiliary\)
LOG_FILE_NAME_CONVERT=(D:\oracle\product\10.2.0\oradata\test\,D:\oracle\product\10.2.0\oradata\auxiliary\)

SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 7月 1 23:23:04 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

已连接到空闲例程。

SQL> create spfile from pfile;
create spfile from pfile
*
第 1 行出现错误:
ORA-01078: failure in processing system parameters
LRM-00116: syntax error at 'LOG_FILE_NAME_CO' following 'D:\oracle\produc'

修正init.ora中表达式，给路径加上双引号：
DB_FILE_NAME_CONVERT=("D:\oracle\product\10.2.0\oradata\test\","D:\oracle\product\10.2.0\oradata\auxiliary\")
LOG_FILE_NAME_CONVERT=("D:\oracle\product\10.2.0\oradata\test\","D:\oracle\product\10.2.0\oradata\auxiliary\")

SQL> create spfile from pfile;

文件已创建。

Related posts:

1. compatible参数
2. Oracle 10g 手动建库
3. RMAN TAG参数的禁区
4. Listerner.ora写法问题导致的监听器启动失败