RMAN RAC 到 单实例 duplicate 自动分配通道 触发 ORA-19505 错误

用RMAN Duplicate来搭建RAC 到 单实例的Data Guard，结果在duplicate时，触发ORA-19505的错误，如下：

ORA-19505:failed to identify file "/u01/app/oracle/11.2.0/db_1/dbs/orapwdave1"

 

看了一下log，修改了一下通道数量，再次duplicate 成功。

 

一. 报错的情况

RMAN> show all;

 

RMAN configuration parameters for databasewith db_unique_name DAVE are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;# default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPEDISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; #default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/u01/app/oracle/11.2.0/db_1/dbs/snapcf_dave1.f'; # default

 

 

 

RMAN> duplicate targetdatabase for standby from active database;

 

Starting Duplicate Db at 03-JUL-13

using target database control file insteadof recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 devicetype=DISK

allocated channel: ORA_AUX_DISK_2

channel ORA_AUX_DISK_2: SID=20 devicetype=DISK

allocated channel: ORA_AUX_DISK_3

channel ORA_AUX_DISK_3: SID=21 devicetype=DISK

allocated channel: ORA_AUX_DISK_4

channel ORA_AUX_DISK_4: SID=22 devicetype=DISK

 

contents of Memory Script:

{

  backup as copy reuse

  targetfile '/u01/app/oracle/11.2.0/db_1/dbs/orapwdave1' auxiliary format

 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdave'   ;

}

executing Memory Script

 

Starting backup at 03-JUL-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1:SID=43 instance=dave2 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2:SID=63 instance=dave1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3:SID=42 instance=dave2 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4:SID=55 instance=dave1 device type=DISK

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

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

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

RMAN-03002: failure of Duplicate Db commandat 07/03/2013 01:44:01

RMAN-05501: aborting duplication of targetdatabase

RMAN-03015: error occurred in stored scriptMemory Script

RMAN-03009: failure of backup command onORA_DISK_1 channel at 07/03/2013 01:44:01

ORA-19505: failed toidentify file "/u01/app/oracle/11.2.0/db_1/dbs/orapwdave1"

ORA-27037: unable toobtain file status

Linux-x86_64 Error: 2: Nosuch file or directory

Additional information: 3

 

这里的文件我之前创建过，在每个节点都存在。

 

 

二. 修改通道后成功执行

 

RMAN> configuredevice type disk parallelism 2;

 

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 4BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE DISK PARALLELISM 2BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters aresuccessfully stored

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

released channel: ORA_DISK_4

released channel: ORA_AUX_DISK_1

released channel: ORA_AUX_DISK_2

released channel: ORA_AUX_DISK_3

released channel: ORA_AUX_DISK_4

 

RMAN> duplicate targetdatabase for standby from active database;

 

Starting Duplicate Db at 03-JUL-13

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=19 devicetype=DISK

allocated channel: ORA_AUX_DISK_2

channel ORA_AUX_DISK_2: SID=20 devicetype=DISK

 

contents of Memory Script:

{

  backup as copy reuse

  targetfile '/u01/app/oracle/11.2.0/db_1/dbs/orapwdave1' auxiliary format

 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwdave'   ;

}

executing Memory Script

 

Starting backup at 03-JUL-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1:SID=63 instance=dave1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2:SID=55 instance=dave1 device type=DISK

Finished backup at 03-JUL-13

 

contents of Memory Script:

{

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

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

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

}

executing Memory Script

 

 

 

原因根据红色标记处思考。 我这里是通过修改通道数量来解决的，还有另一种解决方法，就是分别在两个节点创建另一个节点的口令文件。

 

有兴趣的同学，可以自己测试一下。

 

 

 

 

 

 

 

 

 

--------------------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

QQ:492913789

Email:ahdba@qq.com

Blog:  http://www.cndba.cn/dave

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware