ITPub博客

首页 > 数据库 > Oracle > Oracle ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解决方法

Oracle ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解决方法

原创 Oracle 作者:lovehewenyu 时间:2013-07-29 10:41:34 0 删除 编辑

ORA-19573: cannot obtain exclusive enqueue for datafile XXX 解决方法

 

一个朋友说自己使用 RMAN 进行恢复 datafile 3 ,出现 ORA-19573 ,不能正常恢复。与朋友沟通,朋友执行恢复的时候,竟还有实例处于 OPEN 状态。把所有实例 mount 后,恢复成功

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 07/26/2013 11:45:33

ORA-19870: error while restoring backup piece /rman/backup/data/level0_RACDB_93_1_2tofn3hn_20130726.bak

ORA-19573: cannot obtain exclusive enqueue for datafile 3

 

[oracle@racdb 2 rman]$ oerr ora 19573

19573, 00000, "cannot obtain %s enqueue for datafile %s"

// *Cause:   The file access enqueue could not be obtained for a file

//           specified in a backup, copy or restore operation.

//           If the enqueue type shown is 'shared', then the file is the

//           input file for a backup or copy.   If the type is 'exclusive', then

//           the file is the output file for a datafile copy or restore which

//           is attempting to overwrite the currently active version of that

//           file - in this case, the file must be offline or the database must

//           be closed.   If the type is 'read-only', then you are attempting

//           to back up or copy this file while the database is in NOARCHIVELOG

//           mode.

// *Action: Wait until the conflicting operation is complete, then retry

//           the copy or backup.   If the database is in NOARCHIVELOG mode, then

//           all files being backed up must be closed cleanly.

 

 

解决方法:所有实例 mount 状态下执行恢复!

 

 

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26442936/viewspace-767331/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
10年金融行业老鸟。Oracle,Mysql,PostgreSQL,EMC 存储,NBU备份。微信/电话 18211103995

注册时间:2012-02-03

  • 博文量
    307
  • 访问量
    1528549