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: 251097186

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

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

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