oracle dg的搭建无法convert的问题

lych528

主库：

show parameter convert;

db_file_name_convert                 string      /u01/oradata/primary, /u01/ora
                                                 data/standby
log_file_name_convert                string      /u01/oradata/primary, /u01/ora
                                                 data/standby



SQL> show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      AUTO


SQL> show parameter db_create_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string       /u01/oradata/primary/





备库：

SQL> show parameter convert;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      /u01/oradata/standby/, /u01/or
                                                 adata/primary/
log_file_name_convert                string      /u01/oradata/standby/, /u01/or
                                                 adata/primary/


SQL> show parameter db_create_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string      /u01/oradata/standby/



SQL> show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      AUTO




网络都是通的，报错如下：

主库执行duplicate报错：

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 10-FEB-15

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for tempfile  1 to
"/u01/oradata/primary/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to
"/u01/oradata/primary/system01.dbf";
   set newname for datafile  2 to
"/u01/oradata/primary/sysaux01.dbf";
   set newname for datafile  3 to
"/u01/oradata/primary/undotbs01.dbf";
   set newname for datafile  4 to
"/u01/oradata/primary/users01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format
"/u01/oradata/primary/system01.dbf"   datafile
2 auxiliary format
"/u01/oradata/primary/sysaux01.dbf"   datafile
3 auxiliary format
"/u01/oradata/primary/undotbs01.dbf"   datafile
4 auxiliary format
"/u01/oradata/primary/users01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/oradata/primary/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 10-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/oradata/primary/system01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/10/2015 02:00:18
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/oradata/primary/sysaux01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/10/2015 02:00:20
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/oradata/primary/undotbs01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/10/2015 02:00:21
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/oradata/primary/users01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/10/2015 02:00:22
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/10/2015 02:00:22
ORA-17628: Oracle error 19505 returned by remote Oracle server




查看备库trace日志：

Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/oradata/primary/standby2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 5 of thread 1
ORA-00312: online log 5 thread 1: '/u01/oradata/primary/standby2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/u01/oradata/primary/standby3.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 6 of thread 1
ORA-00312: online log 6 thread 1: '/u01/oradata/primary/standby3.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/oradata/primary/standby4.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_lgwr_2202.trc:
ORA-00313: open failed for members of log group 7 of thread 1
ORA-00312: online log 7 thread 1: '/u01/oradata/primary/standby4.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Tue Feb 10 09:59:14 2015
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_ora_2371.trc:
ORA-19505: failed to identify file "/u01/oradata/primary/undotbs01.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
Tue Feb 10 09:59:16 2015
Errors in file /u01/diag/rdbms/standby/standby/trace/standby_ora_2377.trc:
ORA-19505: failed to identify file "/u01/oradata/primary/users01.dbf"
ORA-27040: file create error, unable to create file





为什么设置了convert之后，控制文件可以convert过来，而数据文件跟日志文件却不行呢？还会去找/u01/oradata/primary目录，而我备库的数据文件跟日志文件存储的路径是/u01/oradata/standby？各位帮忙看看分析下这个原因

lych528

convert写反了，晕