Welcome 微信登录

首页 / 数据库 / MySQL / rman 恢复数据错误案例--ORA-19573 错误

系统环境:
操作系统: AIX 5300-08
Oracle: Oracle 10.2.0.1.0错误现象:RMAN> restore datafile 4;
Starting restore at 20-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u01/app/oracle/oradata/prod/users01.dbf
channel ORA_DISK_1: reading from backup piece /backup/inc0_PROD_2qp8omr6_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/20/2014 12:19:41
ORA-19870: error reading backup piece /backup/inc0_PROD_2qp8omr6_1_1
ORA-19573: cannot obtain exclusive enqueue for datafile 4一直以为是备份有问题,没有找到备份的数据文件!原来是DataBase 在open下,忘了将datafile offline,造成此低级错误;将数据文件offline 后,问题解决!--------------------------------------分割线 --------------------------------------推荐阅读:RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址