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