ITPub博客

首页 > 数据库 > Oracle > RMAN-05501: aborting duplication of target database

RMAN-05501: aborting duplication of target database

原创 Oracle 作者:wenjunheyixiao 时间:2016-07-15 16:43:21 0 删除 编辑

1.       

问题:

在搭建DG的时候,duplicate的时候出现以下错误;

Starting backup at 15-JUL-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

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

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:52:57

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/prod1/sysaux01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:52:59

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=00005 name=/u01/app/oracle/oradata/prod1/example01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:53:00

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/prod1/undotbs01.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/15/2016 14:53:01

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/prod1/users01.dbf

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

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

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

RMAN-03002: failure of Duplicate Db command at 07/15/2016 14:53:02

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 07/15/2016 14:53:02

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

2.

原因:

参数文件错误:

[oracle@prod1 dbs]$ cat initprod1.ora

prod1.__db_cache_size=348127232

prod1.__java_pool_size=4194304

prod1.__large_pool_size=8388608

prod1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

prod1.__pga_aggregate_target=335544320

prod1.__sga_target=499122176

prod1.__shared_io_pool_size=0

prod1.__shared_pool_size=125829120

prod1.__streams_pool_size=0

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

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/u01/app/oracle/oradata/prod1/control01.ctl','/u01/app/oracle/fast_recovery_area/prod1/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='prod1'

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

*.db_recovery_file_dest_size=4385144832

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

*.dispatchers='(PROTOCOL=TCP) (SERVICE=prod1XDB)'

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=833617920

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

DB_UNIQUE_NAME=prod1

LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod1,enmoedu2)'

LOG_ARCHIVE_DEST_1=

 'LOCATION=DB_RECOVERY_FILE_DEST

  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

  DB_UNIQUE_NAME=prod1'

LOG_ARCHIVE_DEST_2=

 'SERVICE=enmoedu2 ASYNC

  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

  DB_UNIQUE_NAME=enmoedu2'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

FAL_SERVER=enmoedu2

DB_FILE_NAME_CONVERT='enmoedu2','prod1'

LOG_FILE_NAME_CONVERT='enmoedu2','prod1'

STANDBY_FILE_MANAGEMENT=AUTO

 

3

验证:

 

[oracle@prod1 dbs]$ rman target sys/oracle@prod1 auxiliary sys/oracle@enmoedu2

 

Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 15 15:38:51 2016

 

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: PROD1 (DBID=2128946428)

connected to auxiliary database: PROD1 (not mounted)

 

RMAN> duplicate target database for standby from active database;

 

Starting Duplicate Db at 15-JUL-16

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=10 device type=DISK

 

contents of Memory Script:

{

   backup as copy reuse

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

 '/u01/app/oracle/product/11.2.0.1/db_1/dbs/orapwenmoedu2'   ;

}

executing Memory Script

 

Starting backup at 15-JUL-16

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=144 device type=DISK

Finished backup at 15-JUL-16

 

contents of Memory Script:

{

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

   restore clone controlfile to  '/u01/app/oracle/fast_recovery_area/enmoedu2/control02.ctl' from

 '/u01/app/oracle/oradata/enmoedu2/control01.ctl';

}

executing Memory Script

 

Starting backup at 15-JUL-16

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_prod1.f tag=TAG20160715T153908 RECID=20 STAMP=917278749

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

Finished backup at 15-JUL-16

 

Starting restore at 15-JUL-16

using channel ORA_AUX_DISK_1

 

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 15-JUL-16

 

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/enmoedu2/temp01.dbf";

   switch clone tempfile all;

   set newname for datafile  1 to

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

   set newname for datafile  2 to

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

   set newname for datafile  3 to

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

   set newname for datafile  4 to

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

   set newname for datafile  5 to

 "/u01/app/oracle/oradata/enmoedu2/example01.dbf";

   backup as copy reuse

   datafile  1 auxiliary format

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

 2 auxiliary format

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

 3 auxiliary format

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

 4 auxiliary format

 "/u01/app/oracle/oradata/enmoedu2/users01.dbf"   datafile

 5 auxiliary format

 "/u01/app/oracle/oradata/enmoedu2/example01.dbf"   ;

   sql 'alter system archive log current';

}

executing Memory Script

 

executing command: SET NEWNAME

 

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

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

executing command: SET NEWNAME

 

Starting backup at 15-JUL-16

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

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

output file name=/u01/app/oracle/oradata/enmoedu2/system01.dbf tag=TAG20160715T153916

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

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/u01/app/oracle/oradata/prod1/sysaux01.dbf

output file name=/u01/app/oracle/oradata/enmoedu2/sysaux01.dbf tag=TAG20160715T153916

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

channel ORA_DISK_1: starting datafile copy

input datafile file number=00005 name=/u01/app/oracle/oradata/prod1/example01.dbf

output file name=/u01/app/oracle/oradata/enmoedu2/example01.dbf tag=TAG20160715T153916

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

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/prod1/undotbs01.dbf

output file name=/u01/app/oracle/oradata/enmoedu2/undotbs01.dbf tag=TAG20160715T153916

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

channel ORA_DISK_1: starting datafile copy

input datafile file number=00004 name=/u01/app/oracle/oradata/prod1/users01.dbf

output file name=/u01/app/oracle/oradata/enmoedu2/users01.dbf tag=TAG20160715T153916

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

Finished backup at 15-JUL-16

 

sql statement: alter system archive log current

 

contents of Memory Script:

{

   switch clone datafile all;

}

executing Memory Script

 

datafile 1 switched to datafile copy

input datafile copy RECID=20 STAMP=917278799 file name=/u01/app/oracle/oradata/enmoedu2/system01.dbf

datafile 2 switched to datafile copy

input datafile copy RECID=21 STAMP=917278799 file name=/u01/app/oracle/oradata/enmoedu2/sysaux01.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=22 STAMP=917278799 file name=/u01/app/oracle/oradata/enmoedu2/undotbs01.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=23 STAMP=917278799 file name=/u01/app/oracle/oradata/enmoedu2/users01.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=24 STAMP=917278799 file name=/u01/app/oracle/oradata/enmoedu2/example01.dbf

Finished Duplicate Db at 15-JUL-16

 

4

总结:

作为一个DBA,一定要认真,一定要仔细。今天报错的时候,我心理特别着急,各种排错,各种网上百度解决方法,可是就是没有静下心来,仔细看看我的问题到底出在哪里了,什么地方不合适??就一味的百度,最后静下心来一步一步检查的时候,才发现原来是参数文件的一个地方位置写错了,才会报了看起来很严重的错误。比较惭愧。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30606702/viewspace-2122076/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-12-02

  • 博文量
    117
  • 访问量
    162120