oracle dg的搭建无法convert的问题
主库：
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？各位帮忙看看分析下这个原因
convert写反了，晕
页:
[1]