RMAN RAC 到 单实例 duplicate 自动分配通道 触发 ORA-19505 错误
来源:互联网 发布:linux终端删除~$ 编辑:程序博客网 时间:2024/05/02 01:11
用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
- RMAN RAC 到 单实例 duplicate 自动分配通道 触发 ORA-19505 错误
- RAC 实例 迁移到 单实例 -- 使用RMAN Duplicate
- RAC 实例 迁移到 单实例 -- 使用RMAN Duplicate
- RAC 实例 迁移到 单实例 -- 使用RMAN Duplicate
- RAC 实例 迁移到 单实例 -- 使用RMAN Duplicate
- RAC 实例迁移到单实例 -- 使用RMAN Duplicate
- RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误
- RAC RMAN 通道配置 RMAN-12001 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017 错误
- rman恢复rac到单实例数据库
- RAC 通过rman、duplicate迁移至单实例
- 用RMAN恢复RAC到单实例过程
- 使用RMAN恢复RAC备份到单实例
- RAC 通过rman迁移至单实例
- Oracle 单实例 迁移到 RAC 实例 -- 使用RMAN 异机恢复
- Oracle 单实例 迁移到 RAC 实例 -- 使用RMAN 异机恢复
- Oracle 单实例 迁移到 RAC 实例 -- 使用RMAN 异机恢复
- Oracle 单实例 迁移到 RAC 实例 -- 使用RMAN 异机恢复
- Oracle 单实例 迁移到 RAC 实例 --- 使用RMAN 异机恢复
- ThreadPoolExecutor使用和思考-线程池大小设置与BlockingQueue的三种实现区别
- python手记(17)
- 6174问题
- ext4-fs error (device dm-0) ext4_lookup deleted inode referenced
- 求一个矩阵最大子矩阵的算法模板
- RMAN RAC 到 单实例 duplicate 自动分配通道 触发 ORA-19505 错误
- 结构体对齐问题以及强制类型转换问题总结
- 快速MD5计算
- 利用amqplib测试rabbitmq
- 关于XX信息技术有限公司的面试经历
- 最短路变形 POJ 2253 Frogger
- 多线程编程--对pthread_cond_wait()函数的理解
- TextView使用笔记(一)——为TextView添加下划线或者删除线
- apache开启expires