dataguard mysql,搭建dataguard在同步数据时报错

从库spfile

*.audit_file_dest='/u01/app/oracle/admin/mydbbk/adump'

*.compatible='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/mydbbk/control01.ctl'#Restore Controlfile

*.db_name='mydb'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4385144832

*.diagnostic_dest='/u01/app/oracle'

*.pga_aggregate_target=314572800

*.sga_target=465567744

*.undo_tablespace='UNDOTBS1'

db_unique_name='mydbbk'

standby_file_management=auto

log_archive_dest_3='location=/home/oracle/arc_mydbbk_dest_3 valid_for=(standby_logfiles,standby_role) db_unique_name=mydbbk'

log_archive_dest_state_3='enable'

db_file_name_convert='/u01/app/oracle/oradata/mydb/','u01/app/oracle/oradata/mydbbk/'

log_file_name_convert='/u01/app/oracle/oradata/mydb/','u01/app/oracle/oradata/mydbbk/'

相关报错如下：

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 15-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=5 device type=DISK

contents of Memory Script:

{

backup as copy reuse

targetfile  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwmydb' auxiliary format

'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwmydbbk'   ;

}

executing Memory Script

Starting backup at 15-JUN-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=12 device type=DISK

Finished backup at 15-JUN-17

contents of Memory Script:

{

backup as copy current controlfile for standby auxiliary format  '/u01/app/oracle/oradata/mydbbk/control01.ctl';

}

executing Memory Script

Starting backup at 15-JUN-17

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

copying standby control file

output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_mydb.f tag=TAG20170615T000417 RECID=2 STAMP=946685058

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 15-JUN-17

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/app/oracle/oradata/mydbbk/temp01.dbf";

switch clone tempfile all;

set newname for datafile  1 to

"u01/app/oracle/oradata/mydbbk/system01.dbf";

set newname for datafile  2 to

"u01/app/oracle/oradata/mydbbk/sysaux01.dbf";

set newname for datafile  3 to

"u01/app/oracle/oradata/mydbbk/undotbs01.dbf";

set newname for datafile  4 to

"u01/app/oracle/oradata/mydbbk/users01.dbf";

backup as copy reuse

datafile  1 auxiliary format

"u01/app/oracle/oradata/mydbbk/system01.dbf"   datafile

2 auxiliary format

"u01/app/oracle/oradata/mydbbk/sysaux01.dbf"   datafile

3 auxiliary format

"u01/app/oracle/oradata/mydbbk/undotbs01.dbf"   datafile

4 auxiliary format

"u01/app/oracle/oradata/mydbbk/users01.dbf"   ;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to u01/app/oracle/oradata/mydbbk/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 15-JUN-17

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00001 name=/u01/app/oracle/oradata/mydb/system01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2017 00:04:28

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/app/oracle/oradata/mydb/sysaux01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2017 00:04:29

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/app/oracle/oradata/mydb/undotbs01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2017 00:04:30

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/app/oracle/oradata/mydb/users01.dbf

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 06/15/2017 00:04:31

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 06/15/2017 00:04:31

ORA-17628: Oracle error 19505 returned by remote Oracle server

查询从库alert得知，是spfile中convert 目录错误，经查看，转换目录缺少/