Welcome 微信登录

首页 / 数据库 / MySQL / ORA-19870、ORA-19573 错误解决一例

还原Oracle数据库时出现ORA-19870和ORA-19573错误,如:RMAN> restore database;
Starting restore at 11-DEC-12
using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/oradata/orcl/system01.dbf
restoring datafile 00002 to /u02/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u02/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u02/oradata/orcl/users01.dbf
restoring datafile 00005 to /u02/oradata/orcl/dolphin01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/dbf_07nsjs47_1_1.bak
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/11/2012 16:07:19
ORA-19870: error reading backup piece /home/oracle/backup/dbf_07nsjs47_1_1.bakORA-19573: cannot obtain exclusive enqueue for datafile 1该问题的原因是由于数据库处于open状态导致的,将数据库置于mount状态该问题即可解决。Oracle用delete命令删除数据恢复Oracle备份恢复之RMAN恢复到异机相关资讯      Oracle错误代码  ORA-19870  ORA-19573 
  • Oracle错误代码大全  (02/16/2015 21:31:57)
  • RMAN转储数据文件报错“ORA-19870   (01/23/2014 20:03:24)
  • Oracle中登陆时报ORA-28000: the   (03/06/2013 20:06:23)
  • rman 恢复数据错误案例--ORA-19573  (05/20/2014 22:29:37)
  • Oracle Grid Control OUI-25031错  (03/09/2013 09:01:36)
  • ORA-04091:触发器/函数不能读  (02/25/2013 08:28:13)
本文评论 查看全部评论 (0)
表情: 姓名: 字数